DBA Data[Home] [Help]

APPS.PO_PROJECT_DETAILS_SV dependencies on FND_API

Line 30: -- FND_API.g_ret_sts_success - if the procedure completed successfully

26: --p_project_id
27: --p_task_id
28: --OUT:
29: --x_return_status
30: -- FND_API.g_ret_sts_success - if the procedure completed successfully
31: -- FND_API.g_ret_sts_unexp_error - unexpected error occurred
32: --x_project_num
33: -- The project number. If not found, this will be NULL.
34: --x_task_num

Line 31: -- FND_API.g_ret_sts_unexp_error - unexpected error occurred

27: --p_task_id
28: --OUT:
29: --x_return_status
30: -- FND_API.g_ret_sts_success - if the procedure completed successfully
31: -- FND_API.g_ret_sts_unexp_error - unexpected error occurred
32: --x_project_num
33: -- The project number. If not found, this will be NULL.
34: --x_task_num
35: -- The task number. If not found, this will be NULL.

Line 59: IF (l_return_status <> FND_API.g_ret_sts_success) THEN

55: all_proj_idtonum_wpr(x_return_status => l_return_status,
56: p_project_id => p_project_id,
57: x_project_number => x_project_num);
58:
59: IF (l_return_status <> FND_API.g_ret_sts_success) THEN
60: RAISE FND_API.g_exc_unexpected_error;
61: END IF;
62:
63: IF (p_task_id IS NOT NULL) THEN

Line 60: RAISE FND_API.g_exc_unexpected_error;

56: p_project_id => p_project_id,
57: x_project_number => x_project_num);
58:
59: IF (l_return_status <> FND_API.g_ret_sts_success) THEN
60: RAISE FND_API.g_exc_unexpected_error;
61: END IF;
62:
63: IF (p_task_id IS NOT NULL) THEN
64: l_progress := '020';

Line 80: WHEN FND_API.g_exc_unexpected_error THEN

76:
77: END IF; --< if project id not null >
78:
79: EXCEPTION
80: WHEN FND_API.g_exc_unexpected_error THEN
81: x_return_status := FND_API.g_ret_sts_unexp_error;
82: IF g_debug_unexp THEN
83: PO_DEBUG.debug_exc
84: (p_log_head => g_module_prefix||'get_project_task_num',

Line 81: x_return_status := FND_API.g_ret_sts_unexp_error;

77: END IF; --< if project id not null >
78:
79: EXCEPTION
80: WHEN FND_API.g_exc_unexpected_error THEN
81: x_return_status := FND_API.g_ret_sts_unexp_error;
82: IF g_debug_unexp THEN
83: PO_DEBUG.debug_exc
84: (p_log_head => g_module_prefix||'get_project_task_num',
85: p_progress => l_progress);

Line 88: x_return_status := FND_API.g_ret_sts_unexp_error;

84: (p_log_head => g_module_prefix||'get_project_task_num',
85: p_progress => l_progress);
86: END IF;
87: WHEN OTHERS THEN
88: x_return_status := FND_API.g_ret_sts_unexp_error;
89: FND_MSG_PUB.add_exc_msg(p_pkg_name => g_pkg_name,
90: p_procedure_name => 'get_project_task_num',
91: p_error_text => 'Progress: '||l_progress||
92: ' Error: '||SUBSTRB(SQLERRM,1,215));

Line 174: IF (l_return_status <> FND_API.g_ret_sts_success) THEN

170: p_task_id => p_task_id,
171: x_project_num => p_project_num,
172: x_task_num => p_task_num);
173:
174: IF (l_return_status <> FND_API.g_ret_sts_success) THEN
175: RAISE APP_EXCEPTION.application_exception;
176: END IF;
177: --< Bug 3265539 End >
178:

Line 208: -- FND_API.g_ret_sts_success - if the procedure completed successfully

204: --IN:
205: --p_project_id
206: --OUT:
207: --x_return_status
208: -- FND_API.g_ret_sts_success - if the procedure completed successfully
209: -- FND_API.g_ret_sts_unexp_error - unexpected error occurred
210: --x_project_number
211: -- The project number. If not found, this will be NULL.
212: --End of Comments

Line 209: -- FND_API.g_ret_sts_unexp_error - unexpected error occurred

205: --p_project_id
206: --OUT:
207: --x_return_status
208: -- FND_API.g_ret_sts_success - if the procedure completed successfully
209: -- FND_API.g_ret_sts_unexp_error - unexpected error occurred
210: --x_project_number
211: -- The project number. If not found, this will be NULL.
212: --End of Comments
213: --------------------------------------------------------------------------------

Line 222: x_return_status := FND_API.g_ret_sts_success;

218: x_project_number OUT NOCOPY VARCHAR2
219: )
220: IS
221: BEGIN
222: x_return_status := FND_API.g_ret_sts_success;
223:
224: x_project_number := PJM_PROJECT.all_proj_idtonum
225: (x_project_id => p_project_id);
226:

Line 231: x_return_status := FND_API.g_ret_sts_unexp_error;

227: EXCEPTION
228: WHEN NO_DATA_FOUND THEN
229: x_project_number := NULL;
230: WHEN OTHERS THEN
231: x_return_status := FND_API.g_ret_sts_unexp_error;
232: FND_MSG_PUB.add_exc_msg(p_pkg_name => g_pkg_name,
233: p_procedure_name => 'all_proj_idtonum_wpr');
234: IF g_debug_unexp THEN
235: PO_DEBUG.debug_exc

Line 328: IF (l_return_status <> FND_API.g_ret_sts_success) THEN

324: PO_CORE_S.get_inv_org_ou_id(x_return_status => l_return_status,
325: p_inv_org_id => p_inventory_org_id,
326: x_ou_id => l_pjm_org_id);
327:
328: IF (l_return_status <> FND_API.g_ret_sts_success) THEN
329: RAISE FND_API.g_exc_unexpected_error;
330: END IF;
331: ELSE
332: l_pjm_org_id := p_operating_unit;

Line 329: RAISE FND_API.g_exc_unexpected_error;

325: p_inv_org_id => p_inventory_org_id,
326: x_ou_id => l_pjm_org_id);
327:
328: IF (l_return_status <> FND_API.g_ret_sts_success) THEN
329: RAISE FND_API.g_exc_unexpected_error;
330: END IF;
331: ELSE
332: l_pjm_org_id := p_operating_unit;
333: END IF;

Line 359: WHEN FND_API.g_exc_unexpected_error THEN

355: p_message => 'return code: '||x_return_code||' error code: '||
356: x_error_code);
357: END IF;
358: EXCEPTION
359: WHEN FND_API.g_exc_unexpected_error THEN
360: x_return_code := pjm_validate_failure;
361: IF g_debug_unexp THEN
362: PO_DEBUG.debug_exc
363: (p_log_head => g_module_prefix||'validate_proj_references_wpr',