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

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

9: --
10: procedure CHECK_LOOPED_PROJECT
11: (
12: p_api_version IN NUMBER := 1.0,
13: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
14: p_commit IN VARCHAR2 := FND_API.G_FALSE,
15: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
16: p_debug_mode IN VARCHAR2 := 'N',
17: p_task_id IN NUMBER,

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

10: procedure CHECK_LOOPED_PROJECT
11: (
12: p_api_version IN NUMBER := 1.0,
13: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
14: p_commit IN VARCHAR2 := FND_API.G_FALSE,
15: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
16: p_debug_mode IN VARCHAR2 := 'N',
17: p_task_id IN NUMBER,
18: p_project_id IN NUMBER,

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

11: (
12: p_api_version IN NUMBER := 1.0,
13: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
14: p_commit IN VARCHAR2 := FND_API.G_FALSE,
15: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
16: p_debug_mode IN VARCHAR2 := 'N',
17: p_task_id IN NUMBER,
18: p_project_id IN NUMBER,
19: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 72: x_return_status := FND_API.G_RET_STS_ERROR;

68: END;
69: end if;
70:
71: IF (l_looped = 'Y') THEN --There is a loop
72: x_return_status := FND_API.G_RET_STS_ERROR;
73: elsif (l_looped = 'N') THEN
74: x_return_status := FND_API.G_RET_STS_SUCCESS;
75: else
76: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 74: x_return_status := FND_API.G_RET_STS_SUCCESS;

70:
71: IF (l_looped = 'Y') THEN --There is a loop
72: x_return_status := FND_API.G_RET_STS_ERROR;
73: elsif (l_looped = 'N') THEN
74: x_return_status := FND_API.G_RET_STS_SUCCESS;
75: else
76: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
77: end if;
78:

Line 76: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

72: x_return_status := FND_API.G_RET_STS_ERROR;
73: elsif (l_looped = 'N') THEN
74: x_return_status := FND_API.G_RET_STS_SUCCESS;
75: else
76: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
77: end if;
78:
79: x_msg_count := 0;
80: x_msg_data := null;

Line 85: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

81:
82: pa_debug.reset_err_stack;
83: EXCEPTION
84: When OTHERS Then
85: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
86: RAISE;
87: END CHECK_LOOPED_PROJECT;
88:
89:

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

90:
91: procedure CHECK_MERGED_PROJECT
92: (
93: p_api_version IN NUMBER := 1.0,
94: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
95: p_commit IN VARCHAR2 := FND_API.G_FALSE,
96: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
97: p_debug_mode IN VARCHAR2 := 'N',
98: p_task_id IN NUMBER,

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

91: procedure CHECK_MERGED_PROJECT
92: (
93: p_api_version IN NUMBER := 1.0,
94: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
95: p_commit IN VARCHAR2 := FND_API.G_FALSE,
96: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
97: p_debug_mode IN VARCHAR2 := 'N',
98: p_task_id IN NUMBER,
99: p_project_id IN NUMBER,

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

92: (
93: p_api_version IN NUMBER := 1.0,
94: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
95: p_commit IN VARCHAR2 := FND_API.G_FALSE,
96: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
97: p_debug_mode IN VARCHAR2 := 'N',
98: p_task_id IN NUMBER,
99: p_project_id IN NUMBER,
100: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 196: x_return_status := FND_API.G_RET_STS_SUCCESS;

192: END LOOP;
193: CLOSE get_merged_projects;
194:
195: IF(l_linked_id IS NULL) THEN
196: x_return_status := FND_API.G_RET_STS_SUCCESS;
197: ELSE
198: x_return_status := FND_API.G_RET_STS_ERROR;
199: END IF;
200:

Line 198: x_return_status := FND_API.G_RET_STS_ERROR;

194:
195: IF(l_linked_id IS NULL) THEN
196: x_return_status := FND_API.G_RET_STS_SUCCESS;
197: ELSE
198: x_return_status := FND_API.G_RET_STS_ERROR;
199: END IF;
200:
201: EXCEPTION
202: When NO_DATA_FOUND Then

Line 206: x_return_status := FND_API.G_RET_STS_ERROR;

202: When NO_DATA_FOUND Then
203: l_linked := 'N';
204: End;
205: ELSE
206: x_return_status := FND_API.G_RET_STS_ERROR;
207: END IF;
208: END;
209:
210: x_msg_count := 0;

Line 215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

211: x_msg_data := null;
212: pa_debug.reset_err_stack;
213: EXCEPTION
214: When OTHERS Then
215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
216: RAISE;
217: END CHECK_MERGED_PROJECT;
218:
219:

Line 233: retval := FND_API.G_RET_STS_SUCCESS;

229: msg_data VARCHAR2(2000);
230: ret_status VARCHAR2(10);
231: BEGIN
232: pa_debug.set_err_stack('CHECK_PROJECT_CONTRACT_EXISTS');
233: retval := FND_API.G_RET_STS_SUCCESS;
234:
235: /*
236: -- Old code
237: output := OKE_UTILS.Project_Used(p_project_id);

Line 241: p_commit => FND_API.G_TRUE,

237: output := OKE_UTILS.Project_Used(p_project_id);
238: */
239:
240: /* OKE_PA_CHECKS_PUB.Project_Used(p_api_version => 1.0,
241: p_commit => FND_API.G_TRUE,
242: p_init_msg_list => FND_API.G_FALSE,
243: x_msg_count => msg_count,
244: x_msg_data => msg_data,
245: x_return_status => ret_status,

Line 242: p_init_msg_list => FND_API.G_FALSE,

238: */
239:
240: /* OKE_PA_CHECKS_PUB.Project_Used(p_api_version => 1.0,
241: p_commit => FND_API.G_TRUE,
242: p_init_msg_list => FND_API.G_FALSE,
243: x_msg_count => msg_count,
244: x_msg_data => msg_data,
245: x_return_status => ret_status,
246: Project_ID => p_project_id,

Line 251: retval := FND_API.G_RET_STS_ERROR;

247: X_Result => output
248: ); */ --Commented the call to OKE_PA_CHECKS_PUB.Project_Used
249: IF (output = 'Y') THEN
250: -- project is used, association exists, return error
251: retval := FND_API.G_RET_STS_ERROR;
252: ELSE
253: -- no association exists, return success
254: retval := FND_API.G_RET_STS_SUCCESS;
255: END IF;

Line 254: retval := FND_API.G_RET_STS_SUCCESS;

250: -- project is used, association exists, return error
251: retval := FND_API.G_RET_STS_ERROR;
252: ELSE
253: -- no association exists, return success
254: retval := FND_API.G_RET_STS_SUCCESS;
255: END IF;
256:
257:
258: pa_debug.reset_err_stack;

Line 262: return FND_API.G_RET_STS_UNEXP_ERROR;

258: pa_debug.reset_err_stack;
259: return retval;
260: EXCEPTION
261: When OTHERS Then
262: return FND_API.G_RET_STS_UNEXP_ERROR;
263: END CHECK_PROJECT_CONTRACT_EXISTS;
264:
265:
266: function CHECK_TASK_CONTRACT_EXISTS

Line 279: retval := FND_API.G_RET_STS_SUCCESS;

275: msg_data VARCHAR2(2000);
276: ret_status VARCHAR2(10);
277: BEGIN
278: pa_debug.set_err_stack('CHECK_TASK_CONTRACT_EXISTS');
279: retval := FND_API.G_RET_STS_SUCCESS;
280:
281: /*
282: -- Old code
283: output := OKE_UTILS.Task_Used(p_task_id);

Line 286: p_commit => FND_API.G_TRUE,

282: -- Old code
283: output := OKE_UTILS.Task_Used(p_task_id);
284: */
285: /* OKE_PA_CHECKS_PUB.Task_Used(p_api_version => 1.0,
286: p_commit => FND_API.G_TRUE,
287: p_init_msg_list => FND_API.G_FALSE,
288: x_msg_count => msg_count,
289: x_msg_data => msg_data,
290: x_return_status => ret_status,

Line 287: p_init_msg_list => FND_API.G_FALSE,

283: output := OKE_UTILS.Task_Used(p_task_id);
284: */
285: /* OKE_PA_CHECKS_PUB.Task_Used(p_api_version => 1.0,
286: p_commit => FND_API.G_TRUE,
287: p_init_msg_list => FND_API.G_FALSE,
288: x_msg_count => msg_count,
289: x_msg_data => msg_data,
290: x_return_status => ret_status,
291: Task_ID => p_task_id,

Line 296: retval := FND_API.G_RET_STS_ERROR;

292: x_Result => output
293: );*/ --Commented the call to OKE_PA_CHECKS_PUB.Project_Used
294: IF (output = 'Y') THEN
295: -- project is used, association exists, return error
296: retval := FND_API.G_RET_STS_ERROR;
297: ELSE
298: -- no association exists, return success
299: retval := FND_API.G_RET_STS_SUCCESS;
300: END IF;

Line 299: retval := FND_API.G_RET_STS_SUCCESS;

295: -- project is used, association exists, return error
296: retval := FND_API.G_RET_STS_ERROR;
297: ELSE
298: -- no association exists, return success
299: retval := FND_API.G_RET_STS_SUCCESS;
300: END IF;
301:
302: pa_debug.reset_err_stack;
303: return retval;

Line 306: return FND_API.G_RET_STS_UNEXP_ERROR;

302: pa_debug.reset_err_stack;
303: return retval;
304: EXCEPTION
305: When OTHERS Then
306: return FND_API.G_RET_STS_UNEXP_ERROR;
307: END CHECK_TASK_CONTRACT_EXISTS;
308: -- FP M: Project Execution Workflow Changes
309: FUNCTION IS_WF_ENABLED_FOR_STRUCTURE(
310: p_project_id IN NUMBER

Line 469: --Begin: 6046307: commented out the following IF condition that 'RAISE FND_API.G_EXC_ERROR' when 'p_project_id' or 'p_budget_version_id' are NULL

465: p_budget_version_id IN NUMBER) IS
466:
467: BEGIN
468:
469: --Begin: 6046307: commented out the following IF condition that 'RAISE FND_API.G_EXC_ERROR' when 'p_project_id' or 'p_budget_version_id' are NULL
470: /*
471: IF p_project_id IS NULL OR p_budget_version_id IS NULL THEN
472: RAISE FND_API.G_EXC_ERROR;
473: END IF;

Line 472: RAISE FND_API.G_EXC_ERROR;

468:
469: --Begin: 6046307: commented out the following IF condition that 'RAISE FND_API.G_EXC_ERROR' when 'p_project_id' or 'p_budget_version_id' are NULL
470: /*
471: IF p_project_id IS NULL OR p_budget_version_id IS NULL THEN
472: RAISE FND_API.G_EXC_ERROR;
473: END IF;
474: */
475: --End: 6046307
476: