DBA Data[Home] [Help]

APPS.PO_INVOICE_HOLD_CHECK dependencies on PO_LOG

Line 73: IF (PO_LOG.d_stmt) THEN

69: END IF;
70:
71: d_progress := '001';
72:
73: IF (PO_LOG.d_stmt) THEN
74: PO_LOG.stmt(d_module, d_progress, 'API Compatible call success');
75: END IF;
76:
77: -- Initialize API return status to success

Line 74: PO_LOG.stmt(d_module, d_progress, 'API Compatible call success');

70:
71: d_progress := '001';
72:
73: IF (PO_LOG.d_stmt) THEN
74: PO_LOG.stmt(d_module, d_progress, 'API Compatible call success');
75: END IF;
76:
77: -- Initialize API return status to success
78: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 89: IF (PO_LOG.d_stmt) THEN

85: l_type_lookup_code
86: FROM po_headers_all
87: WHERE po_header_id = p_po_header_id;
88:
89: IF (PO_LOG.d_stmt) THEN
90: PO_LOG.stmt(d_module, d_progress, 'pay when paid query executed');
91: END IF;
92:
93: IF l_type_lookup_code <> 'STANDARD'

Line 90: PO_LOG.stmt(d_module, d_progress, 'pay when paid query executed');

86: FROM po_headers_all
87: WHERE po_header_id = p_po_header_id;
88:
89: IF (PO_LOG.d_stmt) THEN
90: PO_LOG.stmt(d_module, d_progress, 'pay when paid query executed');
91: END IF;
92:
93: IF l_type_lookup_code <> 'STANDARD'
94: THEN

Line 173: IF (PO_LOG.d_stmt) THEN

169: RETURN;
170: END IF;
171:
172: d_progress := '001';
173: IF (PO_LOG.d_stmt) THEN
174: PO_LOG.stmt(d_module, d_progress, 'API Compatible call success');
175: END IF;
176:
177: -- Initialize API return status to success

Line 174: PO_LOG.stmt(d_module, d_progress, 'API Compatible call success');

170: END IF;
171:
172: d_progress := '001';
173: IF (PO_LOG.d_stmt) THEN
174: PO_LOG.stmt(d_module, d_progress, 'API Compatible call success');
175: END IF;
176:
177: -- Initialize API return status to success
178: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 204: IF (PO_LOG.d_stmt) THEN

200: x_return_status := FND_API.G_RET_STS_SUCCESS;
201: X_HOLD_REQUIRED := 'N';
202: END IF;
203:
204: IF (PO_LOG.d_stmt) THEN
205: PO_LOG.stmt(d_module, d_progress, 'pay when paid query executed');
206: END IF;
207:
208:

Line 205: PO_LOG.stmt(d_module, d_progress, 'pay when paid query executed');

201: X_HOLD_REQUIRED := 'N';
202: END IF;
203:
204: IF (PO_LOG.d_stmt) THEN
205: PO_LOG.stmt(d_module, d_progress, 'pay when paid query executed');
206: END IF;
207:
208:
209: IF l_pay_when_paid = 'Y' THEN

Line 213: IF (PO_LOG.d_stmt) THEN

209: IF l_pay_when_paid = 'Y' THEN
210: --Call OKC API to get the hold related information.
211:
212: d_progress := '003';
213: IF (PO_LOG.d_stmt) THEN
214: PO_LOG.stmt(d_module, d_progress, 'Before Calling OKC code to find contract deliverable hold info');
215: END IF;
216:
217: OKC_MANAGE_DELIVERABLES_GRP.applypaymentholds

Line 214: PO_LOG.stmt(d_module, d_progress, 'Before Calling OKC code to find contract deliverable hold info');

210: --Call OKC API to get the hold related information.
211:
212: d_progress := '003';
213: IF (PO_LOG.d_stmt) THEN
214: PO_LOG.stmt(d_module, d_progress, 'Before Calling OKC code to find contract deliverable hold info');
215: END IF;
216:
217: OKC_MANAGE_DELIVERABLES_GRP.applypaymentholds
218: (p_api_version => l_api_version,

Line 226: IF (PO_LOG.d_stmt) THEN

222: x_msg_count => l_msg_count,
223: x_return_status => l_return_status_okc);
224:
225: d_progress := '004';
226: IF (PO_LOG.d_stmt) THEN
227: PO_LOG.stmt(d_module, d_progress, 'After Calling OKC code to find contract deliverable hold info');
228: END IF;
229: IF l_return_status_okc = fnd_api.g_true THEN
230: x_hold_required := 'Y';

Line 227: PO_LOG.stmt(d_module, d_progress, 'After Calling OKC code to find contract deliverable hold info');

223: x_return_status => l_return_status_okc);
224:
225: d_progress := '004';
226: IF (PO_LOG.d_stmt) THEN
227: PO_LOG.stmt(d_module, d_progress, 'After Calling OKC code to find contract deliverable hold info');
228: END IF;
229: IF l_return_status_okc = fnd_api.g_true THEN
230: x_hold_required := 'Y';
231: x_return_status := fnd_api.g_ret_sts_success;

Line 243: IF (PO_LOG.d_stmt) THEN

239: END IF;
240: ELSE
241: d_progress := '005';
242: -- No need to call OKC. This PO does not have 'Pay when Paid' term marked.
243: IF (PO_LOG.d_stmt) THEN
244: PO_LOG.stmt(d_module, d_progress, 'No need to call OKC as the Pay When Paid term is N or NULL');
245: END IF;
246: x_hold_required := 'N';
247: END IF;

Line 244: PO_LOG.stmt(d_module, d_progress, 'No need to call OKC as the Pay When Paid term is N or NULL');

240: ELSE
241: d_progress := '005';
242: -- No need to call OKC. This PO does not have 'Pay when Paid' term marked.
243: IF (PO_LOG.d_stmt) THEN
244: PO_LOG.stmt(d_module, d_progress, 'No need to call OKC as the Pay When Paid term is N or NULL');
245: END IF;
246: x_hold_required := 'N';
247: END IF;
248: