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

Line 12: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE

8: -- API name : Update_Project_Dates
9: -- Type : Public
10: -- Pre-reqs : None.
11: -- Parameters :
12: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
13: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
14: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
15: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
16: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'

Line 13: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE

9: -- Type : Public
10: -- Pre-reqs : None.
11: -- Parameters :
12: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
13: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
14: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
15: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
16: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
17: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM

Line 14: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

10: -- Pre-reqs : None.
11: -- Parameters :
12: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
13: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
14: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
15: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
16: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
17: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
18: -- p_project_id IN NUMBER Required

Line 17: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM

13: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
14: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
15: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
16: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
17: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
18: -- p_project_id IN NUMBER Required
19: -- p_date_type IN VARCHAR2 Required
20: -- p_start_date IN DATE Optional Default = FND_API.G_MISS_DATE
21: -- p_finish_date IN DATE Optional Default = FND_API.G_MISS_DATE

Line 20: -- p_start_date IN DATE Optional Default = FND_API.G_MISS_DATE

16: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
17: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
18: -- p_project_id IN NUMBER Required
19: -- p_date_type IN VARCHAR2 Required
20: -- p_start_date IN DATE Optional Default = FND_API.G_MISS_DATE
21: -- p_finish_date IN DATE Optional Default = FND_API.G_MISS_DATE
22: -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM
23: -- x_return_status OUT VARCHAR2 Required
24: -- x_msg_count OUT NUMBER Required

Line 21: -- p_finish_date IN DATE Optional Default = FND_API.G_MISS_DATE

17: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
18: -- p_project_id IN NUMBER Required
19: -- p_date_type IN VARCHAR2 Required
20: -- p_start_date IN DATE Optional Default = FND_API.G_MISS_DATE
21: -- p_finish_date IN DATE Optional Default = FND_API.G_MISS_DATE
22: -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM
23: -- x_return_status OUT VARCHAR2 Required
24: -- x_msg_count OUT NUMBER Required
25: -- x_msg_data OUT VARCHAR2 Optional

Line 22: -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM

18: -- p_project_id IN NUMBER Required
19: -- p_date_type IN VARCHAR2 Required
20: -- p_start_date IN DATE Optional Default = FND_API.G_MISS_DATE
21: -- p_finish_date IN DATE Optional Default = FND_API.G_MISS_DATE
22: -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM
23: -- x_return_status OUT VARCHAR2 Required
24: -- x_msg_count OUT NUMBER Required
25: -- x_msg_data OUT VARCHAR2 Optional
26:

Line 28: ( p_commit IN VARCHAR2 := FND_API.G_FALSE

24: -- x_msg_count OUT NUMBER Required
25: -- x_msg_data OUT VARCHAR2 Optional
26:
27: PROCEDURE UPDATE_PROJECT_DATES
28: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
29: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
30: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
31: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
32: ,p_debug_mode IN VARCHAR2 := 'N'

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

25: -- x_msg_data OUT VARCHAR2 Optional
26:
27: PROCEDURE UPDATE_PROJECT_DATES
28: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
29: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
30: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
31: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
32: ,p_debug_mode IN VARCHAR2 := 'N'
33: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

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

26:
27: PROCEDURE UPDATE_PROJECT_DATES
28: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
29: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
30: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
31: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
32: ,p_debug_mode IN VARCHAR2 := 'N'
33: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
34: ,p_project_id IN NUMBER

Line 33: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

29: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
30: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
31: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
32: ,p_debug_mode IN VARCHAR2 := 'N'
33: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
34: ,p_project_id IN NUMBER
35: ,p_date_type IN VARCHAR2
36: ,p_start_date IN DATE := FND_API.G_MISS_DATE
37: ,p_finish_date IN DATE := FND_API.G_MISS_DATE

Line 36: ,p_start_date IN DATE := FND_API.G_MISS_DATE

32: ,p_debug_mode IN VARCHAR2 := 'N'
33: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
34: ,p_project_id IN NUMBER
35: ,p_date_type IN VARCHAR2
36: ,p_start_date IN DATE := FND_API.G_MISS_DATE
37: ,p_finish_date IN DATE := FND_API.G_MISS_DATE
38: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
39: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
40: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 37: ,p_finish_date IN DATE := FND_API.G_MISS_DATE

33: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
34: ,p_project_id IN NUMBER
35: ,p_date_type IN VARCHAR2
36: ,p_start_date IN DATE := FND_API.G_MISS_DATE
37: ,p_finish_date IN DATE := FND_API.G_MISS_DATE
38: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
39: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
40: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
41: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 38: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM

34: ,p_project_id IN NUMBER
35: ,p_date_type IN VARCHAR2
36: ,p_start_date IN DATE := FND_API.G_MISS_DATE
37: ,p_finish_date IN DATE := FND_API.G_MISS_DATE
38: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
39: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
40: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
41: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
42: )

Line 76: if p_commit = FND_API.G_TRUE then

72: if (p_debug_mode = 'Y') then
73: pa_debug.debug('PA_PROJECT_DATES_PVT.Update_Project_Dates BEGIN');
74: end if;
75:
76: if p_commit = FND_API.G_TRUE then
77: savepoint update_project_dates_pvt;
78: end if;
79:
80: if p_validate_only <> FND_API.G_TRUE then

Line 80: if p_validate_only <> FND_API.G_TRUE then

76: if p_commit = FND_API.G_TRUE then
77: savepoint update_project_dates_pvt;
78: end if;
79:
80: if p_validate_only <> FND_API.G_TRUE then
81: BEGIN
82: SELECT 'x' INTO l_dummy
83: FROM pa_projects_all
84: WHERE project_id = p_project_id

Line 138: raise FND_API.G_EXC_ERROR;

134: x_msg_count := l_msg_count;
135: if x_msg_count = 1 then
136: x_msg_data := l_msg_data;
137: end if;
138: raise FND_API.G_EXC_ERROR;
139: end if;
140:
141: if p_start_date = FND_API.G_MISS_DATE then
142: l_start_date := NULL;

Line 141: if p_start_date = FND_API.G_MISS_DATE then

137: end if;
138: raise FND_API.G_EXC_ERROR;
139: end if;
140:
141: if p_start_date = FND_API.G_MISS_DATE then
142: l_start_date := NULL;
143: else
144: l_start_date := p_start_date;
145: end if;

Line 147: if p_finish_date = FND_API.G_MISS_DATE then

143: else
144: l_start_date := p_start_date;
145: end if;
146:
147: if p_finish_date = FND_API.G_MISS_DATE then
148: l_finish_date := NULL;
149: else
150: l_finish_date := p_finish_date;
151: end if;

Line 183: RAISE FND_API.G_EXC_ERROR;

179: x_msg_data := l_msg_data;
180: END IF;
181: END IF;
182:
183: RAISE FND_API.G_EXC_ERROR;
184: END IF;*/
185:
186: END IF;
187:

Line 188: if p_validate_only <> FND_API.G_TRUE then

184: END IF;*/
185:
186: END IF;
187:
188: if p_validate_only <> FND_API.G_TRUE then
189: if p_date_type = 'TRANSACTION' then
190:
191: /*Bug 6860603 Begin*/
192:

Line 240: Raise FND_API.G_EXC_ERROR;

236:
237: end if;
238:
239: IF(l_start_date_status='I' OR l_end_date_status='I') then
240: Raise FND_API.G_EXC_ERROR;
241: end if;
242:
243: End if; -- PA_VALIDATE_ASSIGN_DATES='Y' and version_enabled='Y'
244: /*Bug 6860603 End*/

Line 298: x_return_status := FND_API.G_RET_STS_SUCCESS;

294: WHERE project_id = p_project_id;
295: end if;
296: end if;
297:
298: x_return_status := FND_API.G_RET_STS_SUCCESS;
299:
300: if p_commit = FND_API.G_TRUE then
301: commit work;
302: end if;

Line 300: if p_commit = FND_API.G_TRUE then

296: end if;
297:
298: x_return_status := FND_API.G_RET_STS_SUCCESS;
299:
300: if p_commit = FND_API.G_TRUE then
301: commit work;
302: end if;
303:
304: if (p_debug_mode = 'Y') then

Line 309: when FND_API.G_EXC_ERROR then

305: pa_debug.debug('PA_PROJECT_DATES_PVT.Update_Project_Dates END');
306: end if;
307:
308: EXCEPTION
309: when FND_API.G_EXC_ERROR then
310: if p_commit = FND_API.G_TRUE then
311: rollback to update_project_dates_pvt;
312: end if;
313: x_return_status := FND_API.G_RET_STS_ERROR;

Line 310: if p_commit = FND_API.G_TRUE then

306: end if;
307:
308: EXCEPTION
309: when FND_API.G_EXC_ERROR then
310: if p_commit = FND_API.G_TRUE then
311: rollback to update_project_dates_pvt;
312: end if;
313: x_return_status := FND_API.G_RET_STS_ERROR;
314: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 313: x_return_status := FND_API.G_RET_STS_ERROR;

309: when FND_API.G_EXC_ERROR then
310: if p_commit = FND_API.G_TRUE then
311: rollback to update_project_dates_pvt;
312: end if;
313: x_return_status := FND_API.G_RET_STS_ERROR;
314: when FND_API.G_EXC_UNEXPECTED_ERROR then
315: if p_commit = FND_API.G_TRUE then
316: rollback to update_project_dates_pvt;
317: end if;

Line 314: when FND_API.G_EXC_UNEXPECTED_ERROR then

310: if p_commit = FND_API.G_TRUE then
311: rollback to update_project_dates_pvt;
312: end if;
313: x_return_status := FND_API.G_RET_STS_ERROR;
314: when FND_API.G_EXC_UNEXPECTED_ERROR then
315: if p_commit = FND_API.G_TRUE then
316: rollback to update_project_dates_pvt;
317: end if;
318: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 315: if p_commit = FND_API.G_TRUE then

311: rollback to update_project_dates_pvt;
312: end if;
313: x_return_status := FND_API.G_RET_STS_ERROR;
314: when FND_API.G_EXC_UNEXPECTED_ERROR then
315: if p_commit = FND_API.G_TRUE then
316: rollback to update_project_dates_pvt;
317: end if;
318: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
319: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_DATES_PVT',

Line 318: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

314: when FND_API.G_EXC_UNEXPECTED_ERROR then
315: if p_commit = FND_API.G_TRUE then
316: rollback to update_project_dates_pvt;
317: end if;
318: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
319: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_DATES_PVT',
320: p_procedure_name => 'Update_Project_Dates',
321: p_error_text => SUBSTRB(SQLERRM,1,240));
322: when OTHERS then

Line 323: if p_commit = FND_API.G_TRUE then

319: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_DATES_PVT',
320: p_procedure_name => 'Update_Project_Dates',
321: p_error_text => SUBSTRB(SQLERRM,1,240));
322: when OTHERS then
323: if p_commit = FND_API.G_TRUE then
324: rollback to update_project_dates_pvt;
325: end if;
326: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
327: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_DATES_PVT',

Line 326: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

322: when OTHERS then
323: if p_commit = FND_API.G_TRUE then
324: rollback to update_project_dates_pvt;
325: end if;
326: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
327: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_DATES_PVT',
328: p_procedure_name => 'Update_Project_Dates',
329: p_error_text => SUBSTRB(SQLERRM,1,240));
330: raise;