DBA Data[Home] [Help]

APPS.PO_PDOI_UTL dependencies on FND_API

Line 68: -- FND_API.G_TRUE

64: --Start of Comments
65: --Name: commit_work
66: --Function:
67: -- Issues a commit if PO_PDOI_PARAMS.g_request.commit_work is
68: -- FND_API.G_TRUE
69: --Parameters:
70: --IN:
71: --IN OUT:
72: --OUT:

Line 88: IF (PO_PDOI_PARAMS.g_request.commit_work = FND_API.G_TRUE) THEN

84: IF (PO_LOG.d_proc) THEN
85: PO_LOG.proc_begin (d_module);
86: END IF;
87:
88: IF (PO_PDOI_PARAMS.g_request.commit_work = FND_API.G_TRUE) THEN
89: COMMIT;
90: END IF;
91:
92: IF (PO_LOG.d_proc) THEN

Line 167: -- FND_API.G_TRUE if rejection should be propagated to the lower level

163: -- PO_PDOI_CONSTANTS.g_INTERFACE_HEADER_ID
164: --p_id_tbl
165: -- Table of ids
166: --p_cascade
167: -- FND_API.G_TRUE if rejection should be propagated to the lower level
168: -- FND_API.G_FALSE otherwise
169: --IN OUT:
170: --OUT:
171: --End of Comments

Line 168: -- FND_API.G_FALSE otherwise

164: --p_id_tbl
165: -- Table of ids
166: --p_cascade
167: -- FND_API.G_TRUE if rejection should be propagated to the lower level
168: -- FND_API.G_FALSE otherwise
169: --IN OUT:
170: --OUT:
171: --End of Comments
172: ------------------------------------------------------------------------

Line 205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

201: WHERE interface_header_id = p_id_tbl(i)
202: AND processing_id = PO_PDOI_PARAMS.g_processing_id;
203: ELSE
204: d_position := 30;
205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
206: END IF;
207:
208: IF (p_cascade = FND_API.G_TRUE) THEN
209: d_position := 40;

Line 208: IF (p_cascade = FND_API.G_TRUE) THEN

204: d_position := 30;
205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
206: END IF;
207:
208: IF (p_cascade = FND_API.G_TRUE) THEN
209: d_position := 40;
210: reject_lines_intf
211: ( p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_HEADER_ID
212: , p_id_tbl => p_id_tbl

Line 213: , p_cascade => FND_API.G_TRUE

209: d_position := 40;
210: reject_lines_intf
211: ( p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_HEADER_ID
212: , p_id_tbl => p_id_tbl
213: , p_cascade => FND_API.G_TRUE
214: );
215: END IF;
216:
217: set_doc_has_errors

Line 250: -- FND_API.G_TRUE if rejection should be propagated to the lower level

246: -- PO_PDOI_CONSTANTS.g_INTERFACE_LINE_ID
247: --p_id_tbl
248: -- Table of ids
249: --p_cascade
250: -- FND_API.G_TRUE if rejection should be propagated to the lower level
251: -- FND_API.G_FALSE otherwise
252: --IN OUT:
253: --OUT:
254: --End of Comments

Line 251: -- FND_API.G_FALSE otherwise

247: --p_id_tbl
248: -- Table of ids
249: --p_cascade
250: -- FND_API.G_TRUE if rejection should be propagated to the lower level
251: -- FND_API.G_FALSE otherwise
252: --IN OUT:
253: --OUT:
254: --End of Comments
255: ------------------------------------------------------------------------

Line 305: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

301: RETURNING interface_line_id, interface_header_id
302: BULK COLLECT INTO l_intf_line_id_tbl, l_intf_header_id_tbl;
303: ELSE
304:
305: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
306: END IF;
307:
308: set_doc_has_errors
309: ( p_intf_header_id_tbl => l_intf_header_id_tbl

Line 312: IF (p_cascade = FND_API.G_TRUE) THEN

308: set_doc_has_errors
309: ( p_intf_header_id_tbl => l_intf_header_id_tbl
310: );
311:
312: IF (p_cascade = FND_API.G_TRUE) THEN
313: d_position := 40;
314: reject_line_locations_intf
315: ( p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_LINE_ID
316: , p_id_tbl => l_intf_line_id_tbl

Line 317: , p_cascade => FND_API.G_TRUE);

313: d_position := 40;
314: reject_line_locations_intf
315: ( p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_LINE_ID
316: , p_id_tbl => l_intf_line_id_tbl
317: , p_cascade => FND_API.G_TRUE);
318:
319: d_position := 50;
320: reject_price_diff_intf
321: ( p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_LINE_ID

Line 368: -- FND_API.G_TRUE if rejection should be propagated to the lower level

364: -- PO_PDOI_CONSTANTS.g_INTERFACE_LINE_LOCATION_ID
365: --p_id_tbl
366: -- Table of ids
367: --p_cascade
368: -- FND_API.G_TRUE if rejection should be propagated to the lower level
369: -- FND_API.G_FALSE otherwise
370: --IN OUT:
371: --OUT:
372: --End of Comments

Line 369: -- FND_API.G_FALSE otherwise

365: --p_id_tbl
366: -- Table of ids
367: --p_cascade
368: -- FND_API.G_TRUE if rejection should be propagated to the lower level
369: -- FND_API.G_FALSE otherwise
370: --IN OUT:
371: --OUT:
372: --End of Comments
373: ------------------------------------------------------------------------

Line 426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

422: RETURNING interface_line_location_id, interface_header_id
423: BULK COLLECT INTO l_intf_line_loc_id_tbl, l_intf_header_id_tbl;
424: ELSE
425: d_position := 40;
426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
427: END IF;
428:
429: d_position := 50;
430:

Line 435: IF (p_cascade = FND_API.G_TRUE) THEN

431: set_doc_has_errors
432: ( p_intf_header_id_tbl => l_intf_header_id_tbl
433: );
434:
435: IF (p_cascade = FND_API.G_TRUE) THEN
436: IF (PO_PDOI_PARAMS.g_request.document_type =
437: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN
438:
439: d_position := 60;

Line 524: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

520: BULK COLLECT INTO l_intf_header_id_tbl;
521:
522: ELSE
523: d_position := 40;
524: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
525: END IF;
526:
527: set_doc_has_errors
528: ( p_intf_header_id_tbl => l_intf_header_id_tbl

Line 610: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

606: BULK COLLECT INTO l_intf_header_id_tbl;
607:
608: ELSE
609: d_position := 40;
610: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
611: END IF;
612:
613: /*
614: -- bug 4700377

Line 702: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

698: BULK COLLECT INTO l_intf_header_id_tbl;
699:
700: ELSE
701: d_position := 40;
702: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
703: END IF;
704:
705: set_doc_has_errors
706: ( p_intf_header_id_tbl => l_intf_header_id_tbl

Line 789: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

785: BULK COLLECT INTO l_intf_header_id_tbl;
786:
787: ELSE
788: d_position := 40;
789: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
790: END IF;
791:
792: set_doc_has_errors
793: ( p_intf_header_id_tbl => l_intf_header_id_tbl

Line 854: p_cascade => FND_API.G_TRUE

850: -- reject interface records
851: reject_headers_intf
852: ( p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_HEADER_ID,
853: p_id_tbl => PO_TBL_NUMBER(p_interface_header_id),
854: p_cascade => FND_API.G_TRUE
855: );
856:
857: d_position := 10;
858:

Line 862: IF ( p_remove_draft = FND_API.G_TRUE ) THEN

858:
859: -- bug5129752
860: -- Use p_remove_draft to determine whether draft should be removed or not
861:
862: IF ( p_remove_draft = FND_API.G_TRUE ) THEN
863: -- remove draft changes
864: PO_DRAFTS_PVT.remove_draft_changes
865: ( p_draft_id => p_draft_id,
866: p_exclude_ctrl_tbl => FND_API.G_FALSE,

Line 866: p_exclude_ctrl_tbl => FND_API.G_FALSE,

862: IF ( p_remove_draft = FND_API.G_TRUE ) THEN
863: -- remove draft changes
864: PO_DRAFTS_PVT.remove_draft_changes
865: ( p_draft_id => p_draft_id,
866: p_exclude_ctrl_tbl => FND_API.G_FALSE,
867: x_return_status => l_return_status
868: );
869: END IF;
870:

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

867: x_return_status => l_return_status
868: );
869: END IF;
870:
871: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
872: d_position := 20;
873: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
874: END IF;
875:

Line 873: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

869: END IF;
870:
871: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
872: d_position := 20;
873: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
874: END IF;
875:
876: IF (PO_LOG.d_proc) THEN
877: PO_LOG.proc_end(d_module);

Line 996: -- FND_API.G_TRUE if the request is still processing

992: --IN:
993: --p_old_request_id
994: -- request id in question
995: --RETURN:
996: -- FND_API.G_TRUE if the request is still processing
997: -- FND_API.G_FALSE otherwise
998: --End of Comments
999: ------------------------------------------------------------------------
1000: FUNCTION is_old_request_complete

Line 997: -- FND_API.G_FALSE otherwise

993: --p_old_request_id
994: -- request id in question
995: --RETURN:
996: -- FND_API.G_TRUE if the request is still processing
997: -- FND_API.G_FALSE otherwise
998: --End of Comments
999: ------------------------------------------------------------------------
1000: FUNCTION is_old_request_complete
1001: ( p_old_request_id IN NUMBER

Line 1028: l_complete := FND_API.G_FALSE;

1024: PO_LOG.proc_begin (d_module, 'p_old_request_id', p_old_request_id);
1025: END IF;
1026:
1027: l_old_request_id := p_old_request_id;
1028: l_complete := FND_API.G_FALSE;
1029:
1030: IF ( NVL(l_old_request_id, -1) = -1) THEN
1031: -- If record does not come from concurrent request, we cannot figure
1032: -- out whether the other process has finished processing this record or

Line 1037: l_complete := FND_API.G_FALSE;

1033: -- not, so we just assume that this record cannot be processed anymore
1034:
1035: d_position := 10;
1036:
1037: l_complete := FND_API.G_FALSE;
1038: ELSE
1039: IF (l_old_request_id = FND_GLOBAL.conc_request_id) THEN
1040: d_position := 20;
1041:

Line 1047: l_complete := FND_API.G_TRUE;

1043: PO_LOG.stmt (d_module, d_position, 'Restart case.');
1044: END IF;
1045:
1046: -- restart case. The old one must have been completed.
1047: l_complete := FND_API.G_TRUE;
1048:
1049: ELSE
1050: d_position := 30;
1051:

Line 1067: l_complete := FND_API.G_TRUE;

1063: );
1064:
1065: IF (l_call_status = FALSE OR l_dev_phase = 'COMPLETE') THEN
1066: d_position := 40;
1067: l_complete := FND_API.G_TRUE;
1068: ELSE
1069: d_position := 50;
1070: l_complete := FND_API.G_FALSE;
1071: END IF;

Line 1070: l_complete := FND_API.G_FALSE;

1066: d_position := 40;
1067: l_complete := FND_API.G_TRUE;
1068: ELSE
1069: d_position := 50;
1070: l_complete := FND_API.G_FALSE;
1071: END IF;
1072:
1073: END IF; -- if l_dft_request_id = FND_GLOBAL.conc_request_id
1074:

Line 1132: PO_PDOI_PARAMS.g_docs_info(p_intf_header_id_tbl(i)).has_errors := FND_API.G_TRUE;

1128:
1129: -- Mark doc info to indicate that an error has occurred.
1130: FOR i IN 1..p_intf_header_id_tbl.COUNT LOOP
1131: IF (p_intf_header_id_tbl(i) IS NOT NULL) THEN
1132: PO_PDOI_PARAMS.g_docs_info(p_intf_header_id_tbl(i)).has_errors := FND_API.G_TRUE;
1133: END IF;
1134: END LOOP;
1135:
1136: IF (PO_LOG.d_proc) THEN