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_AP_INVOICE_MATCH_GRP dependencies on PO_LOG

Line 5: D_PACKAGE_BASE CONSTANT VARCHAR2(50) := PO_LOG.get_package_base(G_PKG_NAME);

1: PACKAGE BODY PO_AP_INVOICE_MATCH_GRP AS
2: /* $Header: POXAPINB.pls 120.11 2006/09/26 06:56:06 scolvenk noship $*/
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PO_AP_INVOICE_MATCH_GRP';
5: D_PACKAGE_BASE CONSTANT VARCHAR2(50) := PO_LOG.get_package_base(G_PKG_NAME);
6:
7: --
8: -------------------------------------------------------------------------
9: --Pre-reqs:

Line 42: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, l_api_name);

38: IS
39: l_api_version CONSTANT NUMBER := 1.0;
40: l_api_name CONSTANT VARCHAR2(30) := 'update_document_ap_values';
41: d_mod CONSTANT VARCHAR2(100) :=
42: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, l_api_name);
43: d_position NUMBER := 0;
44: BEGIN
45:
46: -- Standard API Savepoint

Line 49: IF PO_LOG.d_proc THEN

45:
46: -- Standard API Savepoint
47: SAVEPOINT update_document_ap_values_SP;
48:
49: IF PO_LOG.d_proc THEN
50: PO_LOG.proc_begin(d_mod,'p_api_version',p_api_version);
51: p_line_loc_changes_rec.dump_to_log;
52: p_dist_changes_rec.dump_to_log;
53: END IF;

Line 50: PO_LOG.proc_begin(d_mod,'p_api_version',p_api_version);

46: -- Standard API Savepoint
47: SAVEPOINT update_document_ap_values_SP;
48:
49: IF PO_LOG.d_proc THEN
50: PO_LOG.proc_begin(d_mod,'p_api_version',p_api_version);
51: p_line_loc_changes_rec.dump_to_log;
52: p_dist_changes_rec.dump_to_log;
53: END IF;
54:

Line 80: IF PO_LOG.d_stmt THEN

76: p_dist_changes_rec.populate_calculated_fields;
77:
78: d_position := 30;
79:
80: IF PO_LOG.d_stmt THEN
81: PO_LOG.stmt(d_mod,d_position,'Calculated fields populated');
82: p_line_loc_changes_rec.dump_to_log;
83: p_dist_changes_rec.dump_to_log;
84: END IF;

Line 81: PO_LOG.stmt(d_mod,d_position,'Calculated fields populated');

77:
78: d_position := 30;
79:
80: IF PO_LOG.d_stmt THEN
81: PO_LOG.stmt(d_mod,d_position,'Calculated fields populated');
82: p_line_loc_changes_rec.dump_to_log;
83: p_dist_changes_rec.dump_to_log;
84: END IF;
85:

Line 136: IF PO_LOG.d_stmt THEN

132: )
133: ;
134:
135: d_position := 40;
136: IF PO_LOG.d_stmt THEN
137: PO_LOG.stmt(d_mod,d_position,'Line Locations updated: ' || SQL%ROWCOUNT);
138: END IF;
139:
140: -- SQL What: Update the AP-related fields on the PO distribution

Line 137: PO_LOG.stmt(d_mod,d_position,'Line Locations updated: ' || SQL%ROWCOUNT);

133: ;
134:
135: d_position := 40;
136: IF PO_LOG.d_stmt THEN
137: PO_LOG.stmt(d_mod,d_position,'Line Locations updated: ' || SQL%ROWCOUNT);
138: END IF;
139:
140: -- SQL What: Update the AP-related fields on the PO distribution
141: -- SQL Where: For the distribution rows represented in p_dist_changes_rec

Line 190: IF PO_LOG.d_stmt THEN

186: AND pod2.po_distribution_id = p_dist_changes_rec.po_distribution_id_tbl(i)))
187: ;
188:
189: d_position := 50;
190: IF PO_LOG.d_stmt THEN
191: PO_LOG.stmt(d_mod,d_position,'Distributions updated: ' || SQL%ROWCOUNT);
192: END IF;
193:
194: IF PO_LOG.d_proc THEN

Line 191: PO_LOG.stmt(d_mod,d_position,'Distributions updated: ' || SQL%ROWCOUNT);

187: ;
188:
189: d_position := 50;
190: IF PO_LOG.d_stmt THEN
191: PO_LOG.stmt(d_mod,d_position,'Distributions updated: ' || SQL%ROWCOUNT);
192: END IF;
193:
194: IF PO_LOG.d_proc THEN
195: PO_LOG.proc_end(d_mod,'x_return_status', x_return_status);

Line 194: IF PO_LOG.d_proc THEN

190: IF PO_LOG.d_stmt THEN
191: PO_LOG.stmt(d_mod,d_position,'Distributions updated: ' || SQL%ROWCOUNT);
192: END IF;
193:
194: IF PO_LOG.d_proc THEN
195: PO_LOG.proc_end(d_mod,'x_return_status', x_return_status);
196: p_line_loc_changes_rec.dump_to_log;
197: p_dist_changes_rec.dump_to_log;
198: END IF;

Line 195: PO_LOG.proc_end(d_mod,'x_return_status', x_return_status);

191: PO_LOG.stmt(d_mod,d_position,'Distributions updated: ' || SQL%ROWCOUNT);
192: END IF;
193:
194: IF PO_LOG.d_proc THEN
195: PO_LOG.proc_end(d_mod,'x_return_status', x_return_status);
196: p_line_loc_changes_rec.dump_to_log;
197: p_dist_changes_rec.dump_to_log;
198: END IF;
199:

Line 203: IF PO_LOG.d_exc THEN

199:
200: EXCEPTION
201: WHEN OTHERS THEN
202: ROLLBACK TO update_document_ap_values_SP;
203: IF PO_LOG.d_exc THEN
204: PO_LOG.exc(d_mod,d_position,SQLERRM);
205: END IF;
206: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
207: FND_MESSAGE.set_name('PO', 'PO_ALL_TRACE_ERROR');

Line 204: PO_LOG.exc(d_mod,d_position,SQLERRM);

200: EXCEPTION
201: WHEN OTHERS THEN
202: ROLLBACK TO update_document_ap_values_SP;
203: IF PO_LOG.d_exc THEN
204: PO_LOG.exc(d_mod,d_position,SQLERRM);
205: END IF;
206: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
207: FND_MESSAGE.set_name('PO', 'PO_ALL_TRACE_ERROR');
208: FND_MESSAGE.set_token('FILE', 'POXAPINB.pls');

Line 258: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,l_api_name);

254: IS
255: l_api_version CONSTANT NUMBER := 1.0;
256: l_api_name CONSTANT VARCHAR2(30) := 'get_amount_to_retain';
257: d_mod CONSTANT VARCHAR2(100) :=
258: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,l_api_name);
259: d_position NUMBER := 0;
260: l_gt_key NUMBER;
261: BEGIN
262:

Line 263: IF PO_LOG.d_proc THEN

259: d_position NUMBER := 0;
260: l_gt_key NUMBER;
261: BEGIN
262:
263: IF PO_LOG.d_proc THEN
264: PO_LOG.proc_begin(d_mod,'p_api_version',p_api_version);
265: PO_LOG.proc_begin(d_mod,'p_line_location_id_tbl',p_line_location_id_tbl);
266: PO_LOG.proc_begin(d_mod,'p_line_loc_match_amt_tbl',p_line_loc_match_amt_tbl);
267: END IF;

Line 264: PO_LOG.proc_begin(d_mod,'p_api_version',p_api_version);

260: l_gt_key NUMBER;
261: BEGIN
262:
263: IF PO_LOG.d_proc THEN
264: PO_LOG.proc_begin(d_mod,'p_api_version',p_api_version);
265: PO_LOG.proc_begin(d_mod,'p_line_location_id_tbl',p_line_location_id_tbl);
266: PO_LOG.proc_begin(d_mod,'p_line_loc_match_amt_tbl',p_line_loc_match_amt_tbl);
267: END IF;
268:

Line 265: PO_LOG.proc_begin(d_mod,'p_line_location_id_tbl',p_line_location_id_tbl);

261: BEGIN
262:
263: IF PO_LOG.d_proc THEN
264: PO_LOG.proc_begin(d_mod,'p_api_version',p_api_version);
265: PO_LOG.proc_begin(d_mod,'p_line_location_id_tbl',p_line_location_id_tbl);
266: PO_LOG.proc_begin(d_mod,'p_line_loc_match_amt_tbl',p_line_loc_match_amt_tbl);
267: END IF;
268:
269: -- Initialize out parameters

Line 266: PO_LOG.proc_begin(d_mod,'p_line_loc_match_amt_tbl',p_line_loc_match_amt_tbl);

262:
263: IF PO_LOG.d_proc THEN
264: PO_LOG.proc_begin(d_mod,'p_api_version',p_api_version);
265: PO_LOG.proc_begin(d_mod,'p_line_location_id_tbl',p_line_location_id_tbl);
266: PO_LOG.proc_begin(d_mod,'p_line_loc_match_amt_tbl',p_line_loc_match_amt_tbl);
267: END IF;
268:
269: -- Initialize out parameters
270: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 339: IF PO_LOG.d_proc THEN

335: DELETE FROM PO_SESSION_GT GTT WHERE GTT.key = l_gt_key;
336:
337: d_position := 60;
338:
339: IF PO_LOG.d_proc THEN
340: PO_LOG.proc_end(d_mod,'x_return_status',x_return_status);
341: PO_LOG.proc_end(d_mod,'x_amount_to_retain_tbl',x_amount_to_retain_tbl);
342: END IF;
343:

Line 340: PO_LOG.proc_end(d_mod,'x_return_status',x_return_status);

336:
337: d_position := 60;
338:
339: IF PO_LOG.d_proc THEN
340: PO_LOG.proc_end(d_mod,'x_return_status',x_return_status);
341: PO_LOG.proc_end(d_mod,'x_amount_to_retain_tbl',x_amount_to_retain_tbl);
342: END IF;
343:
344: EXCEPTION

Line 341: PO_LOG.proc_end(d_mod,'x_amount_to_retain_tbl',x_amount_to_retain_tbl);

337: d_position := 60;
338:
339: IF PO_LOG.d_proc THEN
340: PO_LOG.proc_end(d_mod,'x_return_status',x_return_status);
341: PO_LOG.proc_end(d_mod,'x_amount_to_retain_tbl',x_amount_to_retain_tbl);
342: END IF;
343:
344: EXCEPTION
345: WHEN OTHERS THEN

Line 346: IF PO_LOG.d_exc THEN

342: END IF;
343:
344: EXCEPTION
345: WHEN OTHERS THEN
346: IF PO_LOG.d_exc THEN
347: PO_LOG.exc(d_mod,d_position,SQLERRM);
348: END IF;
349: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
350: FND_MESSAGE.set_name('PO', 'PO_ALL_TRACE_ERROR');

Line 347: PO_LOG.exc(d_mod,d_position,SQLERRM);

343:
344: EXCEPTION
345: WHEN OTHERS THEN
346: IF PO_LOG.d_exc THEN
347: PO_LOG.exc(d_mod,d_position,SQLERRM);
348: END IF;
349: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
350: FND_MESSAGE.set_name('PO', 'PO_ALL_TRACE_ERROR');
351: FND_MESSAGE.set_token('FILE', 'POXAPINB.pls');