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 464: l_unlock VARCHAR2(1) := FND_API.G_FALSE;

460: l_draft_status PO_DRAFTS.status%TYPE;
461: l_draft_owner_role PO_DRAFTS.owner_role%TYPE;
462:
463: l_changes_exist_tbl PO_TBL_VARCHAR1;
464: l_unlock VARCHAR2(1) := FND_API.G_FALSE;
465:
466: BEGIN
467: d_position := 0;
468:

Line 473: x_return_status := FND_API.G_RET_STS_SUCCESS;

469: IF (PO_LOG.d_proc) THEN
470: PO_LOG.proc_begin(d_module);
471: END IF;
472:
473: x_return_status := FND_API.G_RET_STS_SUCCESS;
474:
475: IF (NOT FND_API.compatible_api_call
476: ( p_current_version_number => l_api_version,
477: p_caller_version_number => p_api_version,

Line 475: IF (NOT FND_API.compatible_api_call

471: END IF;
472:
473: x_return_status := FND_API.G_RET_STS_SUCCESS;
474:
475: IF (NOT FND_API.compatible_api_call
476: ( p_current_version_number => l_api_version,
477: p_caller_version_number => p_api_version,
478: p_api_name => d_api_name,
479: p_pkg_name => d_pkg_name

Line 483: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

479: p_pkg_name => d_pkg_name
480: )
481: ) THEN
482:
483: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
484: END IF;
485:
486: -- Bug 12700941 starts
487: -- Getting the lock owner role as well

Line 519: IF (l_changes_exist_tbl(1) = FND_API.G_FALSE OR l_draft_owner_role =PO_GLOBAL.g_role_BUYER) THEN

515: -- In such case, the draft (po_drafts) status need to be set back to 'DRAFT'
516: -- for cat.admin/supplier
517: -- and draft record (po_drafts) should be deleted for role= Buyer as For Buyer the draft record is not retained
518:
519: IF (l_changes_exist_tbl(1) = FND_API.G_FALSE OR l_draft_owner_role =PO_GLOBAL.g_role_BUYER) THEN
520: d_position := 30;
521:
522: l_unlock := FND_API.G_TRUE;
523:

Line 522: l_unlock := FND_API.G_TRUE;

518:
519: IF (l_changes_exist_tbl(1) = FND_API.G_FALSE OR l_draft_owner_role =PO_GLOBAL.g_role_BUYER) THEN
520: d_position := 30;
521:
522: l_unlock := FND_API.G_TRUE;
523:
524: PO_DRAFTS_PVT.remove_draft_changes
525: ( p_draft_id => l_draft_id,
526: p_exclude_ctrl_tbl => FND_API.G_FALSE,

Line 526: p_exclude_ctrl_tbl => FND_API.G_FALSE,

522: l_unlock := FND_API.G_TRUE;
523:
524: PO_DRAFTS_PVT.remove_draft_changes
525: ( p_draft_id => l_draft_id,
526: p_exclude_ctrl_tbl => FND_API.G_FALSE,
527: x_return_status => l_return_status
528: );
529:
530: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

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

526: p_exclude_ctrl_tbl => FND_API.G_FALSE,
527: x_return_status => l_return_status
528: );
529:
530: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
532: END IF;
533:
534: ELSE

Line 531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

527: x_return_status => l_return_status
528: );
529:
530: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
532: END IF;
533:
534: ELSE
535:

Line 548: l_unlock := FND_API.G_TRUE;

544: IF (PO_LOG.d_proc) THEN
545: PO_LOG.stmt(d_module, d_position, 'draft changes do not exist. Simply unlock doc.');
546: END IF;
547:
548: l_unlock := FND_API.G_TRUE;
549: END IF;
550:
551: d_position := 50;
552:

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

549: END IF;
550:
551: d_position := 50;
552:
553: IF ( l_unlock = FND_API.G_TRUE ) THEN
554: PO_DRAFTS_PVT.unlock_document
555: ( p_po_header_id => p_po_header_id
556: );
557: END IF;

Line 565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

561: END IF;
562:
563: EXCEPTION
564: WHEN OTHERS THEN
565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
566: PO_MESSAGE_S.add_exc_msg
567: ( p_pkg_name => d_pkg_name,
568: p_procedure_name => d_api_name || '.' || d_position
569: );

Line 626: x_return_status := FND_API.G_RET_STS_SUCCESS;

622: IF (PO_LOG.d_proc) THEN
623: PO_LOG.proc_begin(d_module);
624: END IF;
625:
626: x_return_status := FND_API.G_RET_STS_SUCCESS;
627:
628: IF (NOT FND_API.compatible_api_call
629: ( p_current_version_number => l_api_version,
630: p_caller_version_number => p_api_version,

Line 628: IF (NOT FND_API.compatible_api_call

624: END IF;
625:
626: x_return_status := FND_API.G_RET_STS_SUCCESS;
627:
628: IF (NOT FND_API.compatible_api_call
629: ( p_current_version_number => l_api_version,
630: p_caller_version_number => p_api_version,
631: p_api_name => d_api_name,
632: p_pkg_name => d_pkg_name

Line 636: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

632: p_pkg_name => d_pkg_name
633: )
634: ) THEN
635:
636: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
637: END IF;
638:
639: d_position := 10;
640:

Line 657: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

653: END IF;
654:
655: EXCEPTION
656: WHEN OTHERS THEN
657: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
658: PO_MESSAGE_S.add_exc_msg
659: ( p_pkg_name => d_pkg_name,
660: p_procedure_name => d_api_name || '.' || d_position
661: );