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 175: IF (PO_LOG.d_stmt) THEN

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

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

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

Line 224: IF (PO_LOG.d_stmt) THEN

220: x_return_status := FND_API.G_RET_STS_SUCCESS;
221: X_HOLD_REQUIRED := 'N';
222: END IF;
223:
224: IF (PO_LOG.d_stmt) THEN
225: PO_LOG.stmt(d_module, d_progress, 'Pay when paid and Deliverable hold flag query executed');
226: END IF;
227:
228: -- E and C Phase 2 changes -

Line 225: PO_LOG.stmt(d_module, d_progress, 'Pay when paid and Deliverable hold flag query executed');

221: X_HOLD_REQUIRED := 'N';
222: END IF;
223:
224: IF (PO_LOG.d_stmt) THEN
225: PO_LOG.stmt(d_module, d_progress, 'Pay when paid and Deliverable hold flag query executed');
226: END IF;
227:
228: -- E and C Phase 2 changes -
229: -- Commented the earlier IF and added the deliverable hold flag condition to the same below */

Line 237: IF (PO_LOG.d_stmt) THEN

233: /* IF l_pay_when_paid = 'Y' THEN */
234: --Call OKC API to get the hold related information.
235:
236: d_progress := '003';
237: IF (PO_LOG.d_stmt) THEN
238: PO_LOG.stmt(d_module, d_progress, 'Before Calling OKC code to find contract deliverable hold info');
239: END IF;
240:
241: OKC_MANAGE_DELIVERABLES_GRP.applypaymentholds

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

234: --Call OKC API to get the hold related information.
235:
236: d_progress := '003';
237: IF (PO_LOG.d_stmt) THEN
238: PO_LOG.stmt(d_module, d_progress, 'Before Calling OKC code to find contract deliverable hold info');
239: END IF;
240:
241: OKC_MANAGE_DELIVERABLES_GRP.applypaymentholds
242: (p_api_version => l_api_version,

Line 250: IF (PO_LOG.d_stmt) THEN

246: x_msg_count => l_msg_count,
247: x_return_status => l_return_status_okc);
248:
249: d_progress := '004';
250: IF (PO_LOG.d_stmt) THEN
251: PO_LOG.stmt(d_module, d_progress, 'After Calling OKC code to find contract deliverable hold info');
252: END IF;
253: IF l_return_status_okc = fnd_api.g_true THEN
254: x_hold_required := 'Y';

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

247: x_return_status => l_return_status_okc);
248:
249: d_progress := '004';
250: IF (PO_LOG.d_stmt) THEN
251: PO_LOG.stmt(d_module, d_progress, 'After Calling OKC code to find contract deliverable hold info');
252: END IF;
253: IF l_return_status_okc = fnd_api.g_true THEN
254: x_hold_required := 'Y';
255: x_return_status := fnd_api.g_ret_sts_success;

Line 267: IF (PO_LOG.d_stmt) THEN

263: END IF;
264: ELSE
265: d_progress := '005';
266: -- No need to call OKC. This PO does not have 'Pay when Paid' or 'Deliverable Hold flag' attribute marked.
267: IF (PO_LOG.d_stmt) THEN
268: PO_LOG.stmt(d_module, d_progress, 'No need to call OKC as Pay When Paid/Deliverable Hold flag is N or NULL');
269: END IF;
270: x_hold_required := 'N';
271: END IF;

Line 268: PO_LOG.stmt(d_module, d_progress, 'No need to call OKC as Pay When Paid/Deliverable Hold flag is N or NULL');

264: ELSE
265: d_progress := '005';
266: -- No need to call OKC. This PO does not have 'Pay when Paid' or 'Deliverable Hold flag' attribute marked.
267: IF (PO_LOG.d_stmt) THEN
268: PO_LOG.stmt(d_module, d_progress, 'No need to call OKC as Pay When Paid/Deliverable Hold flag is N or NULL');
269: END IF;
270: x_hold_required := 'N';
271: END IF;
272:

Line 337: IF (PO_LOG.d_stmt) THEN

333: END IF;
334:
335: d_progress := '001';
336:
337: IF (PO_LOG.d_stmt) THEN
338: PO_LOG.stmt(d_module, d_progress, 'API Compatible call success');
339: END IF;
340:
341: -- Initialize API return status to success

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

334:
335: d_progress := '001';
336:
337: IF (PO_LOG.d_stmt) THEN
338: PO_LOG.stmt(d_module, d_progress, 'API Compatible call success');
339: END IF;
340:
341: -- Initialize API return status to success
342: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 361: IF (PO_LOG.d_stmt) THEN

357: WHERE ph.draft_id = p_po_header_id
358: AND ph.style_id = ps.style_id);
359:
360:
361: IF (PO_LOG.d_stmt) THEN
362: PO_LOG.stmt(d_module, d_progress, 'Deliverable Hold and pay when paid query executed');
363: END IF;
364:
365:

Line 362: PO_LOG.stmt(d_module, d_progress, 'Deliverable Hold and pay when paid query executed');

358: AND ph.style_id = ps.style_id);
359:
360:
361: IF (PO_LOG.d_stmt) THEN
362: PO_LOG.stmt(d_module, d_progress, 'Deliverable Hold and pay when paid query executed');
363: END IF;
364:
365:
366: