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 1199: -- FND_API.G_RET_STS_SUCCESS if validation succeeds

1195: -- distributions for which encumbrance actions were successful. Information for
1196: -- distributions with Warnings and Errors are always included.
1197: --OUT:
1198: --x_return_status
1199: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
1200: -- FND_API.G_RET_STS_ERROR if validation fails
1201: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
1202: --x_detailed_results
1203: -- Object table that stores distribution specific

Line 1200: -- FND_API.G_RET_STS_ERROR if validation fails

1196: -- distributions with Warnings and Errors are always included.
1197: --OUT:
1198: --x_return_status
1199: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
1200: -- FND_API.G_RET_STS_ERROR if validation fails
1201: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
1202: --x_detailed_results
1203: -- Object table that stores distribution specific
1204: -- reporting information for the encumbrance transaction

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

1197: --OUT:
1198: --x_return_status
1199: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
1200: -- FND_API.G_RET_STS_ERROR if validation fails
1201: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
1202: --x_detailed_results
1203: -- Object table that stores distribution specific
1204: -- reporting information for the encumbrance transaction
1205: --x_po_return_code

Line 1214: , p_commit IN VARCHAR2 default FND_API.G_FALSE

1210: --End of Comments
1211: -------------------------------------------------------------------------------
1212: PROCEDURE do_return(
1213: p_api_version IN NUMBER
1214: , p_commit IN VARCHAR2 default FND_API.G_FALSE
1215: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
1216: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
1217: , x_return_status OUT NOCOPY VARCHAR2
1218: , p_doc_type IN VARCHAR2

Line 1215: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE

1211: -------------------------------------------------------------------------------
1212: PROCEDURE do_return(
1213: p_api_version IN NUMBER
1214: , p_commit IN VARCHAR2 default FND_API.G_FALSE
1215: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
1216: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
1217: , x_return_status OUT NOCOPY VARCHAR2
1218: , p_doc_type IN VARCHAR2
1219: , p_doc_subtype IN VARCHAR2

Line 1216: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL

1212: PROCEDURE do_return(
1213: p_api_version IN NUMBER
1214: , p_commit IN VARCHAR2 default FND_API.G_FALSE
1215: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
1216: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
1217: , x_return_status OUT NOCOPY VARCHAR2
1218: , p_doc_type IN VARCHAR2
1219: , p_doc_subtype IN VARCHAR2
1220: , p_doc_level IN VARCHAR2

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

1259: l_progress := '020';
1260:
1261: -- Standard call to check for call compatibility
1262:
1263: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1265: END IF;
1266:
1267: l_progress := '030';

Line 1264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1260:
1261: -- Standard call to check for call compatibility
1262:
1263: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1265: END IF;
1266:
1267: l_progress := '030';
1268:

Line 1271: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1267: l_progress := '030';
1268:
1269: -- Initialize message list if p_init_msg_list is set to TRUE.
1270:
1271: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1272: FND_MSG_PUB.initialize;
1273: END IF;
1274:
1275: l_progress := '040';

Line 1279: x_return_status := FND_API.G_RET_STS_SUCCESS;

1275: l_progress := '040';
1276:
1277: -- Initialize API return status to success
1278:
1279: x_return_status := FND_API.G_RET_STS_SUCCESS;
1280:
1281: l_progress := '050';
1282:
1283: IF g_debug_stmt THEN

Line 1304: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

1300: );
1301:
1302: l_progress := '100';
1303:
1304: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1305: OR x_return_status IS NULL
1306: ) THEN
1307: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1308: END IF;

Line 1307: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1303:
1304: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1305: OR x_return_status IS NULL
1306: ) THEN
1307: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1308: END IF;
1309:
1310: l_progress := '110';
1311:

Line 1328: IF ( l_report_return_status = FND_API.G_RET_STS_UNEXP_ERROR

1324: );
1325:
1326: l_progress := '200';
1327:
1328: IF ( l_report_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1329: OR l_report_return_status IS NULL
1330: ) THEN
1331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1332: END IF;

Line 1331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1327:
1328: IF ( l_report_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1329: OR l_report_return_status IS NULL
1330: ) THEN
1331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1332: END IF;
1333:
1334: l_progress := '300';
1335:

Line 1337: IF FND_API.To_Boolean(p_commit) THEN

1333:
1334: l_progress := '300';
1335:
1336: -- Standard check of p_commit.
1337: IF FND_API.To_Boolean(p_commit) THEN
1338: COMMIT WORK;
1339: END IF;
1340:
1341: l_progress := '900';

Line 1355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1351: EXCEPTION
1352: WHEN OTHERS THEN
1353: BEGIN
1354: PO_DEBUG.debug_unexp(l_log_head,l_progress,'OTHERS Start');
1355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1356: IF g_debug_stmt THEN
1357: PO_DEBUG.debug_var(l_log_head,l_progress,'l_report_return_status',l_report_return_status);
1358: PO_DEBUG.debug_var(l_log_head,l_progress,'l_online_report_id',l_online_report_id);
1359: PO_DEBUG.debug_var(l_log_head,l_progress,'x_return_status',x_return_status);

Line 1429: -- FND_API.G_RET_STS_SUCCESS if validation succeeds

1425: -- distributions for which encumbrance actions were successful. Information for
1426: -- distributions with Warnings and Errors are always included.
1427: --OUT:
1428: --x_return_status
1429: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
1430: -- FND_API.G_RET_STS_ERROR if validation fails
1431: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
1432: --x_detailed_results
1433: -- Object table that stores distribution specific

Line 1430: -- FND_API.G_RET_STS_ERROR if validation fails

1426: -- distributions with Warnings and Errors are always included.
1427: --OUT:
1428: --x_return_status
1429: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
1430: -- FND_API.G_RET_STS_ERROR if validation fails
1431: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
1432: --x_detailed_results
1433: -- Object table that stores distribution specific
1434: -- reporting information for the encumbrance transaction

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

1427: --OUT:
1428: --x_return_status
1429: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
1430: -- FND_API.G_RET_STS_ERROR if validation fails
1431: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
1432: --x_detailed_results
1433: -- Object table that stores distribution specific
1434: -- reporting information for the encumbrance transaction
1435: --x_po_return_code

Line 1444: , p_commit IN VARCHAR2 default FND_API.G_FALSE

1440: --End of Comments
1441: -------------------------------------------------------------------------------
1442: PROCEDURE do_reject(
1443: p_api_version IN NUMBER
1444: , p_commit IN VARCHAR2 default FND_API.G_FALSE
1445: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
1446: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
1447: , x_return_status OUT NOCOPY VARCHAR2
1448: , p_doc_type IN VARCHAR2

Line 1445: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE

1441: -------------------------------------------------------------------------------
1442: PROCEDURE do_reject(
1443: p_api_version IN NUMBER
1444: , p_commit IN VARCHAR2 default FND_API.G_FALSE
1445: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
1446: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
1447: , x_return_status OUT NOCOPY VARCHAR2
1448: , p_doc_type IN VARCHAR2
1449: , p_doc_subtype IN VARCHAR2

Line 1446: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL

1442: PROCEDURE do_reject(
1443: p_api_version IN NUMBER
1444: , p_commit IN VARCHAR2 default FND_API.G_FALSE
1445: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
1446: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
1447: , x_return_status OUT NOCOPY VARCHAR2
1448: , p_doc_type IN VARCHAR2
1449: , p_doc_subtype IN VARCHAR2
1450: , p_doc_level IN VARCHAR2

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

1491: l_progress := '020';
1492:
1493: -- Standard call to check for call compatibility
1494:
1495: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1496: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1497: END IF;
1498:
1499: l_progress := '030';

Line 1496: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1492:
1493: -- Standard call to check for call compatibility
1494:
1495: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1496: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1497: END IF;
1498:
1499: l_progress := '030';
1500:

Line 1503: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1499: l_progress := '030';
1500:
1501: -- Initialize message list if p_init_msg_list is set to TRUE.
1502:
1503: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1504: FND_MSG_PUB.initialize;
1505: END IF;
1506:
1507: l_progress := '040';

Line 1511: x_return_status := FND_API.G_RET_STS_SUCCESS;

1507: l_progress := '040';
1508:
1509: -- Initialize API return status to success
1510:
1511: x_return_status := FND_API.G_RET_STS_SUCCESS;
1512:
1513: l_progress := '050';
1514:
1515: IF g_debug_stmt THEN

Line 1537: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

1533: );
1534:
1535: l_progress := '100';
1536:
1537: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1538: OR x_return_status IS NULL
1539: ) THEN
1540: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1541: END IF;

Line 1540: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1536:
1537: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1538: OR x_return_status IS NULL
1539: ) THEN
1540: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1541: END IF;
1542:
1543: l_progress := '110';
1544:

Line 1561: IF ( l_report_return_status = FND_API.G_RET_STS_UNEXP_ERROR

1557: );
1558:
1559: l_progress := '200';
1560:
1561: IF ( l_report_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1562: OR l_report_return_status IS NULL
1563: ) THEN
1564: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1565: END IF;

Line 1564: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1560:
1561: IF ( l_report_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1562: OR l_report_return_status IS NULL
1563: ) THEN
1564: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1565: END IF;
1566:
1567: l_progress := '300';
1568:

Line 1570: IF FND_API.To_Boolean(p_commit) THEN

1566:
1567: l_progress := '300';
1568:
1569: -- Standard check of p_commit.
1570: IF FND_API.To_Boolean(p_commit) THEN
1571: COMMIT WORK;
1572: END IF;
1573:
1574: l_progress := '900';

Line 1588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1584: EXCEPTION
1585: WHEN OTHERS THEN
1586: BEGIN
1587: PO_DEBUG.debug_unexp(l_log_head,l_progress,'OTHERS Start');
1588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1589: IF g_debug_stmt THEN
1590: PO_DEBUG.debug_var(l_log_head,l_progress,'l_report_return_status',l_report_return_status);
1591: PO_DEBUG.debug_var(l_log_head,l_progress,'l_online_report_id',l_online_report_id);
1592: PO_DEBUG.debug_var(l_log_head,l_progress,'x_return_status',x_return_status);

Line 1665: -- FND_API.G_RET_STS_SUCCESS if validation succeeds

1661: -- distributions for which encumbrance actions were successful. Information for
1662: -- distributions with Warnings and Errors are always included.
1663: --OUT:
1664: --x_return_status
1665: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
1666: -- FND_API.G_RET_STS_ERROR if validation fails
1667: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
1668: --x_detailed_results
1669: -- Object table that stores distribution specific

Line 1666: -- FND_API.G_RET_STS_ERROR if validation fails

1662: -- distributions with Warnings and Errors are always included.
1663: --OUT:
1664: --x_return_status
1665: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
1666: -- FND_API.G_RET_STS_ERROR if validation fails
1667: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
1668: --x_detailed_results
1669: -- Object table that stores distribution specific
1670: -- reporting information for the encumbrance transaction

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

1663: --OUT:
1664: --x_return_status
1665: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
1666: -- FND_API.G_RET_STS_ERROR if validation fails
1667: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
1668: --x_detailed_results
1669: -- Object table that stores distribution specific
1670: -- reporting information for the encumbrance transaction
1671: --x_po_return_code

Line 1680: , p_commit IN VARCHAR2 default FND_API.G_FALSE

1676: --End of Comments
1677: -------------------------------------------------------------------------------
1678: PROCEDURE do_cancel(
1679: p_api_version IN NUMBER
1680: , p_commit IN VARCHAR2 default FND_API.G_FALSE
1681: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
1682: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
1683: , x_return_status OUT NOCOPY VARCHAR2
1684: , p_doc_type IN VARCHAR2

Line 1681: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE

1677: -------------------------------------------------------------------------------
1678: PROCEDURE do_cancel(
1679: p_api_version IN NUMBER
1680: , p_commit IN VARCHAR2 default FND_API.G_FALSE
1681: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
1682: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
1683: , x_return_status OUT NOCOPY VARCHAR2
1684: , p_doc_type IN VARCHAR2
1685: , p_doc_subtype IN VARCHAR2

Line 1682: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL

1678: PROCEDURE do_cancel(
1679: p_api_version IN NUMBER
1680: , p_commit IN VARCHAR2 default FND_API.G_FALSE
1681: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
1682: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
1683: , x_return_status OUT NOCOPY VARCHAR2
1684: , p_doc_type IN VARCHAR2
1685: , p_doc_subtype IN VARCHAR2
1686: , p_doc_level IN VARCHAR2

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

1727: l_progress := '020';
1728:
1729: -- Standard call to check for call compatibility
1730:
1731: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1732: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1733: END IF;
1734:
1735: l_progress := '030';

Line 1732: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1728:
1729: -- Standard call to check for call compatibility
1730:
1731: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1732: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1733: END IF;
1734:
1735: l_progress := '030';
1736:

Line 1739: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1735: l_progress := '030';
1736:
1737: -- Initialize message list if p_init_msg_list is set to TRUE.
1738:
1739: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1740: FND_MSG_PUB.initialize;
1741: END IF;
1742:
1743: l_progress := '040';

Line 1747: x_return_status := FND_API.G_RET_STS_SUCCESS;

1743: l_progress := '040';
1744:
1745: -- Initialize API return status to success
1746:
1747: x_return_status := FND_API.G_RET_STS_SUCCESS;
1748:
1749: l_progress := '050';
1750:
1751: IF g_debug_stmt THEN

Line 1773: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

1769: );
1770:
1771: l_progress := '100';
1772:
1773: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1774: OR x_return_status IS NULL
1775: ) THEN
1776: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1777: END IF;

Line 1776: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1772:
1773: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1774: OR x_return_status IS NULL
1775: ) THEN
1776: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1777: END IF;
1778:
1779: l_progress := '110';
1780:

Line 1797: IF ( l_report_return_status = FND_API.G_RET_STS_UNEXP_ERROR

1793: );
1794:
1795: l_progress := '200';
1796:
1797: IF ( l_report_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1798: OR l_report_return_status IS NULL
1799: ) THEN
1800: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1801: END IF;

Line 1800: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1796:
1797: IF ( l_report_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1798: OR l_report_return_status IS NULL
1799: ) THEN
1800: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1801: END IF;
1802:
1803: l_progress := '300';
1804:

Line 1806: IF FND_API.To_Boolean(p_commit) THEN

1802:
1803: l_progress := '300';
1804:
1805: -- Standard check of p_commit.
1806: IF FND_API.To_Boolean(p_commit) THEN
1807: COMMIT WORK;
1808: END IF;
1809:
1810: l_progress := '900';

Line 1824: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1820: EXCEPTION
1821: WHEN OTHERS THEN
1822: BEGIN
1823: PO_DEBUG.debug_unexp(l_log_head,l_progress,'OTHERS Start');
1824: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1825: IF g_debug_stmt THEN
1826: PO_DEBUG.debug_var(l_log_head,l_progress,'l_report_return_status',l_report_return_status);
1827: PO_DEBUG.debug_var(l_log_head,l_progress,'l_online_report_id',l_online_report_id);
1828: PO_DEBUG.debug_var(l_log_head,l_progress,'x_return_status',x_return_status);

Line 1895: -- FND_API.G_RET_STS_SUCCESS if validation succeeds

1891: -- distributions for which encumbrance actions were successful. Information for
1892: -- distributions with Warnings and Errors are always included.
1893: --OUT:
1894: --x_return_status
1895: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
1896: -- FND_API.G_RET_STS_ERROR if validation fails
1897: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
1898: --x_detailed_results
1899: -- Object table that stores distribution specific

Line 1896: -- FND_API.G_RET_STS_ERROR if validation fails

1892: -- distributions with Warnings and Errors are always included.
1893: --OUT:
1894: --x_return_status
1895: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
1896: -- FND_API.G_RET_STS_ERROR if validation fails
1897: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
1898: --x_detailed_results
1899: -- Object table that stores distribution specific
1900: -- reporting information for the encumbrance transaction

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

1893: --OUT:
1894: --x_return_status
1895: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
1896: -- FND_API.G_RET_STS_ERROR if validation fails
1897: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
1898: --x_detailed_results
1899: -- Object table that stores distribution specific
1900: -- reporting information for the encumbrance transaction
1901: --x_po_return_code

Line 1910: , p_commit IN VARCHAR2 default FND_API.G_FALSE

1906: --End of Comments
1907: -------------------------------------------------------------------------------
1908: PROCEDURE do_adjust(
1909: p_api_version IN NUMBER
1910: , p_commit IN VARCHAR2 default FND_API.G_FALSE
1911: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
1912: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
1913: , x_return_status OUT NOCOPY VARCHAR2
1914: , p_doc_type IN VARCHAR2

Line 1911: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE

1907: -------------------------------------------------------------------------------
1908: PROCEDURE do_adjust(
1909: p_api_version IN NUMBER
1910: , p_commit IN VARCHAR2 default FND_API.G_FALSE
1911: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
1912: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
1913: , x_return_status OUT NOCOPY VARCHAR2
1914: , p_doc_type IN VARCHAR2
1915: , p_doc_subtype IN VARCHAR2

Line 1912: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL

1908: PROCEDURE do_adjust(
1909: p_api_version IN NUMBER
1910: , p_commit IN VARCHAR2 default FND_API.G_FALSE
1911: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
1912: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
1913: , x_return_status OUT NOCOPY VARCHAR2
1914: , p_doc_type IN VARCHAR2
1915: , p_doc_subtype IN VARCHAR2
1916: , p_employee_id IN NUMBER

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

1955: l_progress := '020';
1956:
1957: -- Standard call to check for call compatibility
1958:
1959: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1960: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1961: END IF;
1962:
1963: l_progress := '030';

Line 1960: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1956:
1957: -- Standard call to check for call compatibility
1958:
1959: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1960: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1961: END IF;
1962:
1963: l_progress := '030';
1964:

Line 1967: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1963: l_progress := '030';
1964:
1965: -- Initialize message list if p_init_msg_list is set to TRUE.
1966:
1967: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1968: FND_MSG_PUB.initialize;
1969: END IF;
1970:
1971: l_progress := '040';

Line 1975: x_return_status := FND_API.G_RET_STS_SUCCESS;

1971: l_progress := '040';
1972:
1973: -- Initialize API return status to success
1974:
1975: x_return_status := FND_API.G_RET_STS_SUCCESS;
1976:
1977: l_progress := '050';
1978:
1979: IF g_debug_stmt THEN

Line 2000: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

1996: );
1997:
1998: l_progress := '100';
1999:
2000: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2001: OR x_return_status IS NULL
2002: ) THEN
2003: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2004: END IF;

Line 2003: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1999:
2000: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2001: OR x_return_status IS NULL
2002: ) THEN
2003: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2004: END IF;
2005:
2006: l_progress := '110';
2007:

Line 2024: IF ( l_report_return_status = FND_API.G_RET_STS_UNEXP_ERROR

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

Line 2027: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2023:
2024: IF ( l_report_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2025: OR l_report_return_status IS NULL
2026: ) THEN
2027: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2028: END IF;
2029:
2030: l_progress := '300';
2031:

Line 2033: IF FND_API.To_Boolean(p_commit) THEN

2029:
2030: l_progress := '300';
2031:
2032: -- Standard check of p_commit.
2033: IF FND_API.To_Boolean(p_commit) THEN
2034: COMMIT WORK;
2035: END IF;
2036:
2037: l_progress := '900';

Line 2051: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2047: EXCEPTION
2048: WHEN OTHERS THEN
2049: BEGIN
2050: PO_DEBUG.debug_unexp(l_log_head,l_progress,'OTHERS Start');
2051: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2052: IF g_debug_stmt THEN
2053: PO_DEBUG.debug_var(l_log_head,l_progress,'l_report_return_status',l_report_return_status);
2054: PO_DEBUG.debug_var(l_log_head,l_progress,'l_online_report_id',l_online_report_id);
2055: PO_DEBUG.debug_var(l_log_head,l_progress,'x_return_status',x_return_status);

Line 2122: -- FND_API.G_RET_STS_SUCCESS if validation succeeds

2118: -- distributions for which encumbrance actions were successful. Information for
2119: -- distributions with Warnings and Errors are always included.
2120: --OUT:
2121: --x_return_status
2122: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
2123: -- FND_API.G_RET_STS_ERROR if validation fails
2124: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
2125: --x_detailed_results
2126: -- Object table that stores distribution specific

Line 2123: -- FND_API.G_RET_STS_ERROR if validation fails

2119: -- distributions with Warnings and Errors are always included.
2120: --OUT:
2121: --x_return_status
2122: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
2123: -- FND_API.G_RET_STS_ERROR if validation fails
2124: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
2125: --x_detailed_results
2126: -- Object table that stores distribution specific
2127: -- reporting information for the encumbrance transaction

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

2120: --OUT:
2121: --x_return_status
2122: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
2123: -- FND_API.G_RET_STS_ERROR if validation fails
2124: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
2125: --x_detailed_results
2126: -- Object table that stores distribution specific
2127: -- reporting information for the encumbrance transaction
2128: --x_po_return_code

Line 2137: , p_commit IN VARCHAR2 default FND_API.G_FALSE

2133: --End of Comments
2134: -------------------------------------------------------------------------------
2135: PROCEDURE do_final_close(
2136: p_api_version IN NUMBER
2137: , p_commit IN VARCHAR2 default FND_API.G_FALSE
2138: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
2139: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
2140: , x_return_status OUT NOCOPY VARCHAR2
2141: , p_doc_type IN VARCHAR2

Line 2138: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE

2134: -------------------------------------------------------------------------------
2135: PROCEDURE do_final_close(
2136: p_api_version IN NUMBER
2137: , p_commit IN VARCHAR2 default FND_API.G_FALSE
2138: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
2139: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
2140: , x_return_status OUT NOCOPY VARCHAR2
2141: , p_doc_type IN VARCHAR2
2142: , p_doc_subtype IN VARCHAR2

Line 2139: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL

2135: PROCEDURE do_final_close(
2136: p_api_version IN NUMBER
2137: , p_commit IN VARCHAR2 default FND_API.G_FALSE
2138: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
2139: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
2140: , x_return_status OUT NOCOPY VARCHAR2
2141: , p_doc_type IN VARCHAR2
2142: , p_doc_subtype IN VARCHAR2
2143: , p_doc_level IN VARCHAR2

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

2182: l_progress := '020';
2183:
2184: -- Standard call to check for call compatibility
2185:
2186: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2188: END IF;
2189:
2190: l_progress := '030';

Line 2187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2183:
2184: -- Standard call to check for call compatibility
2185:
2186: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2188: END IF;
2189:
2190: l_progress := '030';
2191:

Line 2194: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2190: l_progress := '030';
2191:
2192: -- Initialize message list if p_init_msg_list is set to TRUE.
2193:
2194: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2195: FND_MSG_PUB.initialize;
2196: END IF;
2197:
2198: l_progress := '040';

Line 2202: x_return_status := FND_API.G_RET_STS_SUCCESS;

2198: l_progress := '040';
2199:
2200: -- Initialize API return status to success
2201:
2202: x_return_status := FND_API.G_RET_STS_SUCCESS;
2203:
2204: l_progress := '050';
2205:
2206: IF g_debug_stmt THEN

Line 2227: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

2223: );
2224:
2225: l_progress := '100';
2226:
2227: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2228: OR x_return_status IS NULL
2229: ) THEN
2230: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2231: END IF;

Line 2230: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2226:
2227: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2228: OR x_return_status IS NULL
2229: ) THEN
2230: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2231: END IF;
2232:
2233: l_progress := '110';
2234:

Line 2251: IF ( l_report_return_status = FND_API.G_RET_STS_UNEXP_ERROR

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

Line 2254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2250:
2251: IF ( l_report_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2252: OR l_report_return_status IS NULL
2253: ) THEN
2254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2255: END IF;
2256:
2257: l_progress := '300';
2258:

Line 2260: IF FND_API.To_Boolean(p_commit) THEN

2256:
2257: l_progress := '300';
2258:
2259: -- Standard check of p_commit.
2260: IF FND_API.To_Boolean(p_commit) THEN
2261: COMMIT WORK;
2262: END IF;
2263:
2264: l_progress := '900';

Line 2278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2274: EXCEPTION
2275: WHEN OTHERS THEN
2276: BEGIN
2277: PO_DEBUG.debug_unexp(l_log_head,l_progress,'OTHERS Start');
2278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2279: IF g_debug_stmt THEN
2280: PO_DEBUG.debug_var(l_log_head,l_progress,'l_report_return_status',l_report_return_status);
2281: PO_DEBUG.debug_var(l_log_head,l_progress,'l_online_report_id',l_online_report_id);
2282: PO_DEBUG.debug_var(l_log_head,l_progress,'x_return_status',x_return_status);

Line 2360: -- FND_API.G_RET_STS_SUCCESS if validation succeeds

2356: --OUT:
2357: --x_packet_id
2358: -- GL PACKET ID, if gl entries are made otherwise null
2359: --x_return_status
2360: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
2361: -- FND_API.G_RET_STS_ERROR if validation fails
2362: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
2363: --Testing:
2364: --

Line 2361: -- FND_API.G_RET_STS_ERROR if validation fails

2357: --x_packet_id
2358: -- GL PACKET ID, if gl entries are made otherwise null
2359: --x_return_status
2360: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
2361: -- FND_API.G_RET_STS_ERROR if validation fails
2362: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
2363: --Testing:
2364: --
2365: --End of Comments

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

2358: -- GL PACKET ID, if gl entries are made otherwise null
2359: --x_return_status
2360: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
2361: -- FND_API.G_RET_STS_ERROR if validation fails
2362: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
2363: --Testing:
2364: --
2365: --End of Comments
2366: -------------------------------------------------------------------------------

Line 2369: p_commit IN VARCHAR2 default FND_API.G_FALSE,

2365: --End of Comments
2366: -------------------------------------------------------------------------------
2367: PROCEDURE reinstate_po_encumbrance(
2368: p_api_version IN NUMBER,
2369: p_commit IN VARCHAR2 default FND_API.G_FALSE,
2370: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
2371: p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL,
2372: p_distribution_id IN NUMBER,
2373: p_invoice_id IN NUMBER,

Line 2370: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,

2366: -------------------------------------------------------------------------------
2367: PROCEDURE reinstate_po_encumbrance(
2368: p_api_version IN NUMBER,
2369: p_commit IN VARCHAR2 default FND_API.G_FALSE,
2370: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
2371: p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL,
2372: p_distribution_id IN NUMBER,
2373: p_invoice_id IN NUMBER,
2374: p_encumbrance_amt IN NUMBER,

Line 2371: p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL,

2367: PROCEDURE reinstate_po_encumbrance(
2368: p_api_version IN NUMBER,
2369: p_commit IN VARCHAR2 default FND_API.G_FALSE,
2370: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
2371: p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL,
2372: p_distribution_id IN NUMBER,
2373: p_invoice_id IN NUMBER,
2374: p_encumbrance_amt IN NUMBER,
2375: p_qty_cancelled IN NUMBER,

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

2422: l_progress := '020';
2423:
2424: -- Standard call to check for call compatibility
2425:
2426: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2427: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2428: END IF;
2429:
2430: l_progress := '030';

Line 2427: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2423:
2424: -- Standard call to check for call compatibility
2425:
2426: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2427: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2428: END IF;
2429:
2430: l_progress := '030';
2431:

Line 2434: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2430: l_progress := '030';
2431:
2432: -- Initialize message list if p_init_msg_list is set to TRUE.
2433:
2434: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2435: FND_MSG_PUB.initialize;
2436: END IF;
2437:
2438: l_progress := '040';

Line 2442: x_return_status := FND_API.G_RET_STS_SUCCESS;

2438: l_progress := '040';
2439:
2440: -- Initialize API return status to success
2441:
2442: x_return_status := FND_API.G_RET_STS_SUCCESS;
2443:
2444: l_progress := '050';
2445:
2446: IF g_debug_stmt THEN

Line 2470: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

2466: );
2467:
2468: l_progress := '100';
2469:
2470: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2471: OR x_return_status IS NULL
2472: ) THEN
2473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2474: END IF;

Line 2473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2469:
2470: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2471: OR x_return_status IS NULL
2472: ) THEN
2473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2474: END IF;
2475:
2476: l_progress := '110';
2477:

Line 2486: IF FND_API.To_Boolean(p_commit) THEN

2482:
2483: l_progress := '200';
2484:
2485: -- Standard check of p_commit.
2486: IF FND_API.To_Boolean(p_commit) THEN
2487: COMMIT WORK;
2488: END IF;
2489:
2490: l_progress := '900';

Line 2502: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2498: EXCEPTION
2499: WHEN OTHERS THEN
2500: BEGIN
2501: PO_DEBUG.debug_unexp(l_log_head,l_progress,'OTHERS Start');
2502: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2503: IF g_debug_stmt THEN
2504: PO_DEBUG.debug_var(l_log_head,l_progress,'x_return_status',x_return_status);
2505: PO_DEBUG.debug_var(l_log_head,l_progress,'x_packet_id',x_packet_id);
2506: END IF;

Line 2549: -- FND_API.G_RET_STS_SUCCESS if validation succeeds

2545: -- A table of po_header_ids corresponding to the PAs that we are checking
2546: -- the encumbered state of.
2547: --OUT:
2548: --x_return_status
2549: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
2550: -- FND_API.G_RET_STS_ERROR if validation fails
2551: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
2552: --x_results_tbl
2553: -- A table of Y/N results indicating whether each PA is encumbered or not.

Line 2550: -- FND_API.G_RET_STS_ERROR if validation fails

2546: -- the encumbered state of.
2547: --OUT:
2548: --x_return_status
2549: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
2550: -- FND_API.G_RET_STS_ERROR if validation fails
2551: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
2552: --x_results_tbl
2553: -- A table of Y/N results indicating whether each PA is encumbered or not.
2554: -- Y = the given PA is/can be encumbered.

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

2547: --OUT:
2548: --x_return_status
2549: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
2550: -- FND_API.G_RET_STS_ERROR if validation fails
2551: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
2552: --x_results_tbl
2553: -- A table of Y/N results indicating whether each PA is encumbered or not.
2554: -- Y = the given PA is/can be encumbered.
2555: -- N = the PA is not eligible for encumbrance

Line 2562: , p_commit IN VARCHAR2 default FND_API.G_FALSE

2558: --End of Comments
2559: -------------------------------------------------------------------------------
2560: PROCEDURE is_agreement_encumbered(
2561: p_api_version IN NUMBER
2562: , p_commit IN VARCHAR2 default FND_API.G_FALSE
2563: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
2564: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
2565: , x_return_status OUT NOCOPY VARCHAR2
2566: , p_agreement_id_tbl IN PO_TBL_NUMBER

Line 2563: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE

2559: -------------------------------------------------------------------------------
2560: PROCEDURE is_agreement_encumbered(
2561: p_api_version IN NUMBER
2562: , p_commit IN VARCHAR2 default FND_API.G_FALSE
2563: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
2564: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
2565: , x_return_status OUT NOCOPY VARCHAR2
2566: , p_agreement_id_tbl IN PO_TBL_NUMBER
2567: , x_agreement_encumbered_tbl OUT NOCOPY PO_TBL_VARCHAR1

Line 2564: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL

2560: PROCEDURE is_agreement_encumbered(
2561: p_api_version IN NUMBER
2562: , p_commit IN VARCHAR2 default FND_API.G_FALSE
2563: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
2564: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
2565: , x_return_status OUT NOCOPY VARCHAR2
2566: , p_agreement_id_tbl IN PO_TBL_NUMBER
2567: , x_agreement_encumbered_tbl OUT NOCOPY PO_TBL_VARCHAR1
2568: )

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

2592: l_progress := '020';
2593:
2594: -- Standard call to check for call compatibility
2595:
2596: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2598: END IF;
2599:
2600: l_progress := '030';

Line 2597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2593:
2594: -- Standard call to check for call compatibility
2595:
2596: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2598: END IF;
2599:
2600: l_progress := '030';
2601:

Line 2604: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2600: l_progress := '030';
2601:
2602: -- Initialize message list if p_init_msg_list is set to TRUE.
2603:
2604: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2605: FND_MSG_PUB.initialize;
2606: END IF;
2607:
2608: l_progress := '040';

Line 2612: x_return_status := FND_API.G_RET_STS_SUCCESS;

2608: l_progress := '040';
2609:
2610: -- Initialize API return status to success
2611:
2612: x_return_status := FND_API.G_RET_STS_SUCCESS;
2613:
2614: l_progress := '050';
2615:
2616: IF g_debug_stmt THEN

Line 2630: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

2626: );
2627:
2628: l_progress := '100';
2629:
2630: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2631: OR x_return_status IS NULL
2632: ) THEN
2633: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2634: END IF;

Line 2633: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2629:
2630: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2631: OR x_return_status IS NULL
2632: ) THEN
2633: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2634: END IF;
2635:
2636: l_progress := '110';
2637:

Line 2646: IF FND_API.To_Boolean(p_commit) THEN

2642:
2643: l_progress := '200';
2644:
2645: -- Standard check of p_commit.
2646: IF FND_API.To_Boolean(p_commit) THEN
2647: COMMIT WORK;
2648: END IF;
2649:
2650: l_progress := '900';

Line 2662: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2658: EXCEPTION
2659: WHEN OTHERS THEN
2660: BEGIN
2661: PO_DEBUG.debug_unexp(l_log_head,l_progress,'OTHERS Start');
2662: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2663: IF g_debug_stmt THEN
2664: PO_DEBUG.debug_var(l_log_head,l_progress,'x_return_status',x_return_status);
2665: PO_DEBUG.debug_var(l_log_head,l_progress,'x_agreement_encumbered_tbl',x_agreement_encumbered_tbl);
2666: END IF;

Line 2720: -- FND_API.G_RET_STS_SUCCESS if validation succeeds

2716: -- The id corresponding to the doc level type:
2717: -- header_id/release_id, line_id, line_location_id, distribution_id
2718: --OUT:
2719: --x_return_status
2720: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
2721: -- FND_API.G_RET_STS_ERROR if validation fails
2722: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
2723: --x_result
2724: -- Indicates whether funds reservation is possible on this entity

Line 2721: -- FND_API.G_RET_STS_ERROR if validation fails

2717: -- header_id/release_id, line_id, line_location_id, distribution_id
2718: --OUT:
2719: --x_return_status
2720: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
2721: -- FND_API.G_RET_STS_ERROR if validation fails
2722: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
2723: --x_result
2724: -- Indicates whether funds reservation is possible on this entity
2725: -- 'Y' means it is possible, 'N' means it isn't.

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

2718: --OUT:
2719: --x_return_status
2720: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
2721: -- FND_API.G_RET_STS_ERROR if validation fails
2722: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
2723: --x_result
2724: -- Indicates whether funds reservation is possible on this entity
2725: -- 'Y' means it is possible, 'N' means it isn't.
2726: --Testing:

Line 2732: , p_commit IN VARCHAR2 default FND_API.G_FALSE

2728: --End of Comments
2729: -------------------------------------------------------------------------------
2730: PROCEDURE is_reservable(
2731: p_api_version IN NUMBER
2732: , p_commit IN VARCHAR2 default FND_API.G_FALSE
2733: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
2734: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
2735: , x_return_status OUT NOCOPY VARCHAR2
2736: , p_doc_type IN VARCHAR2

Line 2733: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE

2729: -------------------------------------------------------------------------------
2730: PROCEDURE is_reservable(
2731: p_api_version IN NUMBER
2732: , p_commit IN VARCHAR2 default FND_API.G_FALSE
2733: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
2734: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
2735: , x_return_status OUT NOCOPY VARCHAR2
2736: , p_doc_type IN VARCHAR2
2737: , p_doc_subtype IN VARCHAR2

Line 2734: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL

2730: PROCEDURE is_reservable(
2731: p_api_version IN NUMBER
2732: , p_commit IN VARCHAR2 default FND_API.G_FALSE
2733: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
2734: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
2735: , x_return_status OUT NOCOPY VARCHAR2
2736: , p_doc_type IN VARCHAR2
2737: , p_doc_subtype IN VARCHAR2
2738: , p_doc_level IN VARCHAR2

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

2768: l_progress := '020';
2769:
2770: -- Standard call to check for call compatibility
2771:
2772: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2773: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2774: END IF;
2775:
2776: l_progress := '030';

Line 2773: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2769:
2770: -- Standard call to check for call compatibility
2771:
2772: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2773: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2774: END IF;
2775:
2776: l_progress := '030';
2777:

Line 2780: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2776: l_progress := '030';
2777:
2778: -- Initialize message list if p_init_msg_list is set to TRUE.
2779:
2780: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2781: FND_MSG_PUB.initialize;
2782: END IF;
2783:
2784: l_progress := '040';

Line 2788: x_return_status := FND_API.G_RET_STS_SUCCESS;

2784: l_progress := '040';
2785:
2786: -- Initialize API return status to success
2787:
2788: x_return_status := FND_API.G_RET_STS_SUCCESS;
2789:
2790: l_progress := '050';
2791:
2792: IF g_debug_stmt THEN

Line 2809: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

2805: );
2806:
2807: l_progress := '100';
2808:
2809: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2810: OR x_return_status IS NULL
2811: ) THEN
2812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2813: END IF;

Line 2812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2808:
2809: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2810: OR x_return_status IS NULL
2811: ) THEN
2812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2813: END IF;
2814:
2815: l_progress := '110';
2816:

Line 2825: IF FND_API.To_Boolean(p_commit) THEN

2821:
2822: l_progress := '200';
2823:
2824: -- Standard check of p_commit.
2825: IF FND_API.To_Boolean(p_commit) THEN
2826: COMMIT WORK;
2827: END IF;
2828:
2829: l_progress := '900';

Line 2841: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2837: EXCEPTION
2838: WHEN OTHERS THEN
2839: BEGIN
2840: PO_DEBUG.debug_unexp(l_log_head,l_progress,'OTHERS Start');
2841: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2842: IF g_debug_stmt THEN
2843: PO_DEBUG.debug_var(l_log_head,l_progress,'x_return_status',x_return_status);
2844: PO_DEBUG.debug_var(l_log_head,l_progress,'x_reservable_flag',x_reservable_flag);
2845: END IF;

Line 2899: -- FND_API.G_RET_STS_SUCCESS if validation succeeds

2895: -- The id corresponding to the doc level type:
2896: -- header_id/release_id, line_id, line_location_id, distribution_id
2897: --OUT:
2898: --x_return_status
2899: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
2900: -- FND_API.G_RET_STS_ERROR if validation fails
2901: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
2902: --x_result
2903: -- Indicates whether funds reservation is possible on this entity

Line 2900: -- FND_API.G_RET_STS_ERROR if validation fails

2896: -- header_id/release_id, line_id, line_location_id, distribution_id
2897: --OUT:
2898: --x_return_status
2899: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
2900: -- FND_API.G_RET_STS_ERROR if validation fails
2901: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
2902: --x_result
2903: -- Indicates whether funds reservation is possible on this entity
2904: -- 'Y' means it is possible, 'N' means it isn't.

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

2897: --OUT:
2898: --x_return_status
2899: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
2900: -- FND_API.G_RET_STS_ERROR if validation fails
2901: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
2902: --x_result
2903: -- Indicates whether funds reservation is possible on this entity
2904: -- 'Y' means it is possible, 'N' means it isn't.
2905: --Testing:

Line 2911: , p_commit IN VARCHAR2 default FND_API.G_FALSE

2907: --End of Comments
2908: -------------------------------------------------------------------------------
2909: PROCEDURE is_unreservable(
2910: p_api_version IN NUMBER
2911: , p_commit IN VARCHAR2 default FND_API.G_FALSE
2912: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
2913: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
2914: , x_return_status OUT NOCOPY VARCHAR2
2915: , p_doc_type IN VARCHAR2

Line 2912: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE

2908: -------------------------------------------------------------------------------
2909: PROCEDURE is_unreservable(
2910: p_api_version IN NUMBER
2911: , p_commit IN VARCHAR2 default FND_API.G_FALSE
2912: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
2913: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
2914: , x_return_status OUT NOCOPY VARCHAR2
2915: , p_doc_type IN VARCHAR2
2916: , p_doc_subtype IN VARCHAR2

Line 2913: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL

2909: PROCEDURE is_unreservable(
2910: p_api_version IN NUMBER
2911: , p_commit IN VARCHAR2 default FND_API.G_FALSE
2912: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
2913: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
2914: , x_return_status OUT NOCOPY VARCHAR2
2915: , p_doc_type IN VARCHAR2
2916: , p_doc_subtype IN VARCHAR2
2917: , p_doc_level IN VARCHAR2

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

2947: l_progress := '020';
2948:
2949: -- Standard call to check for call compatibility
2950:
2951: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2952: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2953: END IF;
2954:
2955: l_progress := '030';

Line 2952: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2948:
2949: -- Standard call to check for call compatibility
2950:
2951: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2952: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2953: END IF;
2954:
2955: l_progress := '030';
2956:

Line 2959: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2955: l_progress := '030';
2956:
2957: -- Initialize message list if p_init_msg_list is set to TRUE.
2958:
2959: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2960: FND_MSG_PUB.initialize;
2961: END IF;
2962:
2963: l_progress := '040';

Line 2967: x_return_status := FND_API.G_RET_STS_SUCCESS;

2963: l_progress := '040';
2964:
2965: -- Initialize API return status to success
2966:
2967: x_return_status := FND_API.G_RET_STS_SUCCESS;
2968:
2969: l_progress := '050';
2970:
2971: IF g_debug_stmt THEN

Line 2988: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

2984: );
2985:
2986: l_progress := '100';
2987:
2988: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2989: OR x_return_status IS NULL
2990: ) THEN
2991: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2992: END IF;

Line 2991: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2987:
2988: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2989: OR x_return_status IS NULL
2990: ) THEN
2991: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2992: END IF;
2993:
2994: l_progress := '110';
2995:

Line 3004: IF FND_API.To_Boolean(p_commit) THEN

3000:
3001: l_progress := '200';
3002:
3003: -- Standard check of p_commit.
3004: IF FND_API.To_Boolean(p_commit) THEN
3005: COMMIT WORK;
3006: END IF;
3007:
3008: l_progress := '900';

Line 3020: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3016: EXCEPTION
3017: WHEN OTHERS THEN
3018: BEGIN
3019: PO_DEBUG.debug_unexp(l_log_head,l_progress,'OTHERS Start');
3020: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3021: IF g_debug_stmt THEN
3022: PO_DEBUG.debug_var(l_log_head,l_progress,'x_return_status',x_return_status);
3023: PO_DEBUG.debug_var(l_log_head,l_progress,'x_unreservable_flag',x_unreservable_flag);
3024: END IF;

Line 3113: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE

3109: --End of Comments
3110: -------------------------------------------------------------------------------
3111: PROCEDURE populate_encumbrance_gt(
3112: p_api_version IN NUMBER
3113: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
3114: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
3115: , x_return_status OUT NOCOPY VARCHAR2
3116: , p_doc_type IN VARCHAR2
3117: , p_doc_level IN VARCHAR2

Line 3114: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL

3110: -------------------------------------------------------------------------------
3111: PROCEDURE populate_encumbrance_gt(
3112: p_api_version IN NUMBER
3113: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
3114: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
3115: , x_return_status OUT NOCOPY VARCHAR2
3116: , p_doc_type IN VARCHAR2
3117: , p_doc_level IN VARCHAR2
3118: , p_doc_level_id_tbl IN po_tbl_number

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

3152:
3153: l_progress := '020';
3154:
3155: -- Standard call to check for call compatibility
3156: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3158: END IF;
3159:
3160: l_progress := '030';

Line 3157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3153: l_progress := '020';
3154:
3155: -- Standard call to check for call compatibility
3156: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3158: END IF;
3159:
3160: l_progress := '030';
3161:

Line 3163: IF FND_API.to_Boolean( p_init_msg_list ) THEN

3159:
3160: l_progress := '030';
3161:
3162: -- Initialize message list if p_init_msg_list is set to TRUE.
3163: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3164: FND_MSG_PUB.initialize;
3165: END IF;
3166:
3167: l_progress := '040';

Line 3170: x_return_status := FND_API.G_RET_STS_SUCCESS;

3166:
3167: l_progress := '040';
3168:
3169: -- Initialize API return status to success
3170: x_return_status := FND_API.G_RET_STS_SUCCESS;
3171:
3172: l_progress := '050';
3173:
3174: -- Set up the parameters for the call to the private API.

Line 3201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3197: l_progress := '160';
3198: l_adjustment_status_tbl := po_tbl_varchar5(NULL);
3199: ELSE
3200: l_progress := '170';
3201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3202: END IF;
3203:
3204:
3205: l_progress := '200';

Line 3229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3225: EXCEPTION
3226: WHEN OTHERS THEN
3227: BEGIN
3228: PO_DEBUG.debug_unexp(l_log_head,l_progress,'OTHERS Start');
3229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3230: IF g_debug_stmt THEN
3231: PO_DEBUG.debug_var(l_log_head,l_progress,'x_return_status',x_return_status);
3232: END IF;
3233: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 3292: RAISE FND_API.g_exc_unexpected_error;

3288: PO_LOG.exc(d_module_base, d_progress, 'Unhandled exception in '
3289: ||l_module_name||' '||SQLCODE||' '||SQLERRM);
3290: PO_LOG.proc_end(d_module_base, 'PO_DOCUMENT_FUNDS_PVT.g_ONLINE_REPORT_ID', PO_DOCUMENT_FUNDS_PVT.g_ONLINE_REPORT_ID);
3291: END IF;
3292: RAISE FND_API.g_exc_unexpected_error;
3293: END;
3294:
3295: --
3296: END PO_DOCUMENT_FUNDS_GRP;