DBA Data[Home] [Help]

APPS.PO_DRAFTS_GRP dependencies on FND_API

Line 57: x_return_status := FND_API.G_RET_STS_SUCCESS;

53: IF (PO_LOG.d_proc) THEN
54: PO_LOG.proc_begin(d_module);
55: END IF;
56:
57: x_return_status := FND_API.G_RET_STS_SUCCESS;
58:
59: IF (NOT FND_API.compatible_api_call
60: ( p_current_version_number => l_api_version,
61: p_caller_version_number => p_api_version,

Line 59: IF (NOT FND_API.compatible_api_call

55: END IF;
56:
57: x_return_status := FND_API.G_RET_STS_SUCCESS;
58:
59: IF (NOT FND_API.compatible_api_call
60: ( p_current_version_number => l_api_version,
61: p_caller_version_number => p_api_version,
62: p_api_name => d_api_name,
63: p_pkg_name => d_pkg_name

Line 67: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

63: p_pkg_name => d_pkg_name
64: )
65: ) THEN
66:
67: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
68: END IF;
69:
70: x_online_auth_status_code := g_NO_DRAFT;
71:

Line 116: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

112: END IF;
113:
114: EXCEPTION
115: WHEN OTHERS THEN
116: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
117: PO_MESSAGE_S.add_exc_msg
118: ( p_pkg_name => d_pkg_name,
119: p_procedure_name => d_api_name || '.' || d_position
120: );

Line 145: -- FND_API.G_TRUE if authoring is allowed

141: --x_return_status
142: -- Return Status
143: --x_authoring_allowed
144: -- returns whether supplier authoring is allowed
145: -- FND_API.G_TRUE if authoring is allowed
146: -- FND_API.G_FALSE if authoring is not allowed
147: --x_message
148: -- reason for the failure, if authoring is not allowed
149: --End of Comments

Line 146: -- FND_API.G_FALSE if authoring is not allowed

142: -- Return Status
143: --x_authoring_allowed
144: -- returns whether supplier authoring is allowed
145: -- FND_API.G_TRUE if authoring is allowed
146: -- FND_API.G_FALSE if authoring is not allowed
147: --x_message
148: -- reason for the failure, if authoring is not allowed
149: --End of Comments
150: ------------------------------------------------------------------------

Line 177: x_return_status := FND_API.G_RET_STS_SUCCESS;

173: IF (PO_LOG.d_proc) THEN
174: PO_LOG.proc_begin(d_module);
175: END IF;
176:
177: x_return_status := FND_API.G_RET_STS_SUCCESS;
178:
179: IF (NOT FND_API.compatible_api_call
180: ( p_current_version_number => l_api_version,
181: p_caller_version_number => p_api_version,

Line 179: IF (NOT FND_API.compatible_api_call

175: END IF;
176:
177: x_return_status := FND_API.G_RET_STS_SUCCESS;
178:
179: IF (NOT FND_API.compatible_api_call
180: ( p_current_version_number => l_api_version,
181: p_caller_version_number => p_api_version,
182: p_api_name => d_api_name,
183: p_pkg_name => d_pkg_name

Line 187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

183: p_pkg_name => d_pkg_name
184: )
185: ) THEN
186:
187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
188: END IF;
189:
190: x_authoring_allowed := FND_API.G_TRUE;
191: x_message := NULL;

Line 190: x_authoring_allowed := FND_API.G_TRUE;

186:
187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
188: END IF;
189:
190: x_authoring_allowed := FND_API.G_TRUE;
191: x_message := NULL;
192:
193: d_position := 10;
194:

Line 196: x_authoring_allowed := FND_API.G_FALSE;

192:
193: d_position := 10;
194:
195: IF (NOT PO_GA_PVT.is_global_agreement(p_po_header_id => p_po_header_id)) THEN
196: x_authoring_allowed := FND_API.G_FALSE;
197: x_message := 'PO_ONLINE_AUTH_NA';
198: RETURN;
199: END IF;
200:

Line 214: IF (x_authoring_allowed = FND_API.G_FALSE) THEN

210: x_unlock_required => l_unlock_required,
211: x_message => x_message
212: );
213:
214: IF (x_authoring_allowed = FND_API.G_FALSE) THEN
215: IF (PO_LOG.d_stmt) THEN
216: PO_LOG.stmt(d_module, d_position, 'update permission check failed');
217: END IF;
218: END IF;

Line 233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

229: END IF;
230:
231: EXCEPTION
232: WHEN OTHERS THEN
233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
234: PO_MESSAGE_S.add_exc_msg
235: ( p_pkg_name => d_pkg_name,
236: p_procedure_name => d_api_name || '.' || d_position
237: );

Line 290: x_return_status := FND_API.G_RET_STS_SUCCESS;

286: IF (PO_LOG.d_proc) THEN
287: PO_LOG.proc_begin(d_module);
288: END IF;
289:
290: x_return_status := FND_API.G_RET_STS_SUCCESS;
291:
292: IF (NOT FND_API.compatible_api_call
293: ( p_current_version_number => l_api_version,
294: p_caller_version_number => p_api_version,

Line 292: IF (NOT FND_API.compatible_api_call

288: END IF;
289:
290: x_return_status := FND_API.G_RET_STS_SUCCESS;
291:
292: IF (NOT FND_API.compatible_api_call
293: ( p_current_version_number => l_api_version,
294: p_caller_version_number => p_api_version,
295: p_api_name => d_api_name,
296: p_pkg_name => d_pkg_name

Line 300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

296: p_pkg_name => d_pkg_name
297: )
298: ) THEN
299:
300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
301: END IF;
302:
303: d_position := 10;
304:

Line 322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

318: END IF;
319:
320: EXCEPTION
321: WHEN OTHERS THEN
322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
323: PO_MESSAGE_S.add_exc_msg
324: ( p_pkg_name => d_pkg_name,
325: p_procedure_name => d_api_name || '.' || d_position
326: );

Line 343: -- upload_in_progress: FND_API.G_TRUE if there's one upload that's not yet

339: --p_role
340: -- role of the user
341: --IN OUT:
342: --OUT:
343: -- upload_in_progress: FND_API.G_TRUE if there's one upload that's not yet
344: -- complete
345: -- upload_status_code
346: -- upload_requestor_role
347: -- upload_requestor_role_id id of the role

Line 380: x_return_status := FND_API.G_RET_STS_SUCCESS;

376: IF (PO_LOG.d_proc) THEN
377: PO_LOG.proc_begin(d_module);
378: END IF;
379:
380: x_return_status := FND_API.G_RET_STS_SUCCESS;
381:
382: IF (NOT FND_API.compatible_api_call
383: ( p_current_version_number => l_api_version,
384: p_caller_version_number => p_api_version,

Line 382: IF (NOT FND_API.compatible_api_call

378: END IF;
379:
380: x_return_status := FND_API.G_RET_STS_SUCCESS;
381:
382: IF (NOT FND_API.compatible_api_call
383: ( p_current_version_number => l_api_version,
384: p_caller_version_number => p_api_version,
385: p_api_name => d_api_name,
386: p_pkg_name => d_pkg_name

Line 390: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

386: p_pkg_name => d_pkg_name
387: )
388: ) THEN
389:
390: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
391: END IF;
392:
393: d_position := 10;
394:

Line 412: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

408: END IF;
409:
410: EXCEPTION
411: WHEN OTHERS THEN
412: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
413: PO_MESSAGE_S.add_exc_msg
414: ( p_pkg_name => d_pkg_name,
415: p_procedure_name => d_api_name || '.' || d_position
416: );

Line 460: l_unlock VARCHAR2(1) := FND_API.G_FALSE;

456: l_return_status VARCHAR2(1);
457:
458: l_draft_id NUMBER;
459: l_changes_exist_tbl PO_TBL_VARCHAR1;
460: l_unlock VARCHAR2(1) := FND_API.G_FALSE;
461:
462: BEGIN
463: d_position := 0;
464:

Line 469: x_return_status := FND_API.G_RET_STS_SUCCESS;

465: IF (PO_LOG.d_proc) THEN
466: PO_LOG.proc_begin(d_module);
467: END IF;
468:
469: x_return_status := FND_API.G_RET_STS_SUCCESS;
470:
471: IF (NOT FND_API.compatible_api_call
472: ( p_current_version_number => l_api_version,
473: p_caller_version_number => p_api_version,

Line 471: IF (NOT FND_API.compatible_api_call

467: END IF;
468:
469: x_return_status := FND_API.G_RET_STS_SUCCESS;
470:
471: IF (NOT FND_API.compatible_api_call
472: ( p_current_version_number => l_api_version,
473: p_caller_version_number => p_api_version,
474: p_api_name => d_api_name,
475: p_pkg_name => d_pkg_name

Line 479: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

475: p_pkg_name => d_pkg_name
476: )
477: ) THEN
478:
479: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
480: END IF;
481:
482: PO_DRAFTS_PVT.find_draft
483: ( p_po_header_id => p_po_header_id,

Line 504: IF (l_changes_exist_tbl(1) = FND_API.G_FALSE) THEN

500: PO_DRAFTS_PVT.changes_exist_for_draft
501: ( p_draft_id_tbl => PO_TBL_NUMBER(l_draft_id)
502: );
503:
504: IF (l_changes_exist_tbl(1) = FND_API.G_FALSE) THEN
505: d_position := 30;
506:
507: l_unlock := FND_API.G_TRUE;
508:

Line 507: l_unlock := FND_API.G_TRUE;

503:
504: IF (l_changes_exist_tbl(1) = FND_API.G_FALSE) THEN
505: d_position := 30;
506:
507: l_unlock := FND_API.G_TRUE;
508:
509: PO_DRAFTS_PVT.remove_draft_changes
510: ( p_draft_id => l_draft_id,
511: p_exclude_ctrl_tbl => FND_API.G_FALSE,

Line 511: p_exclude_ctrl_tbl => FND_API.G_FALSE,

507: l_unlock := FND_API.G_TRUE;
508:
509: PO_DRAFTS_PVT.remove_draft_changes
510: ( p_draft_id => l_draft_id,
511: p_exclude_ctrl_tbl => FND_API.G_FALSE,
512: x_return_status => l_return_status
513: );
514:
515: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 515: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

511: p_exclude_ctrl_tbl => FND_API.G_FALSE,
512: x_return_status => l_return_status
513: );
514:
515: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
516: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
517: END IF;
518:
519: END IF;

Line 516: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

512: x_return_status => l_return_status
513: );
514:
515: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
516: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
517: END IF;
518:
519: END IF;
520: ELSE

Line 527: l_unlock := FND_API.G_TRUE;

523: IF (PO_LOG.d_proc) THEN
524: PO_LOG.stmt(d_module, d_position, 'draft changes do not exist. Simply unlock doc.');
525: END IF;
526:
527: l_unlock := FND_API.G_TRUE;
528: END IF;
529:
530: d_position := 50;
531:

Line 532: IF ( l_unlock = FND_API.G_TRUE ) THEN

528: END IF;
529:
530: d_position := 50;
531:
532: IF ( l_unlock = FND_API.G_TRUE ) THEN
533: PO_DRAFTS_PVT.unlock_document
534: ( p_po_header_id => p_po_header_id
535: );
536: END IF;

Line 544: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

540: END IF;
541:
542: EXCEPTION
543: WHEN OTHERS THEN
544: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
545: PO_MESSAGE_S.add_exc_msg
546: ( p_pkg_name => d_pkg_name,
547: p_procedure_name => d_api_name || '.' || d_position
548: );

Line 605: x_return_status := FND_API.G_RET_STS_SUCCESS;

601: IF (PO_LOG.d_proc) THEN
602: PO_LOG.proc_begin(d_module);
603: END IF;
604:
605: x_return_status := FND_API.G_RET_STS_SUCCESS;
606:
607: IF (NOT FND_API.compatible_api_call
608: ( p_current_version_number => l_api_version,
609: p_caller_version_number => p_api_version,

Line 607: IF (NOT FND_API.compatible_api_call

603: END IF;
604:
605: x_return_status := FND_API.G_RET_STS_SUCCESS;
606:
607: IF (NOT FND_API.compatible_api_call
608: ( p_current_version_number => l_api_version,
609: p_caller_version_number => p_api_version,
610: p_api_name => d_api_name,
611: p_pkg_name => d_pkg_name

Line 615: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

611: p_pkg_name => d_pkg_name
612: )
613: ) THEN
614:
615: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
616: END IF;
617:
618: d_position := 10;
619:

Line 636: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

632: END IF;
633:
634: EXCEPTION
635: WHEN OTHERS THEN
636: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
637: PO_MESSAGE_S.add_exc_msg
638: ( p_pkg_name => d_pkg_name,
639: p_procedure_name => d_api_name || '.' || d_position
640: );