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.PO_DOCUMENT_FUNDS_GRP dependencies on FND_API

Line 97: -- FND_API.G_RET_STS_SUCCESS if validation succeeds

93: -- Use g_parameter_YES/NO.
94: --OUT:
95: --x_return_status
96: -- VARCHAR2(1)
97: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
98: -- FND_API.G_RET_STS_ERROR if validation fails
99: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
100: --x_detailed_results
101: -- Object table that stores distribution specific

Line 98: -- FND_API.G_RET_STS_ERROR if validation fails

94: --OUT:
95: --x_return_status
96: -- VARCHAR2(1)
97: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
98: -- FND_API.G_RET_STS_ERROR if validation fails
99: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
100: --x_detailed_results
101: -- Object table that stores distribution specific
102: -- reporting information for the encumbrance transaction.

Line 99: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

95: --x_return_status
96: -- VARCHAR2(1)
97: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
98: -- FND_API.G_RET_STS_ERROR if validation fails
99: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
100: --x_detailed_results
101: -- Object table that stores distribution specific
102: -- reporting information for the encumbrance transaction.
103: --x_po_return_code

Line 119: default FND_API.G_FALSE

115: -------------------------------------------------------------------------------
116: PROCEDURE check_reserve(
117: p_api_version IN NUMBER
118: , p_commit IN VARCHAR2
119: default FND_API.G_FALSE
120: , p_init_msg_list IN VARCHAR2
121: default FND_API.G_FALSE
122: , p_validation_level IN NUMBER
123: default FND_API.G_VALID_LEVEL_FULL

Line 121: default FND_API.G_FALSE

117: p_api_version IN NUMBER
118: , p_commit IN VARCHAR2
119: default FND_API.G_FALSE
120: , p_init_msg_list IN VARCHAR2
121: default FND_API.G_FALSE
122: , p_validation_level IN NUMBER
123: default FND_API.G_VALID_LEVEL_FULL
124: , x_return_status OUT NOCOPY VARCHAR2
125: , p_doc_type IN VARCHAR2

Line 123: default FND_API.G_VALID_LEVEL_FULL

119: default FND_API.G_FALSE
120: , p_init_msg_list IN VARCHAR2
121: default FND_API.G_FALSE
122: , p_validation_level IN NUMBER
123: default FND_API.G_VALID_LEVEL_FULL
124: , x_return_status OUT NOCOPY VARCHAR2
125: , p_doc_type IN VARCHAR2
126: , p_doc_subtype IN VARCHAR2
127: , p_doc_level IN VARCHAR2

Line 170: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

166: l_progress := '020';
167:
168: -- Standard call to check for call compatibility
169:
170: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
172: END IF;
173:
174: l_progress := '030';

Line 171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

167:
168: -- Standard call to check for call compatibility
169:
170: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
172: END IF;
173:
174: l_progress := '030';
175:

Line 178: IF FND_API.to_Boolean( p_init_msg_list ) THEN

174: l_progress := '030';
175:
176: -- Initialize message list if p_init_msg_list is set to TRUE.
177:
178: IF FND_API.to_Boolean( p_init_msg_list ) THEN
179: FND_MSG_PUB.initialize;
180: END IF;
181:
182: l_progress := '040';

Line 186: x_return_status := FND_API.G_RET_STS_SUCCESS;

182: l_progress := '040';
183:
184: -- Initialize API return status to success
185:
186: x_return_status := FND_API.G_RET_STS_SUCCESS;
187:
188: l_progress := '050';
189:
190: IF g_debug_stmt THEN

Line 210: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

206: );
207:
208: l_progress := '100';
209:
210: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
211: OR x_return_status IS NULL
212: ) THEN
213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
214: END IF;

Line 213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

209:
210: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
211: OR x_return_status IS NULL
212: ) THEN
213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
214: END IF;
215:
216: l_progress := '110';
217:

Line 234: IF ( l_report_return_status = FND_API.G_RET_STS_UNEXP_ERROR

230: );
231:
232: l_progress := '200';
233:
234: IF ( l_report_return_status = FND_API.G_RET_STS_UNEXP_ERROR
235: OR l_report_return_status IS NULL
236: ) THEN
237: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
238: END IF;

Line 237: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

233:
234: IF ( l_report_return_status = FND_API.G_RET_STS_UNEXP_ERROR
235: OR l_report_return_status IS NULL
236: ) THEN
237: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
238: END IF;
239:
240: l_progress := '300';
241:

Line 243: IF FND_API.To_Boolean(p_commit) THEN

239:
240: l_progress := '300';
241:
242: -- Standard check of p_commit.
243: IF FND_API.To_Boolean(p_commit) THEN
244: COMMIT WORK;
245: END IF;
246:
247: l_progress := '900';

Line 261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

257: EXCEPTION
258: WHEN OTHERS THEN
259: BEGIN
260: PO_DEBUG.debug_unexp(l_log_head,l_progress,'OTHERS Start');
261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
262: IF g_debug_stmt THEN
263: PO_DEBUG.debug_var(l_log_head,l_progress,'l_report_return_status',l_report_return_status);
264: PO_DEBUG.debug_var(l_log_head,l_progress,'l_online_report_id',l_online_report_id);
265: PO_DEBUG.debug_var(l_log_head,l_progress,'x_return_status',x_return_status);

Line 350: -- FND_API.G_RET_STS_SUCCESS if validation succeeds

346: -- Use g_parameter_YES/NO.
347: --OUT:
348: --x_return_status
349: -- VARCHAR2(1)
350: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
351: -- FND_API.G_RET_STS_ERROR if validation fails
352: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
353: --x_po_return_code
354: -- VARCHAR2(10)

Line 351: -- FND_API.G_RET_STS_ERROR if validation fails

347: --OUT:
348: --x_return_status
349: -- VARCHAR2(1)
350: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
351: -- FND_API.G_RET_STS_ERROR if validation fails
352: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
353: --x_po_return_code
354: -- VARCHAR2(10)
355: -- Indicates the PO classification of the results of this transaction.

Line 352: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

348: --x_return_status
349: -- VARCHAR2(1)
350: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
351: -- FND_API.G_RET_STS_ERROR if validation fails
352: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
353: --x_po_return_code
354: -- VARCHAR2(10)
355: -- Indicates the PO classification of the results of this transaction.
356: -- g_return_<>

Line 370: , p_commit IN VARCHAR2 default FND_API.G_FALSE

366: --End of Comments
367: -------------------------------------------------------------------------------
368: PROCEDURE check_adjust(
369: p_api_version IN NUMBER
370: , p_commit IN VARCHAR2 default FND_API.G_FALSE
371: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
372: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
373: , x_return_status OUT NOCOPY VARCHAR2
374: , p_doc_type IN VARCHAR2

Line 371: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE

367: -------------------------------------------------------------------------------
368: PROCEDURE check_adjust(
369: p_api_version IN NUMBER
370: , p_commit IN VARCHAR2 default FND_API.G_FALSE
371: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
372: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
373: , x_return_status OUT NOCOPY VARCHAR2
374: , p_doc_type IN VARCHAR2
375: , p_doc_subtype IN VARCHAR2

Line 372: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL

368: PROCEDURE check_adjust(
369: p_api_version IN NUMBER
370: , p_commit IN VARCHAR2 default FND_API.G_FALSE
371: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
372: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
373: , x_return_status OUT NOCOPY VARCHAR2
374: , p_doc_type IN VARCHAR2
375: , p_doc_subtype IN VARCHAR2
376: , p_override_funds IN VARCHAR2

Line 418: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

414: l_progress := '020';
415:
416: -- Standard call to check for call compatibility
417:
418: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
419: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
420: END IF;
421:
422: l_progress := '030';

Line 419: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

415:
416: -- Standard call to check for call compatibility
417:
418: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
419: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
420: END IF;
421:
422: l_progress := '030';
423:

Line 426: IF FND_API.to_Boolean( p_init_msg_list ) THEN

422: l_progress := '030';
423:
424: -- Initialize message list if p_init_msg_list is set to TRUE.
425:
426: IF FND_API.to_Boolean( p_init_msg_list ) THEN
427: FND_MSG_PUB.initialize;
428: END IF;
429:
430: l_progress := '040';

Line 434: x_return_status := FND_API.G_RET_STS_SUCCESS;

430: l_progress := '040';
431:
432: -- Initialize API return status to success
433:
434: x_return_status := FND_API.G_RET_STS_SUCCESS;
435:
436: l_progress := '050';
437:
438: IF g_debug_stmt THEN

Line 457: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

453: );
454:
455: l_progress := '100';
456:
457: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
458: OR x_return_status IS NULL
459: ) THEN
460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
461: END IF;

Line 460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

456:
457: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
458: OR x_return_status IS NULL
459: ) THEN
460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
461: END IF;
462:
463: l_progress := '110';
464:

Line 481: IF ( l_report_return_status = FND_API.G_RET_STS_UNEXP_ERROR

477: );
478:
479: l_progress := '200';
480:
481: IF ( l_report_return_status = FND_API.G_RET_STS_UNEXP_ERROR
482: OR l_report_return_status IS NULL
483: ) THEN
484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
485: END IF;

Line 484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

480:
481: IF ( l_report_return_status = FND_API.G_RET_STS_UNEXP_ERROR
482: OR l_report_return_status IS NULL
483: ) THEN
484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
485: END IF;
486:
487: l_progress := '300';
488:

Line 490: IF FND_API.To_Boolean(p_commit) THEN

486:
487: l_progress := '300';
488:
489: -- Standard check of p_commit.
490: IF FND_API.To_Boolean(p_commit) THEN
491: COMMIT WORK;
492: END IF;
493:
494: l_progress := '900';

Line 508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

504: EXCEPTION
505: WHEN OTHERS THEN
506: BEGIN
507: PO_DEBUG.debug_unexp(l_log_head,l_progress,'OTHERS Start');
508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
509: IF g_debug_stmt THEN
510: PO_DEBUG.debug_var(l_log_head,l_progress,'l_report_return_status',l_report_return_status);
511: PO_DEBUG.debug_var(l_log_head,l_progress,'l_online_report_id',l_online_report_id);
512: PO_DEBUG.debug_var(l_log_head,l_progress,'x_return_status',x_return_status);

Line 613: -- FND_API.G_RET_STS_SUCCESS if validation succeeds

609: -- Use g_parameter_YES/NO.
610: --OUT:
611: --x_return_status
612: -- VARCHAR2(1)
613: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
614: -- FND_API.G_RET_STS_ERROR if validation fails
615: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
616: --x_po_return_code
617: -- VARCHAR2(10)

Line 614: -- FND_API.G_RET_STS_ERROR if validation fails

610: --OUT:
611: --x_return_status
612: -- VARCHAR2(1)
613: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
614: -- FND_API.G_RET_STS_ERROR if validation fails
615: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
616: --x_po_return_code
617: -- VARCHAR2(10)
618: -- Indicates the PO classification of the results of this transaction.

Line 615: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

611: --x_return_status
612: -- VARCHAR2(1)
613: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
614: -- FND_API.G_RET_STS_ERROR if validation fails
615: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
616: --x_po_return_code
617: -- VARCHAR2(10)
618: -- Indicates the PO classification of the results of this transaction.
619: -- g_return_<>

Line 635: default FND_API.G_FALSE

631: -------------------------------------------------------------------------------
632: PROCEDURE do_reserve(
633: p_api_version IN NUMBER
634: , p_commit IN VARCHAR2
635: default FND_API.G_FALSE
636: , p_init_msg_list IN VARCHAR2
637: default FND_API.G_FALSE
638: , p_validation_level IN NUMBER
639: default FND_API.G_VALID_LEVEL_FULL

Line 637: default FND_API.G_FALSE

633: p_api_version IN NUMBER
634: , p_commit IN VARCHAR2
635: default FND_API.G_FALSE
636: , p_init_msg_list IN VARCHAR2
637: default FND_API.G_FALSE
638: , p_validation_level IN NUMBER
639: default FND_API.G_VALID_LEVEL_FULL
640: , x_return_status OUT NOCOPY VARCHAR2
641: , p_doc_type IN VARCHAR2

Line 639: default FND_API.G_VALID_LEVEL_FULL

635: default FND_API.G_FALSE
636: , p_init_msg_list IN VARCHAR2
637: default FND_API.G_FALSE
638: , p_validation_level IN NUMBER
639: default FND_API.G_VALID_LEVEL_FULL
640: , x_return_status OUT NOCOPY VARCHAR2
641: , p_doc_type IN VARCHAR2
642: , p_doc_subtype IN VARCHAR2
643: , p_doc_level IN VARCHAR2

Line 692: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

688: l_progress := '020';
689:
690: -- Standard call to check for call compatibility
691:
692: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
693: l_progress := '025';
694: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
695: END IF;
696:

Line 694: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

690: -- Standard call to check for call compatibility
691:
692: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
693: l_progress := '025';
694: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
695: END IF;
696:
697: l_progress := '030';
698:

Line 701: IF FND_API.to_Boolean( p_init_msg_list ) THEN

697: l_progress := '030';
698:
699: -- Initialize message list if p_init_msg_list is set to TRUE.
700:
701: IF FND_API.to_Boolean( p_init_msg_list ) THEN
702: FND_MSG_PUB.initialize;
703: END IF;
704:
705: l_progress := '040';

Line 709: x_return_status := FND_API.G_RET_STS_SUCCESS;

705: l_progress := '040';
706:
707: -- Initialize API return status to success
708:
709: x_return_status := FND_API.G_RET_STS_SUCCESS;
710:
711: l_progress := '100';
712:
713: -- bug 3435714

Line 734: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS

730: );
731:
732: l_progress := '120';
733:
734: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS
735: OR x_return_status IS NULL
736: ) THEN
737: l_progress := '130';
738: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 738: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

734: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS
735: OR x_return_status IS NULL
736: ) THEN
737: l_progress := '130';
738: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
739: END IF;
740:
741: l_use_enc_gt_flag := g_parameter_YES;
742: l_doc_level_id := NULL;

Line 770: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

766:
767: l_progress := '300';
768:
769: -- let an expected error bubble up to the caller.
770: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
771: OR x_return_status IS NULL
772: ) THEN
773: l_progress := '310';
774: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 774: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

770: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
771: OR x_return_status IS NULL
772: ) THEN
773: l_progress := '310';
774: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
775: END IF;
776:
777: l_progress := '400';
778:

Line 788: IF ( l_report_return_status = FND_API.G_RET_STS_UNEXP_ERROR

784: );
785:
786: l_progress := '500';
787:
788: IF ( l_report_return_status = FND_API.G_RET_STS_UNEXP_ERROR
789: OR l_report_return_status IS NULL
790: ) THEN
791: l_progress := '510';
792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

788: IF ( l_report_return_status = FND_API.G_RET_STS_UNEXP_ERROR
789: OR l_report_return_status IS NULL
790: ) THEN
791: l_progress := '510';
792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
793: END IF;
794:
795: l_progress := '600';
796:

Line 798: IF FND_API.To_Boolean(p_commit) THEN

794:
795: l_progress := '600';
796:
797: -- Standard check of p_commit.
798: IF FND_API.To_Boolean(p_commit) THEN
799: COMMIT WORK;
800: END IF;
801:
802: l_progress := '900';

Line 816: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

812: EXCEPTION
813: WHEN OTHERS THEN
814: BEGIN
815: PO_DEBUG.debug_unexp(l_log_head,l_progress,'OTHERS Start');
816: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
817: IF g_debug_stmt THEN
818: PO_DEBUG.debug_var(l_log_head,l_progress,'l_report_return_status',l_report_return_status);
819: PO_DEBUG.debug_var(l_log_head,l_progress,'l_online_report_id',l_online_report_id);
820: PO_DEBUG.debug_var(l_log_head,l_progress,'x_return_status',x_return_status);

Line 925: -- FND_API.G_RET_STS_SUCCESS if validation succeeds

921: -- Use g_parameter_YES/NO.
922: --OUT:
923: --x_return_status
924: -- VARCHAR2(1)
925: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
926: -- FND_API.G_RET_STS_ERROR if validation fails
927: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
928: --x_po_return_code
929: -- VARCHAR2(10)

Line 926: -- FND_API.G_RET_STS_ERROR if validation fails

922: --OUT:
923: --x_return_status
924: -- VARCHAR2(1)
925: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
926: -- FND_API.G_RET_STS_ERROR if validation fails
927: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
928: --x_po_return_code
929: -- VARCHAR2(10)
930: -- Indicates the PO classification of the results of this transaction.

Line 927: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

923: --x_return_status
924: -- VARCHAR2(1)
925: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
926: -- FND_API.G_RET_STS_ERROR if validation fails
927: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
928: --x_po_return_code
929: -- VARCHAR2(10)
930: -- Indicates the PO classification of the results of this transaction.
931: -- g_return_<>

Line 946: default FND_API.G_FALSE

942: -------------------------------------------------------------------------------
943: PROCEDURE do_unreserve(
944: p_api_version IN NUMBER
945: , p_commit IN VARCHAR2
946: default FND_API.G_FALSE
947: , p_init_msg_list IN VARCHAR2
948: default FND_API.G_FALSE
949: , p_validation_level IN NUMBER
950: default FND_API.G_VALID_LEVEL_FULL

Line 948: default FND_API.G_FALSE

944: p_api_version IN NUMBER
945: , p_commit IN VARCHAR2
946: default FND_API.G_FALSE
947: , p_init_msg_list IN VARCHAR2
948: default FND_API.G_FALSE
949: , p_validation_level IN NUMBER
950: default FND_API.G_VALID_LEVEL_FULL
951: , x_return_status OUT NOCOPY VARCHAR2
952: , p_doc_type IN VARCHAR2

Line 950: default FND_API.G_VALID_LEVEL_FULL

946: default FND_API.G_FALSE
947: , p_init_msg_list IN VARCHAR2
948: default FND_API.G_FALSE
949: , p_validation_level IN NUMBER
950: default FND_API.G_VALID_LEVEL_FULL
951: , x_return_status OUT NOCOPY VARCHAR2
952: , p_doc_type IN VARCHAR2
953: , p_doc_subtype IN VARCHAR2
954: , p_doc_level IN VARCHAR2

Line 1005: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

1001: l_progress := '020';
1002:
1003: -- Standard call to check for call compatibility
1004:
1005: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1006: l_progress := '025';
1007: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1008: END IF;
1009:

Line 1007: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1003: -- Standard call to check for call compatibility
1004:
1005: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1006: l_progress := '025';
1007: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1008: END IF;
1009:
1010: l_progress := '030';
1011:

Line 1014: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1010: l_progress := '030';
1011:
1012: -- Initialize message list if p_init_msg_list is set to TRUE.
1013:
1014: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1015: FND_MSG_PUB.initialize;
1016: END IF;
1017:
1018: l_progress := '040';

Line 1022: x_return_status := FND_API.G_RET_STS_SUCCESS;

1018: l_progress := '040';
1019:
1020: -- Initialize API return status to success
1021:
1022: x_return_status := FND_API.G_RET_STS_SUCCESS;
1023:
1024: l_progress := '100';
1025:
1026: -- bug 3435714

Line 1047: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS

1043: );
1044:
1045: l_progress := '120';
1046:
1047: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS
1048: OR x_return_status IS NULL
1049: ) THEN
1050: l_progress := '130';
1051: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1051: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1047: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS
1048: OR x_return_status IS NULL
1049: ) THEN
1050: l_progress := '130';
1051: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1052: END IF;
1053:
1054: l_use_enc_gt_flag := g_parameter_YES;
1055: l_doc_level_id := NULL;

Line 1084: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

1080:
1081: l_progress := '300';
1082:
1083: -- let an expected error bubble up to the caller.
1084: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1085: OR x_return_status IS NULL
1086: ) THEN
1087: l_progress := '310';
1088: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1088: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1084: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1085: OR x_return_status IS NULL
1086: ) THEN
1087: l_progress := '310';
1088: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1089: END IF;
1090:
1091: l_progress := '400';
1092:

Line 1102: IF l_report_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1098: );
1099:
1100: l_progress := '500';
1101:
1102: IF l_report_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1103: l_progress := '510';
1104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1105: END IF;
1106:

Line 1104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1100: l_progress := '500';
1101:
1102: IF l_report_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1103: l_progress := '510';
1104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1105: END IF;
1106:
1107: l_progress := '600';
1108:

Line 1110: IF FND_API.To_Boolean(p_commit) THEN

1106:
1107: l_progress := '600';
1108:
1109: -- Standard check of p_commit.
1110: IF FND_API.To_Boolean(p_commit) THEN
1111: COMMIT WORK;
1112: END IF;
1113:
1114: l_progress := '900';

Line 1128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1124: EXCEPTION
1125: WHEN OTHERS THEN
1126: BEGIN
1127: PO_DEBUG.debug_unexp(l_log_head,l_progress,'OTHERS Start');
1128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1129: IF g_debug_stmt THEN
1130: PO_DEBUG.debug_var(l_log_head,l_progress,'l_report_return_status',l_report_return_status);
1131: PO_DEBUG.debug_var(l_log_head,l_progress,'l_online_report_id',l_online_report_id);
1132: PO_DEBUG.debug_var(l_log_head,l_progress,'x_return_status',x_return_status);

Line 1218: -- FND_API.G_RET_STS_SUCCESS if validation succeeds

1214: -- Use g_parameter_YES/NO.
1215: --OUT:
1216: --x_return_status
1217: -- VARCHAR2(1)
1218: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
1219: -- FND_API.G_RET_STS_ERROR if validation fails
1220: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
1221: --x_po_return_code
1222: -- VARCHAR2(10)

Line 1219: -- FND_API.G_RET_STS_ERROR if validation fails

1215: --OUT:
1216: --x_return_status
1217: -- VARCHAR2(1)
1218: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
1219: -- FND_API.G_RET_STS_ERROR if validation fails
1220: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
1221: --x_po_return_code
1222: -- VARCHAR2(10)
1223: -- Indicates the PO classification of the results of this transaction.

Line 1220: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

1216: --x_return_status
1217: -- VARCHAR2(1)
1218: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
1219: -- FND_API.G_RET_STS_ERROR if validation fails
1220: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
1221: --x_po_return_code
1222: -- VARCHAR2(10)
1223: -- Indicates the PO classification of the results of this transaction.
1224: -- g_return_<>

Line 1239: default FND_API.G_FALSE

1235: -------------------------------------------------------------------------------
1236: PROCEDURE do_liquidate(
1237: p_api_version IN NUMBER
1238: , p_commit IN VARCHAR2
1239: default FND_API.G_FALSE
1240: , p_init_msg_list IN VARCHAR2
1241: default FND_API.G_FALSE
1242: , p_validation_level IN NUMBER
1243: default FND_API.G_VALID_LEVEL_FULL

Line 1241: default FND_API.G_FALSE

1237: p_api_version IN NUMBER
1238: , p_commit IN VARCHAR2
1239: default FND_API.G_FALSE
1240: , p_init_msg_list IN VARCHAR2
1241: default FND_API.G_FALSE
1242: , p_validation_level IN NUMBER
1243: default FND_API.G_VALID_LEVEL_FULL
1244: , x_return_status OUT NOCOPY VARCHAR2
1245: , p_doc_level IN VARCHAR2

Line 1243: default FND_API.G_VALID_LEVEL_FULL

1239: default FND_API.G_FALSE
1240: , p_init_msg_list IN VARCHAR2
1241: default FND_API.G_FALSE
1242: , p_validation_level IN NUMBER
1243: default FND_API.G_VALID_LEVEL_FULL
1244: , x_return_status OUT NOCOPY VARCHAR2
1245: , p_doc_level IN VARCHAR2
1246: , p_doc_level_id_tbl IN po_tbl_number
1247: , p_employee_id IN NUMBER

Line 1327: x_return_status := FND_API.g_ret_sts_ERROR;

1323: END IF;
1324:
1325: IF l_amendment_inprogress = 'Y' THEN
1326: l_progress := '040';
1327: x_return_status := FND_API.g_ret_sts_ERROR;
1328: x_po_return_code := g_return_FAILURE;
1329: l_error_msg(i) := 'PO_ACTIVE_AMD_IN_PROGRESS';
1330:
1331: ELSIF l_award_mod_inprogress = 'Y' THEN

Line 1333: x_return_status := FND_API.g_ret_sts_ERROR;

1329: l_error_msg(i) := 'PO_ACTIVE_AMD_IN_PROGRESS';
1330:
1331: ELSIF l_award_mod_inprogress = 'Y' THEN
1332: l_progress := '050';
1333: x_return_status := FND_API.g_ret_sts_ERROR;
1334: x_po_return_code := g_return_FAILURE;
1335: l_error_msg(i) := 'PO_POR_MAPPED_DFT_AWARD_MOD';
1336:
1337: ELSE

Line 1360: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

1356: x_detailed_results => x_detailed_results);
1357:
1358: l_progress := '070';
1359: -- let an expected error bubble up to the caller.
1360: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1361: OR x_return_status IS NULL
1362: ) THEN
1363: l_progress := '080';
1364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1360: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1361: OR x_return_status IS NULL
1362: ) THEN
1363: l_progress := '080';
1364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1365: END IF;
1366: END IF;
1367: END LOOP;
1368:

Line 1381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1377: EXCEPTION
1378: WHEN OTHERS THEN
1379: BEGIN
1380: PO_DEBUG.debug_unexp(l_log_head,l_progress,'OTHERS Start');
1381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1382: IF g_debug_stmt THEN
1383: PO_DEBUG.debug_var(l_log_head,l_progress,'x_return_status',x_return_status);
1384: PO_DEBUG.debug_var(l_log_head,l_progress,'x_po_return_code',x_po_return_code);
1385: END IF;

Line 1448: -- FND_API.G_RET_STS_SUCCESS if validation succeeds

1444: -- distributions for which encumbrance actions were successful. Information for
1445: -- distributions with Warnings and Errors are always included.
1446: --OUT:
1447: --x_return_status
1448: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
1449: -- FND_API.G_RET_STS_ERROR if validation fails
1450: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
1451: --x_detailed_results
1452: -- Object table that stores distribution specific

Line 1449: -- FND_API.G_RET_STS_ERROR if validation fails

1445: -- distributions with Warnings and Errors are always included.
1446: --OUT:
1447: --x_return_status
1448: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
1449: -- FND_API.G_RET_STS_ERROR if validation fails
1450: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
1451: --x_detailed_results
1452: -- Object table that stores distribution specific
1453: -- reporting information for the encumbrance transaction

Line 1450: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

1446: --OUT:
1447: --x_return_status
1448: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
1449: -- FND_API.G_RET_STS_ERROR if validation fails
1450: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
1451: --x_detailed_results
1452: -- Object table that stores distribution specific
1453: -- reporting information for the encumbrance transaction
1454: --x_po_return_code

Line 1463: , p_commit IN VARCHAR2 default FND_API.G_FALSE

1459: --End of Comments
1460: -------------------------------------------------------------------------------
1461: PROCEDURE do_return(
1462: p_api_version IN NUMBER
1463: , p_commit IN VARCHAR2 default FND_API.G_FALSE
1464: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
1465: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
1466: , x_return_status OUT NOCOPY VARCHAR2
1467: , p_doc_type IN VARCHAR2

Line 1464: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE

1460: -------------------------------------------------------------------------------
1461: PROCEDURE do_return(
1462: p_api_version IN NUMBER
1463: , p_commit IN VARCHAR2 default FND_API.G_FALSE
1464: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
1465: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
1466: , x_return_status OUT NOCOPY VARCHAR2
1467: , p_doc_type IN VARCHAR2
1468: , p_doc_subtype IN VARCHAR2

Line 1465: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL

1461: PROCEDURE do_return(
1462: p_api_version IN NUMBER
1463: , p_commit IN VARCHAR2 default FND_API.G_FALSE
1464: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
1465: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
1466: , x_return_status OUT NOCOPY VARCHAR2
1467: , p_doc_type IN VARCHAR2
1468: , p_doc_subtype IN VARCHAR2
1469: , p_doc_level IN VARCHAR2

Line 1512: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

1508: l_progress := '020';
1509:
1510: -- Standard call to check for call compatibility
1511:
1512: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1513: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1514: END IF;
1515:
1516: l_progress := '030';

Line 1513: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1509:
1510: -- Standard call to check for call compatibility
1511:
1512: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1513: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1514: END IF;
1515:
1516: l_progress := '030';
1517:

Line 1520: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1516: l_progress := '030';
1517:
1518: -- Initialize message list if p_init_msg_list is set to TRUE.
1519:
1520: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1521: FND_MSG_PUB.initialize;
1522: END IF;
1523:
1524: l_progress := '040';

Line 1528: x_return_status := FND_API.G_RET_STS_SUCCESS;

1524: l_progress := '040';
1525:
1526: -- Initialize API return status to success
1527:
1528: x_return_status := FND_API.G_RET_STS_SUCCESS;
1529:
1530: l_progress := '050';
1531:
1532: IF g_debug_stmt THEN

Line 1553: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

1549: );
1550:
1551: l_progress := '100';
1552:
1553: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1554: OR x_return_status IS NULL
1555: ) THEN
1556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1557: END IF;

Line 1556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1552:
1553: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1554: OR x_return_status IS NULL
1555: ) THEN
1556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1557: END IF;
1558:
1559: l_progress := '110';
1560:

Line 1577: IF ( l_report_return_status = FND_API.G_RET_STS_UNEXP_ERROR

1573: );
1574:
1575: l_progress := '200';
1576:
1577: IF ( l_report_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1578: OR l_report_return_status IS NULL
1579: ) THEN
1580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1581: END IF;

Line 1580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1576:
1577: IF ( l_report_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1578: OR l_report_return_status IS NULL
1579: ) THEN
1580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1581: END IF;
1582:
1583: l_progress := '300';
1584:

Line 1586: IF FND_API.To_Boolean(p_commit) THEN

1582:
1583: l_progress := '300';
1584:
1585: -- Standard check of p_commit.
1586: IF FND_API.To_Boolean(p_commit) THEN
1587: COMMIT WORK;
1588: END IF;
1589:
1590: l_progress := '900';

Line 1604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1600: EXCEPTION
1601: WHEN OTHERS THEN
1602: BEGIN
1603: PO_DEBUG.debug_unexp(l_log_head,l_progress,'OTHERS Start');
1604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1605: IF g_debug_stmt THEN
1606: PO_DEBUG.debug_var(l_log_head,l_progress,'l_report_return_status',l_report_return_status);
1607: PO_DEBUG.debug_var(l_log_head,l_progress,'l_online_report_id',l_online_report_id);
1608: PO_DEBUG.debug_var(l_log_head,l_progress,'x_return_status',x_return_status);

Line 1678: -- FND_API.G_RET_STS_SUCCESS if validation succeeds

1674: -- distributions for which encumbrance actions were successful. Information for
1675: -- distributions with Warnings and Errors are always included.
1676: --OUT:
1677: --x_return_status
1678: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
1679: -- FND_API.G_RET_STS_ERROR if validation fails
1680: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
1681: --x_detailed_results
1682: -- Object table that stores distribution specific

Line 1679: -- FND_API.G_RET_STS_ERROR if validation fails

1675: -- distributions with Warnings and Errors are always included.
1676: --OUT:
1677: --x_return_status
1678: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
1679: -- FND_API.G_RET_STS_ERROR if validation fails
1680: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
1681: --x_detailed_results
1682: -- Object table that stores distribution specific
1683: -- reporting information for the encumbrance transaction

Line 1680: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

1676: --OUT:
1677: --x_return_status
1678: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
1679: -- FND_API.G_RET_STS_ERROR if validation fails
1680: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
1681: --x_detailed_results
1682: -- Object table that stores distribution specific
1683: -- reporting information for the encumbrance transaction
1684: --x_po_return_code

Line 1693: , p_commit IN VARCHAR2 default FND_API.G_FALSE

1689: --End of Comments
1690: -------------------------------------------------------------------------------
1691: PROCEDURE do_reject(
1692: p_api_version IN NUMBER
1693: , p_commit IN VARCHAR2 default FND_API.G_FALSE
1694: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
1695: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
1696: , x_return_status OUT NOCOPY VARCHAR2
1697: , p_doc_type IN VARCHAR2

Line 1694: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE

1690: -------------------------------------------------------------------------------
1691: PROCEDURE do_reject(
1692: p_api_version IN NUMBER
1693: , p_commit IN VARCHAR2 default FND_API.G_FALSE
1694: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
1695: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
1696: , x_return_status OUT NOCOPY VARCHAR2
1697: , p_doc_type IN VARCHAR2
1698: , p_doc_subtype IN VARCHAR2

Line 1695: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL

1691: PROCEDURE do_reject(
1692: p_api_version IN NUMBER
1693: , p_commit IN VARCHAR2 default FND_API.G_FALSE
1694: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
1695: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
1696: , x_return_status OUT NOCOPY VARCHAR2
1697: , p_doc_type IN VARCHAR2
1698: , p_doc_subtype IN VARCHAR2
1699: , p_doc_level IN VARCHAR2

Line 1744: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

1740: l_progress := '020';
1741:
1742: -- Standard call to check for call compatibility
1743:
1744: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1746: END IF;
1747:
1748: l_progress := '030';

Line 1745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1741:
1742: -- Standard call to check for call compatibility
1743:
1744: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1746: END IF;
1747:
1748: l_progress := '030';
1749:

Line 1752: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1748: l_progress := '030';
1749:
1750: -- Initialize message list if p_init_msg_list is set to TRUE.
1751:
1752: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1753: FND_MSG_PUB.initialize;
1754: END IF;
1755:
1756: l_progress := '040';

Line 1760: x_return_status := FND_API.G_RET_STS_SUCCESS;

1756: l_progress := '040';
1757:
1758: -- Initialize API return status to success
1759:
1760: x_return_status := FND_API.G_RET_STS_SUCCESS;
1761:
1762: l_progress := '050';
1763:
1764: IF g_debug_stmt THEN

Line 1786: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

1782: );
1783:
1784: l_progress := '100';
1785:
1786: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1787: OR x_return_status IS NULL
1788: ) THEN
1789: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1790: END IF;

Line 1789: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1785:
1786: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1787: OR x_return_status IS NULL
1788: ) THEN
1789: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1790: END IF;
1791:
1792: l_progress := '110';
1793:

Line 1810: IF ( l_report_return_status = FND_API.G_RET_STS_UNEXP_ERROR

1806: );
1807:
1808: l_progress := '200';
1809:
1810: IF ( l_report_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1811: OR l_report_return_status IS NULL
1812: ) THEN
1813: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1814: END IF;

Line 1813: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1809:
1810: IF ( l_report_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1811: OR l_report_return_status IS NULL
1812: ) THEN
1813: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1814: END IF;
1815:
1816: l_progress := '300';
1817:

Line 1819: IF FND_API.To_Boolean(p_commit) THEN

1815:
1816: l_progress := '300';
1817:
1818: -- Standard check of p_commit.
1819: IF FND_API.To_Boolean(p_commit) THEN
1820: COMMIT WORK;
1821: END IF;
1822:
1823: l_progress := '900';

Line 1837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1833: EXCEPTION
1834: WHEN OTHERS THEN
1835: BEGIN
1836: PO_DEBUG.debug_unexp(l_log_head,l_progress,'OTHERS Start');
1837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1838: IF g_debug_stmt THEN
1839: PO_DEBUG.debug_var(l_log_head,l_progress,'l_report_return_status',l_report_return_status);
1840: PO_DEBUG.debug_var(l_log_head,l_progress,'l_online_report_id',l_online_report_id);
1841: PO_DEBUG.debug_var(l_log_head,l_progress,'x_return_status',x_return_status);

Line 1914: -- FND_API.G_RET_STS_SUCCESS if validation succeeds

1910: -- distributions for which encumbrance actions were successful. Information for
1911: -- distributions with Warnings and Errors are always included.
1912: --OUT:
1913: --x_return_status
1914: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
1915: -- FND_API.G_RET_STS_ERROR if validation fails
1916: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
1917: --x_detailed_results
1918: -- Object table that stores distribution specific

Line 1915: -- FND_API.G_RET_STS_ERROR if validation fails

1911: -- distributions with Warnings and Errors are always included.
1912: --OUT:
1913: --x_return_status
1914: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
1915: -- FND_API.G_RET_STS_ERROR if validation fails
1916: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
1917: --x_detailed_results
1918: -- Object table that stores distribution specific
1919: -- reporting information for the encumbrance transaction

Line 1916: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

1912: --OUT:
1913: --x_return_status
1914: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
1915: -- FND_API.G_RET_STS_ERROR if validation fails
1916: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
1917: --x_detailed_results
1918: -- Object table that stores distribution specific
1919: -- reporting information for the encumbrance transaction
1920: --x_po_return_code

Line 1929: , p_commit IN VARCHAR2 default FND_API.G_FALSE

1925: --End of Comments
1926: -------------------------------------------------------------------------------
1927: PROCEDURE do_cancel(
1928: p_api_version IN NUMBER
1929: , p_commit IN VARCHAR2 default FND_API.G_FALSE
1930: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
1931: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
1932: , x_return_status OUT NOCOPY VARCHAR2
1933: , p_doc_type IN VARCHAR2

Line 1930: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE

1926: -------------------------------------------------------------------------------
1927: PROCEDURE do_cancel(
1928: p_api_version IN NUMBER
1929: , p_commit IN VARCHAR2 default FND_API.G_FALSE
1930: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
1931: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
1932: , x_return_status OUT NOCOPY VARCHAR2
1933: , p_doc_type IN VARCHAR2
1934: , p_doc_subtype IN VARCHAR2

Line 1931: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL

1927: PROCEDURE do_cancel(
1928: p_api_version IN NUMBER
1929: , p_commit IN VARCHAR2 default FND_API.G_FALSE
1930: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
1931: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
1932: , x_return_status OUT NOCOPY VARCHAR2
1933: , p_doc_type IN VARCHAR2
1934: , p_doc_subtype IN VARCHAR2
1935: , p_doc_level IN VARCHAR2

Line 1980: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

1976: l_progress := '020';
1977:
1978: -- Standard call to check for call compatibility
1979:
1980: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1981: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1982: END IF;
1983:
1984: l_progress := '030';

Line 1981: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1977:
1978: -- Standard call to check for call compatibility
1979:
1980: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1981: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1982: END IF;
1983:
1984: l_progress := '030';
1985:

Line 1988: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1984: l_progress := '030';
1985:
1986: -- Initialize message list if p_init_msg_list is set to TRUE.
1987:
1988: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1989: FND_MSG_PUB.initialize;
1990: END IF;
1991:
1992: l_progress := '040';

Line 1996: x_return_status := FND_API.G_RET_STS_SUCCESS;

1992: l_progress := '040';
1993:
1994: -- Initialize API return status to success
1995:
1996: x_return_status := FND_API.G_RET_STS_SUCCESS;
1997:
1998: l_progress := '050';
1999:
2000: IF g_debug_stmt THEN

Line 2022: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

2018: );
2019:
2020: l_progress := '100';
2021:
2022: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2023: OR x_return_status IS NULL
2024: ) THEN
2025: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2026: END IF;

Line 2025: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2021:
2022: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2023: OR x_return_status IS NULL
2024: ) THEN
2025: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2026: END IF;
2027:
2028: l_progress := '110';
2029:

Line 2046: IF ( l_report_return_status = FND_API.G_RET_STS_UNEXP_ERROR

2042: );
2043:
2044: l_progress := '200';
2045:
2046: IF ( l_report_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2047: OR l_report_return_status IS NULL
2048: ) THEN
2049: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2050: END IF;

Line 2049: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2045:
2046: IF ( l_report_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2047: OR l_report_return_status IS NULL
2048: ) THEN
2049: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2050: END IF;
2051:
2052: l_progress := '300';
2053:

Line 2055: IF FND_API.To_Boolean(p_commit) THEN

2051:
2052: l_progress := '300';
2053:
2054: -- Standard check of p_commit.
2055: IF FND_API.To_Boolean(p_commit) THEN
2056: COMMIT WORK;
2057: END IF;
2058:
2059: l_progress := '900';

Line 2073: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2069: EXCEPTION
2070: WHEN OTHERS THEN
2071: BEGIN
2072: PO_DEBUG.debug_unexp(l_log_head,l_progress,'OTHERS Start');
2073: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2074: IF g_debug_stmt THEN
2075: PO_DEBUG.debug_var(l_log_head,l_progress,'l_report_return_status',l_report_return_status);
2076: PO_DEBUG.debug_var(l_log_head,l_progress,'l_online_report_id',l_online_report_id);
2077: PO_DEBUG.debug_var(l_log_head,l_progress,'x_return_status',x_return_status);

Line 2144: -- FND_API.G_RET_STS_SUCCESS if validation succeeds

2140: -- distributions for which encumbrance actions were successful. Information for
2141: -- distributions with Warnings and Errors are always included.
2142: --OUT:
2143: --x_return_status
2144: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
2145: -- FND_API.G_RET_STS_ERROR if validation fails
2146: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
2147: --x_detailed_results
2148: -- Object table that stores distribution specific

Line 2145: -- FND_API.G_RET_STS_ERROR if validation fails

2141: -- distributions with Warnings and Errors are always included.
2142: --OUT:
2143: --x_return_status
2144: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
2145: -- FND_API.G_RET_STS_ERROR if validation fails
2146: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
2147: --x_detailed_results
2148: -- Object table that stores distribution specific
2149: -- reporting information for the encumbrance transaction

Line 2146: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

2142: --OUT:
2143: --x_return_status
2144: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
2145: -- FND_API.G_RET_STS_ERROR if validation fails
2146: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
2147: --x_detailed_results
2148: -- Object table that stores distribution specific
2149: -- reporting information for the encumbrance transaction
2150: --x_po_return_code

Line 2159: , p_commit IN VARCHAR2 default FND_API.G_FALSE

2155: --End of Comments
2156: -------------------------------------------------------------------------------
2157: PROCEDURE do_adjust(
2158: p_api_version IN NUMBER
2159: , p_commit IN VARCHAR2 default FND_API.G_FALSE
2160: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
2161: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
2162: , x_return_status OUT NOCOPY VARCHAR2
2163: , p_doc_type IN VARCHAR2

Line 2160: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE

2156: -------------------------------------------------------------------------------
2157: PROCEDURE do_adjust(
2158: p_api_version IN NUMBER
2159: , p_commit IN VARCHAR2 default FND_API.G_FALSE
2160: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
2161: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
2162: , x_return_status OUT NOCOPY VARCHAR2
2163: , p_doc_type IN VARCHAR2
2164: , p_doc_subtype IN VARCHAR2

Line 2161: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL

2157: PROCEDURE do_adjust(
2158: p_api_version IN NUMBER
2159: , p_commit IN VARCHAR2 default FND_API.G_FALSE
2160: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
2161: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
2162: , x_return_status OUT NOCOPY VARCHAR2
2163: , p_doc_type IN VARCHAR2
2164: , p_doc_subtype IN VARCHAR2
2165: , p_employee_id IN NUMBER

Line 2208: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

2204: l_progress := '020';
2205:
2206: -- Standard call to check for call compatibility
2207:
2208: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2210: END IF;
2211:
2212: l_progress := '030';

Line 2209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2205:
2206: -- Standard call to check for call compatibility
2207:
2208: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2210: END IF;
2211:
2212: l_progress := '030';
2213:

Line 2216: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2212: l_progress := '030';
2213:
2214: -- Initialize message list if p_init_msg_list is set to TRUE.
2215:
2216: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2217: FND_MSG_PUB.initialize;
2218: END IF;
2219:
2220: l_progress := '040';

Line 2224: x_return_status := FND_API.G_RET_STS_SUCCESS;

2220: l_progress := '040';
2221:
2222: -- Initialize API return status to success
2223:
2224: x_return_status := FND_API.G_RET_STS_SUCCESS;
2225:
2226: l_progress := '050';
2227:
2228: IF g_debug_stmt THEN

Line 2249: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

2245: );
2246:
2247: l_progress := '100';
2248:
2249: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2250: OR x_return_status IS NULL
2251: ) THEN
2252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2253: END IF;

Line 2252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2248:
2249: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2250: OR x_return_status IS NULL
2251: ) THEN
2252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2253: END IF;
2254:
2255: l_progress := '110';
2256:

Line 2273: IF ( l_report_return_status = FND_API.G_RET_STS_UNEXP_ERROR

2269: );
2270:
2271: l_progress := '200';
2272:
2273: IF ( l_report_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2274: OR l_report_return_status IS NULL
2275: ) THEN
2276: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2277: END IF;

Line 2276: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2272:
2273: IF ( l_report_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2274: OR l_report_return_status IS NULL
2275: ) THEN
2276: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2277: END IF;
2278:
2279: l_progress := '300';
2280:

Line 2282: IF FND_API.To_Boolean(p_commit) THEN

2278:
2279: l_progress := '300';
2280:
2281: -- Standard check of p_commit.
2282: IF FND_API.To_Boolean(p_commit) THEN
2283: COMMIT WORK;
2284: END IF;
2285:
2286: l_progress := '900';

Line 2300: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2296: EXCEPTION
2297: WHEN OTHERS THEN
2298: BEGIN
2299: PO_DEBUG.debug_unexp(l_log_head,l_progress,'OTHERS Start');
2300: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2301: IF g_debug_stmt THEN
2302: PO_DEBUG.debug_var(l_log_head,l_progress,'l_report_return_status',l_report_return_status);
2303: PO_DEBUG.debug_var(l_log_head,l_progress,'l_online_report_id',l_online_report_id);
2304: PO_DEBUG.debug_var(l_log_head,l_progress,'x_return_status',x_return_status);

Line 2371: -- FND_API.G_RET_STS_SUCCESS if validation succeeds

2367: -- distributions for which encumbrance actions were successful. Information for
2368: -- distributions with Warnings and Errors are always included.
2369: --OUT:
2370: --x_return_status
2371: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
2372: -- FND_API.G_RET_STS_ERROR if validation fails
2373: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
2374: --x_detailed_results
2375: -- Object table that stores distribution specific

Line 2372: -- FND_API.G_RET_STS_ERROR if validation fails

2368: -- distributions with Warnings and Errors are always included.
2369: --OUT:
2370: --x_return_status
2371: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
2372: -- FND_API.G_RET_STS_ERROR if validation fails
2373: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
2374: --x_detailed_results
2375: -- Object table that stores distribution specific
2376: -- reporting information for the encumbrance transaction

Line 2373: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

2369: --OUT:
2370: --x_return_status
2371: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
2372: -- FND_API.G_RET_STS_ERROR if validation fails
2373: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
2374: --x_detailed_results
2375: -- Object table that stores distribution specific
2376: -- reporting information for the encumbrance transaction
2377: --x_po_return_code

Line 2386: , p_commit IN VARCHAR2 default FND_API.G_FALSE

2382: --End of Comments
2383: -------------------------------------------------------------------------------
2384: PROCEDURE do_final_close(
2385: p_api_version IN NUMBER
2386: , p_commit IN VARCHAR2 default FND_API.G_FALSE
2387: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
2388: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
2389: , x_return_status OUT NOCOPY VARCHAR2
2390: , p_doc_type IN VARCHAR2

Line 2387: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE

2383: -------------------------------------------------------------------------------
2384: PROCEDURE do_final_close(
2385: p_api_version IN NUMBER
2386: , p_commit IN VARCHAR2 default FND_API.G_FALSE
2387: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
2388: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
2389: , x_return_status OUT NOCOPY VARCHAR2
2390: , p_doc_type IN VARCHAR2
2391: , p_doc_subtype IN VARCHAR2

Line 2388: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL

2384: PROCEDURE do_final_close(
2385: p_api_version IN NUMBER
2386: , p_commit IN VARCHAR2 default FND_API.G_FALSE
2387: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
2388: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
2389: , x_return_status OUT NOCOPY VARCHAR2
2390: , p_doc_type IN VARCHAR2
2391: , p_doc_subtype IN VARCHAR2
2392: , p_doc_level IN VARCHAR2

Line 2435: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

2431: l_progress := '020';
2432:
2433: -- Standard call to check for call compatibility
2434:
2435: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2437: END IF;
2438:
2439: l_progress := '030';

Line 2436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2432:
2433: -- Standard call to check for call compatibility
2434:
2435: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2437: END IF;
2438:
2439: l_progress := '030';
2440:

Line 2443: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2439: l_progress := '030';
2440:
2441: -- Initialize message list if p_init_msg_list is set to TRUE.
2442:
2443: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2444: FND_MSG_PUB.initialize;
2445: END IF;
2446:
2447: l_progress := '040';

Line 2451: x_return_status := FND_API.G_RET_STS_SUCCESS;

2447: l_progress := '040';
2448:
2449: -- Initialize API return status to success
2450:
2451: x_return_status := FND_API.G_RET_STS_SUCCESS;
2452:
2453: l_progress := '050';
2454:
2455: IF g_debug_stmt THEN

Line 2476: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

2472: );
2473:
2474: l_progress := '100';
2475:
2476: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2477: OR x_return_status IS NULL
2478: ) THEN
2479: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2480: END IF;

Line 2479: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2475:
2476: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2477: OR x_return_status IS NULL
2478: ) THEN
2479: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2480: END IF;
2481:
2482: l_progress := '110';
2483:

Line 2500: IF ( l_report_return_status = FND_API.G_RET_STS_UNEXP_ERROR

2496: );
2497:
2498: l_progress := '200';
2499:
2500: IF ( l_report_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2501: OR l_report_return_status IS NULL
2502: ) THEN
2503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2504: END IF;

Line 2503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2499:
2500: IF ( l_report_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2501: OR l_report_return_status IS NULL
2502: ) THEN
2503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2504: END IF;
2505:
2506: l_progress := '300';
2507:

Line 2509: IF FND_API.To_Boolean(p_commit) THEN

2505:
2506: l_progress := '300';
2507:
2508: -- Standard check of p_commit.
2509: IF FND_API.To_Boolean(p_commit) THEN
2510: COMMIT WORK;
2511: END IF;
2512:
2513: l_progress := '900';

Line 2527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2523: EXCEPTION
2524: WHEN OTHERS THEN
2525: BEGIN
2526: PO_DEBUG.debug_unexp(l_log_head,l_progress,'OTHERS Start');
2527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2528: IF g_debug_stmt THEN
2529: PO_DEBUG.debug_var(l_log_head,l_progress,'l_report_return_status',l_report_return_status);
2530: PO_DEBUG.debug_var(l_log_head,l_progress,'l_online_report_id',l_online_report_id);
2531: PO_DEBUG.debug_var(l_log_head,l_progress,'x_return_status',x_return_status);

Line 2609: -- FND_API.G_RET_STS_SUCCESS if validation succeeds

2605: --OUT:
2606: --x_packet_id
2607: -- GL PACKET ID, if gl entries are made otherwise null
2608: --x_return_status
2609: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
2610: -- FND_API.G_RET_STS_ERROR if validation fails
2611: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
2612: --Testing:
2613: --

Line 2610: -- FND_API.G_RET_STS_ERROR if validation fails

2606: --x_packet_id
2607: -- GL PACKET ID, if gl entries are made otherwise null
2608: --x_return_status
2609: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
2610: -- FND_API.G_RET_STS_ERROR if validation fails
2611: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
2612: --Testing:
2613: --
2614: --End of Comments

Line 2611: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

2607: -- GL PACKET ID, if gl entries are made otherwise null
2608: --x_return_status
2609: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
2610: -- FND_API.G_RET_STS_ERROR if validation fails
2611: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
2612: --Testing:
2613: --
2614: --End of Comments
2615: -------------------------------------------------------------------------------

Line 2618: p_commit IN VARCHAR2 default FND_API.G_FALSE,

2614: --End of Comments
2615: -------------------------------------------------------------------------------
2616: PROCEDURE reinstate_po_encumbrance(
2617: p_api_version IN NUMBER,
2618: p_commit IN VARCHAR2 default FND_API.G_FALSE,
2619: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
2620: p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL,
2621: p_distribution_id IN NUMBER,
2622: p_invoice_id IN NUMBER,

Line 2619: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,

2615: -------------------------------------------------------------------------------
2616: PROCEDURE reinstate_po_encumbrance(
2617: p_api_version IN NUMBER,
2618: p_commit IN VARCHAR2 default FND_API.G_FALSE,
2619: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
2620: p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL,
2621: p_distribution_id IN NUMBER,
2622: p_invoice_id IN NUMBER,
2623: p_encumbrance_amt IN NUMBER,

Line 2620: p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL,

2616: PROCEDURE reinstate_po_encumbrance(
2617: p_api_version IN NUMBER,
2618: p_commit IN VARCHAR2 default FND_API.G_FALSE,
2619: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
2620: p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL,
2621: p_distribution_id IN NUMBER,
2622: p_invoice_id IN NUMBER,
2623: p_encumbrance_amt IN NUMBER,
2624: p_qty_cancelled IN NUMBER,

Line 2675: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

2671: l_progress := '020';
2672:
2673: -- Standard call to check for call compatibility
2674:
2675: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2676: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2677: END IF;
2678:
2679: l_progress := '030';

Line 2676: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2672:
2673: -- Standard call to check for call compatibility
2674:
2675: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2676: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2677: END IF;
2678:
2679: l_progress := '030';
2680:

Line 2683: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2679: l_progress := '030';
2680:
2681: -- Initialize message list if p_init_msg_list is set to TRUE.
2682:
2683: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2684: FND_MSG_PUB.initialize;
2685: END IF;
2686:
2687: l_progress := '040';

Line 2691: x_return_status := FND_API.G_RET_STS_SUCCESS;

2687: l_progress := '040';
2688:
2689: -- Initialize API return status to success
2690:
2691: x_return_status := FND_API.G_RET_STS_SUCCESS;
2692:
2693: l_progress := '050';
2694:
2695: IF g_debug_stmt THEN

Line 2719: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

2715: );
2716:
2717: l_progress := '100';
2718:
2719: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2720: OR x_return_status IS NULL
2721: ) THEN
2722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2723: END IF;

Line 2722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2718:
2719: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2720: OR x_return_status IS NULL
2721: ) THEN
2722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2723: END IF;
2724:
2725: l_progress := '110';
2726:

Line 2735: IF FND_API.To_Boolean(p_commit) THEN

2731:
2732: l_progress := '200';
2733:
2734: -- Standard check of p_commit.
2735: IF FND_API.To_Boolean(p_commit) THEN
2736: COMMIT WORK;
2737: END IF;
2738:
2739: l_progress := '900';

Line 2751: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2747: EXCEPTION
2748: WHEN OTHERS THEN
2749: BEGIN
2750: PO_DEBUG.debug_unexp(l_log_head,l_progress,'OTHERS Start');
2751: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2752: IF g_debug_stmt THEN
2753: PO_DEBUG.debug_var(l_log_head,l_progress,'x_return_status',x_return_status);
2754: PO_DEBUG.debug_var(l_log_head,l_progress,'x_packet_id',x_packet_id);
2755: END IF;

Line 2798: -- FND_API.G_RET_STS_SUCCESS if validation succeeds

2794: -- A table of po_header_ids corresponding to the PAs that we are checking
2795: -- the encumbered state of.
2796: --OUT:
2797: --x_return_status
2798: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
2799: -- FND_API.G_RET_STS_ERROR if validation fails
2800: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
2801: --x_results_tbl
2802: -- A table of Y/N results indicating whether each PA is encumbered or not.

Line 2799: -- FND_API.G_RET_STS_ERROR if validation fails

2795: -- the encumbered state of.
2796: --OUT:
2797: --x_return_status
2798: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
2799: -- FND_API.G_RET_STS_ERROR if validation fails
2800: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
2801: --x_results_tbl
2802: -- A table of Y/N results indicating whether each PA is encumbered or not.
2803: -- Y = the given PA is/can be encumbered.

Line 2800: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

2796: --OUT:
2797: --x_return_status
2798: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
2799: -- FND_API.G_RET_STS_ERROR if validation fails
2800: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
2801: --x_results_tbl
2802: -- A table of Y/N results indicating whether each PA is encumbered or not.
2803: -- Y = the given PA is/can be encumbered.
2804: -- N = the PA is not eligible for encumbrance

Line 2811: , p_commit IN VARCHAR2 default FND_API.G_FALSE

2807: --End of Comments
2808: -------------------------------------------------------------------------------
2809: PROCEDURE is_agreement_encumbered(
2810: p_api_version IN NUMBER
2811: , p_commit IN VARCHAR2 default FND_API.G_FALSE
2812: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
2813: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
2814: , x_return_status OUT NOCOPY VARCHAR2
2815: , p_agreement_id_tbl IN PO_TBL_NUMBER

Line 2812: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE

2808: -------------------------------------------------------------------------------
2809: PROCEDURE is_agreement_encumbered(
2810: p_api_version IN NUMBER
2811: , p_commit IN VARCHAR2 default FND_API.G_FALSE
2812: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
2813: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
2814: , x_return_status OUT NOCOPY VARCHAR2
2815: , p_agreement_id_tbl IN PO_TBL_NUMBER
2816: , x_agreement_encumbered_tbl OUT NOCOPY PO_TBL_VARCHAR1

Line 2813: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL

2809: PROCEDURE is_agreement_encumbered(
2810: p_api_version IN NUMBER
2811: , p_commit IN VARCHAR2 default FND_API.G_FALSE
2812: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
2813: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
2814: , x_return_status OUT NOCOPY VARCHAR2
2815: , p_agreement_id_tbl IN PO_TBL_NUMBER
2816: , x_agreement_encumbered_tbl OUT NOCOPY PO_TBL_VARCHAR1
2817: )

Line 2845: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

2841: l_progress := '020';
2842:
2843: -- Standard call to check for call compatibility
2844:
2845: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2846: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2847: END IF;
2848:
2849: l_progress := '030';

Line 2846: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2842:
2843: -- Standard call to check for call compatibility
2844:
2845: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2846: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2847: END IF;
2848:
2849: l_progress := '030';
2850:

Line 2853: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2849: l_progress := '030';
2850:
2851: -- Initialize message list if p_init_msg_list is set to TRUE.
2852:
2853: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2854: FND_MSG_PUB.initialize;
2855: END IF;
2856:
2857: l_progress := '040';

Line 2861: x_return_status := FND_API.G_RET_STS_SUCCESS;

2857: l_progress := '040';
2858:
2859: -- Initialize API return status to success
2860:
2861: x_return_status := FND_API.G_RET_STS_SUCCESS;
2862:
2863: l_progress := '050';
2864:
2865: IF g_debug_stmt THEN

Line 2879: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

2875: );
2876:
2877: l_progress := '100';
2878:
2879: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2880: OR x_return_status IS NULL
2881: ) THEN
2882: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2883: END IF;

Line 2882: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2878:
2879: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2880: OR x_return_status IS NULL
2881: ) THEN
2882: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2883: END IF;
2884:
2885: l_progress := '110';
2886:

Line 2895: IF FND_API.To_Boolean(p_commit) THEN

2891:
2892: l_progress := '200';
2893:
2894: -- Standard check of p_commit.
2895: IF FND_API.To_Boolean(p_commit) THEN
2896: COMMIT WORK;
2897: END IF;
2898:
2899: l_progress := '900';

Line 2911: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2907: EXCEPTION
2908: WHEN OTHERS THEN
2909: BEGIN
2910: PO_DEBUG.debug_unexp(l_log_head,l_progress,'OTHERS Start');
2911: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2912: IF g_debug_stmt THEN
2913: PO_DEBUG.debug_var(l_log_head,l_progress,'x_return_status',x_return_status);
2914: PO_DEBUG.debug_var(l_log_head,l_progress,'x_agreement_encumbered_tbl',x_agreement_encumbered_tbl);
2915: END IF;

Line 2969: -- FND_API.G_RET_STS_SUCCESS if validation succeeds

2965: -- The id corresponding to the doc level type:
2966: -- header_id/release_id, line_id, line_location_id, distribution_id
2967: --OUT:
2968: --x_return_status
2969: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
2970: -- FND_API.G_RET_STS_ERROR if validation fails
2971: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
2972: --x_result
2973: -- Indicates whether funds reservation is possible on this entity

Line 2970: -- FND_API.G_RET_STS_ERROR if validation fails

2966: -- header_id/release_id, line_id, line_location_id, distribution_id
2967: --OUT:
2968: --x_return_status
2969: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
2970: -- FND_API.G_RET_STS_ERROR if validation fails
2971: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
2972: --x_result
2973: -- Indicates whether funds reservation is possible on this entity
2974: -- 'Y' means it is possible, 'N' means it isn't.

Line 2971: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

2967: --OUT:
2968: --x_return_status
2969: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
2970: -- FND_API.G_RET_STS_ERROR if validation fails
2971: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
2972: --x_result
2973: -- Indicates whether funds reservation is possible on this entity
2974: -- 'Y' means it is possible, 'N' means it isn't.
2975: --Testing:

Line 2981: , p_commit IN VARCHAR2 default FND_API.G_FALSE

2977: --End of Comments
2978: -------------------------------------------------------------------------------
2979: PROCEDURE is_reservable(
2980: p_api_version IN NUMBER
2981: , p_commit IN VARCHAR2 default FND_API.G_FALSE
2982: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
2983: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
2984: , x_return_status OUT NOCOPY VARCHAR2
2985: , p_doc_type IN VARCHAR2

Line 2982: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE

2978: -------------------------------------------------------------------------------
2979: PROCEDURE is_reservable(
2980: p_api_version IN NUMBER
2981: , p_commit IN VARCHAR2 default FND_API.G_FALSE
2982: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
2983: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
2984: , x_return_status OUT NOCOPY VARCHAR2
2985: , p_doc_type IN VARCHAR2
2986: , p_doc_subtype IN VARCHAR2

Line 2983: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL

2979: PROCEDURE is_reservable(
2980: p_api_version IN NUMBER
2981: , p_commit IN VARCHAR2 default FND_API.G_FALSE
2982: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
2983: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
2984: , x_return_status OUT NOCOPY VARCHAR2
2985: , p_doc_type IN VARCHAR2
2986: , p_doc_subtype IN VARCHAR2
2987: , p_doc_level IN VARCHAR2

Line 3021: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

3017: l_progress := '020';
3018:
3019: -- Standard call to check for call compatibility
3020:
3021: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3022: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3023: END IF;
3024:
3025: l_progress := '030';

Line 3022: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3018:
3019: -- Standard call to check for call compatibility
3020:
3021: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3022: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3023: END IF;
3024:
3025: l_progress := '030';
3026:

Line 3029: IF FND_API.to_Boolean( p_init_msg_list ) THEN

3025: l_progress := '030';
3026:
3027: -- Initialize message list if p_init_msg_list is set to TRUE.
3028:
3029: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3030: FND_MSG_PUB.initialize;
3031: END IF;
3032:
3033: l_progress := '040';

Line 3037: x_return_status := FND_API.G_RET_STS_SUCCESS;

3033: l_progress := '040';
3034:
3035: -- Initialize API return status to success
3036:
3037: x_return_status := FND_API.G_RET_STS_SUCCESS;
3038:
3039: l_progress := '050';
3040:
3041: IF g_debug_stmt THEN

Line 3058: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

3054: );
3055:
3056: l_progress := '100';
3057:
3058: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
3059: OR x_return_status IS NULL
3060: ) THEN
3061: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3062: END IF;

Line 3061: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3057:
3058: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
3059: OR x_return_status IS NULL
3060: ) THEN
3061: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3062: END IF;
3063:
3064: l_progress := '110';
3065:

Line 3074: IF FND_API.To_Boolean(p_commit) THEN

3070:
3071: l_progress := '200';
3072:
3073: -- Standard check of p_commit.
3074: IF FND_API.To_Boolean(p_commit) THEN
3075: COMMIT WORK;
3076: END IF;
3077:
3078: l_progress := '900';

Line 3090: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3086: EXCEPTION
3087: WHEN OTHERS THEN
3088: BEGIN
3089: PO_DEBUG.debug_unexp(l_log_head,l_progress,'OTHERS Start');
3090: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3091: IF g_debug_stmt THEN
3092: PO_DEBUG.debug_var(l_log_head,l_progress,'x_return_status',x_return_status);
3093: PO_DEBUG.debug_var(l_log_head,l_progress,'x_reservable_flag',x_reservable_flag);
3094: END IF;

Line 3148: -- FND_API.G_RET_STS_SUCCESS if validation succeeds

3144: -- The id corresponding to the doc level type:
3145: -- header_id/release_id, line_id, line_location_id, distribution_id
3146: --OUT:
3147: --x_return_status
3148: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
3149: -- FND_API.G_RET_STS_ERROR if validation fails
3150: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
3151: --x_result
3152: -- Indicates whether funds reservation is possible on this entity

Line 3149: -- FND_API.G_RET_STS_ERROR if validation fails

3145: -- header_id/release_id, line_id, line_location_id, distribution_id
3146: --OUT:
3147: --x_return_status
3148: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
3149: -- FND_API.G_RET_STS_ERROR if validation fails
3150: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
3151: --x_result
3152: -- Indicates whether funds reservation is possible on this entity
3153: -- 'Y' means it is possible, 'N' means it isn't.

Line 3150: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

3146: --OUT:
3147: --x_return_status
3148: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
3149: -- FND_API.G_RET_STS_ERROR if validation fails
3150: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
3151: --x_result
3152: -- Indicates whether funds reservation is possible on this entity
3153: -- 'Y' means it is possible, 'N' means it isn't.
3154: --Testing:

Line 3160: , p_commit IN VARCHAR2 default FND_API.G_FALSE

3156: --End of Comments
3157: -------------------------------------------------------------------------------
3158: PROCEDURE is_unreservable(
3159: p_api_version IN NUMBER
3160: , p_commit IN VARCHAR2 default FND_API.G_FALSE
3161: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
3162: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
3163: , x_return_status OUT NOCOPY VARCHAR2
3164: , p_doc_type IN VARCHAR2

Line 3161: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE

3157: -------------------------------------------------------------------------------
3158: PROCEDURE is_unreservable(
3159: p_api_version IN NUMBER
3160: , p_commit IN VARCHAR2 default FND_API.G_FALSE
3161: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
3162: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
3163: , x_return_status OUT NOCOPY VARCHAR2
3164: , p_doc_type IN VARCHAR2
3165: , p_doc_subtype IN VARCHAR2

Line 3162: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL

3158: PROCEDURE is_unreservable(
3159: p_api_version IN NUMBER
3160: , p_commit IN VARCHAR2 default FND_API.G_FALSE
3161: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
3162: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
3163: , x_return_status OUT NOCOPY VARCHAR2
3164: , p_doc_type IN VARCHAR2
3165: , p_doc_subtype IN VARCHAR2
3166: , p_doc_level IN VARCHAR2

Line 3200: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

3196: l_progress := '020';
3197:
3198: -- Standard call to check for call compatibility
3199:
3200: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3202: END IF;
3203:
3204: l_progress := '030';

Line 3201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3197:
3198: -- Standard call to check for call compatibility
3199:
3200: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3202: END IF;
3203:
3204: l_progress := '030';
3205:

Line 3208: IF FND_API.to_Boolean( p_init_msg_list ) THEN

3204: l_progress := '030';
3205:
3206: -- Initialize message list if p_init_msg_list is set to TRUE.
3207:
3208: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3209: FND_MSG_PUB.initialize;
3210: END IF;
3211:
3212: l_progress := '040';

Line 3216: x_return_status := FND_API.G_RET_STS_SUCCESS;

3212: l_progress := '040';
3213:
3214: -- Initialize API return status to success
3215:
3216: x_return_status := FND_API.G_RET_STS_SUCCESS;
3217:
3218: l_progress := '050';
3219:
3220: IF g_debug_stmt THEN

Line 3237: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

3233: );
3234:
3235: l_progress := '100';
3236:
3237: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
3238: OR x_return_status IS NULL
3239: ) THEN
3240: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3241: END IF;

Line 3240: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3236:
3237: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
3238: OR x_return_status IS NULL
3239: ) THEN
3240: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3241: END IF;
3242:
3243: l_progress := '110';
3244:

Line 3253: IF FND_API.To_Boolean(p_commit) THEN

3249:
3250: l_progress := '200';
3251:
3252: -- Standard check of p_commit.
3253: IF FND_API.To_Boolean(p_commit) THEN
3254: COMMIT WORK;
3255: END IF;
3256:
3257: l_progress := '900';

Line 3269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3265: EXCEPTION
3266: WHEN OTHERS THEN
3267: BEGIN
3268: PO_DEBUG.debug_unexp(l_log_head,l_progress,'OTHERS Start');
3269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3270: IF g_debug_stmt THEN
3271: PO_DEBUG.debug_var(l_log_head,l_progress,'x_return_status',x_return_status);
3272: PO_DEBUG.debug_var(l_log_head,l_progress,'x_unreservable_flag',x_unreservable_flag);
3273: END IF;

Line 3362: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE

3358: --End of Comments
3359: -------------------------------------------------------------------------------
3360: PROCEDURE populate_encumbrance_gt(
3361: p_api_version IN NUMBER
3362: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
3363: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
3364: , x_return_status OUT NOCOPY VARCHAR2
3365: , p_doc_type IN VARCHAR2
3366: , p_doc_level IN VARCHAR2

Line 3363: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL

3359: -------------------------------------------------------------------------------
3360: PROCEDURE populate_encumbrance_gt(
3361: p_api_version IN NUMBER
3362: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
3363: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
3364: , x_return_status OUT NOCOPY VARCHAR2
3365: , p_doc_type IN VARCHAR2
3366: , p_doc_level IN VARCHAR2
3367: , p_doc_level_id_tbl IN po_tbl_number

Line 3405: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

3401:
3402: l_progress := '020';
3403:
3404: -- Standard call to check for call compatibility
3405: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3407: END IF;
3408:
3409: l_progress := '030';

Line 3406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3402: l_progress := '020';
3403:
3404: -- Standard call to check for call compatibility
3405: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3407: END IF;
3408:
3409: l_progress := '030';
3410:

Line 3412: IF FND_API.to_Boolean( p_init_msg_list ) THEN

3408:
3409: l_progress := '030';
3410:
3411: -- Initialize message list if p_init_msg_list is set to TRUE.
3412: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3413: FND_MSG_PUB.initialize;
3414: END IF;
3415:
3416: l_progress := '040';

Line 3419: x_return_status := FND_API.G_RET_STS_SUCCESS;

3415:
3416: l_progress := '040';
3417:
3418: -- Initialize API return status to success
3419: x_return_status := FND_API.G_RET_STS_SUCCESS;
3420:
3421: l_progress := '050';
3422:
3423: -- Set up the parameters for the call to the private API.

Line 3450: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3446: l_progress := '160';
3447: l_adjustment_status_tbl := po_tbl_varchar5(NULL);
3448: ELSE
3449: l_progress := '170';
3450: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3451: END IF;
3452:
3453:
3454: l_progress := '200';

Line 3478: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3474: EXCEPTION
3475: WHEN OTHERS THEN
3476: BEGIN
3477: PO_DEBUG.debug_unexp(l_log_head,l_progress,'OTHERS Start');
3478: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3479: IF g_debug_stmt THEN
3480: PO_DEBUG.debug_var(l_log_head,l_progress,'x_return_status',x_return_status);
3481: END IF;
3482: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 3541: RAISE FND_API.g_exc_unexpected_error;

3537: PO_LOG.exc(d_module_base, d_progress, 'Unhandled exception in '
3538: ||l_module_name||' '||SQLCODE||' '||SQLERRM);
3539: PO_LOG.proc_end(d_module_base, 'PO_DOCUMENT_FUNDS_PVT.g_ONLINE_REPORT_ID', PO_DOCUMENT_FUNDS_PVT.g_ONLINE_REPORT_ID);
3540: END IF;
3541: RAISE FND_API.g_exc_unexpected_error;
3542: END;
3543:
3544: --
3545: END PO_DOCUMENT_FUNDS_GRP;