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

Line 4: d_pkg_name CONSTANT varchar2(50) := PO_LOG.get_package_base('PO_DOC_UDA_UTIL');

1: package body po_doc_uda_util AS
2: /* $Header: PO_DOC_UDA_UTIL.plb 120.10.12020000.2 2013/02/11 01:54:11 vegajula ship $ */
3:
4: d_pkg_name CONSTANT varchar2(50) := PO_LOG.get_package_base('PO_DOC_UDA_UTIL');
5:
6: PROCEDURE DEBUG
7: (
8: p_msg IN VARCHAR2

Line 13: IF PO_LOG.d_stmt THEN

9: ,p_progress IN NUMBER
10: )
11: IS
12: BEGIN
13: IF PO_LOG.d_stmt THEN
14: PO_LOG.stmt('po_doc_uda_util', p_progress, 'Message: ', p_msg);
15: END IF;
16:
17:

Line 14: PO_LOG.stmt('po_doc_uda_util', p_progress, 'Message: ', p_msg);

10: )
11: IS
12: BEGIN
13: IF PO_LOG.d_stmt THEN
14: PO_LOG.stmt('po_doc_uda_util', p_progress, 'Message: ', p_msg);
15: END IF;
16:
17:
18: END DEBUG;

Line 43: IF (PO_LOG.d_proc) THEN

39: select distinct(attribute_category) from po_uda_ag_template_usages
40: where template_id = p_template_id;
41:
42: BEGIN
43: IF (PO_LOG.d_proc) THEN
44: PO_LOG.proc_begin(d_module);
45: PO_LOG.proc_begin(d_module, 'p_template_id', p_template_id);
46: END IF;
47:

Line 44: PO_LOG.proc_begin(d_module);

40: where template_id = p_template_id;
41:
42: BEGIN
43: IF (PO_LOG.d_proc) THEN
44: PO_LOG.proc_begin(d_module);
45: PO_LOG.proc_begin(d_module, 'p_template_id', p_template_id);
46: END IF;
47:
48: l_attr_grp_ids := PO_TBL_NUMBER();

Line 45: PO_LOG.proc_begin(d_module, 'p_template_id', p_template_id);

41:
42: BEGIN
43: IF (PO_LOG.d_proc) THEN
44: PO_LOG.proc_begin(d_module);
45: PO_LOG.proc_begin(d_module, 'p_template_id', p_template_id);
46: END IF;
47:
48: l_attr_grp_ids := PO_TBL_NUMBER();
49:

Line 62: IF PO_LOG.d_stmt THEN

58:
59: IF((p_is_doc_mod = FND_API.G_TRUE AND c_get_usages_rec.attribute_category = 'CHAIN')
60: OR (c_get_usages_rec.attribute_category = 'DOCUMENT_NUMBERING')) THEN
61: -- OR (c_get_usages_rec.attribute_category = 'BASE_DOC_INFO') ) THEN --Bug 11797563
62: IF PO_LOG.d_stmt THEN
63: PO_LOG.stmt(d_module, d_progress, 'Ignore Chain and Doc Numbering AGs');
64: END IF;
65: ELSE
66: l_po_uda_usage_object := po_uda_usage_object.new_instance(p_template_id,c_get_usages_rec.attribute_category,l_context );

Line 63: PO_LOG.stmt(d_module, d_progress, 'Ignore Chain and Doc Numbering AGs');

59: IF((p_is_doc_mod = FND_API.G_TRUE AND c_get_usages_rec.attribute_category = 'CHAIN')
60: OR (c_get_usages_rec.attribute_category = 'DOCUMENT_NUMBERING')) THEN
61: -- OR (c_get_usages_rec.attribute_category = 'BASE_DOC_INFO') ) THEN --Bug 11797563
62: IF PO_LOG.d_stmt THEN
63: PO_LOG.stmt(d_module, d_progress, 'Ignore Chain and Doc Numbering AGs');
64: END IF;
65: ELSE
66: l_po_uda_usage_object := po_uda_usage_object.new_instance(p_template_id,c_get_usages_rec.attribute_category,l_context );
67: l_attr_grp_ids_list := l_po_uda_usage_object.Attr_group_Id;

Line 81: IF PO_LOG.d_stmt THEN

77:
78: x_attr_grp_ids := l_attr_grp_ids;
79: x_return_status := 'S';
80:
81: IF PO_LOG.d_stmt THEN
82: PO_LOG.stmt(d_module, d_progress, 'x_attr_grp_ids', x_attr_grp_ids);
83: PO_LOG.stmt(d_module, d_progress, 'x_return_status', x_return_status);
84: END IF;
85:

Line 82: PO_LOG.stmt(d_module, d_progress, 'x_attr_grp_ids', x_attr_grp_ids);

78: x_attr_grp_ids := l_attr_grp_ids;
79: x_return_status := 'S';
80:
81: IF PO_LOG.d_stmt THEN
82: PO_LOG.stmt(d_module, d_progress, 'x_attr_grp_ids', x_attr_grp_ids);
83: PO_LOG.stmt(d_module, d_progress, 'x_return_status', x_return_status);
84: END IF;
85:
86: EXCEPTION

Line 83: PO_LOG.stmt(d_module, d_progress, 'x_return_status', x_return_status);

79: x_return_status := 'S';
80:
81: IF PO_LOG.d_stmt THEN
82: PO_LOG.stmt(d_module, d_progress, 'x_attr_grp_ids', x_attr_grp_ids);
83: PO_LOG.stmt(d_module, d_progress, 'x_return_status', x_return_status);
84: END IF;
85:
86: EXCEPTION
87: WHEN No_Data_Found THEN

Line 93: IF PO_LOG.d_stmt THEN

89:
90: WHEN OTHERS THEN
91: d_progress := 40;
92: x_return_status := 'U';
93: IF PO_LOG.d_stmt THEN
94: PO_LOG.stmt(d_module, d_progress, 'x_return_status', x_return_status);
95: END IF;
96: END get_po_header_attr_group_ids;
97:

Line 94: PO_LOG.stmt(d_module, d_progress, 'x_return_status', x_return_status);

90: WHEN OTHERS THEN
91: d_progress := 40;
92: x_return_status := 'U';
93: IF PO_LOG.d_stmt THEN
94: PO_LOG.stmt(d_module, d_progress, 'x_return_status', x_return_status);
95: END IF;
96: END get_po_header_attr_group_ids;
97:
98: PROCEDURE get_po_line_attr_group_ids(

Line 128: IF (PO_LOG.d_proc) THEN

124: WHERE template_id = p_template_id;
125:
126: BEGIN
127:
128: IF (PO_LOG.d_proc) THEN
129: PO_LOG.proc_begin(d_module);
130: PO_LOG.proc_begin(d_module, 'p_template_id', p_template_id);
131: END IF;
132:

Line 129: PO_LOG.proc_begin(d_module);

125:
126: BEGIN
127:
128: IF (PO_LOG.d_proc) THEN
129: PO_LOG.proc_begin(d_module);
130: PO_LOG.proc_begin(d_module, 'p_template_id', p_template_id);
131: END IF;
132:
133: l_attr_grp_ids := PO_TBL_NUMBER();

Line 130: PO_LOG.proc_begin(d_module, 'p_template_id', p_template_id);

126: BEGIN
127:
128: IF (PO_LOG.d_proc) THEN
129: PO_LOG.proc_begin(d_module);
130: PO_LOG.proc_begin(d_module, 'p_template_id', p_template_id);
131: END IF;
132:
133: l_attr_grp_ids := PO_TBL_NUMBER();
134:

Line 177: IF PO_LOG.d_stmt THEN

173: EGO_COL_NAME_VALUE_PAIR_OBJ( 'IDC_TYPE' , l_clm_idc_type ));
174: END IF;
175:
176: IF(p_is_doc_mod = FND_API.G_TRUE AND c_get_usages_rec.attribute_category = 'CHAIN') THEN
177: IF PO_LOG.d_stmt THEN
178: PO_LOG.stmt(d_module, d_progress, 'Ignore Chain AG Ids');
179: END IF;
180:
181: ELSE

Line 178: PO_LOG.stmt(d_module, d_progress, 'Ignore Chain AG Ids');

174: END IF;
175:
176: IF(p_is_doc_mod = FND_API.G_TRUE AND c_get_usages_rec.attribute_category = 'CHAIN') THEN
177: IF PO_LOG.d_stmt THEN
178: PO_LOG.stmt(d_module, d_progress, 'Ignore Chain AG Ids');
179: END IF;
180:
181: ELSE
182: l_po_uda_usage_object := po_uda_usage_object.new_instance(p_template_id,c_get_usages_rec.attribute_category,l_context );

Line 196: IF PO_LOG.d_stmt THEN

192:
193: x_attr_grp_ids := l_attr_grp_ids;
194: x_return_status := 'S';
195:
196: IF PO_LOG.d_stmt THEN
197: PO_LOG.stmt(d_module, d_progress, 'x_attr_grp_ids', x_attr_grp_ids);
198: PO_LOG.stmt(d_module, d_progress, 'x_return_status', x_return_status);
199: END IF;
200:

Line 197: PO_LOG.stmt(d_module, d_progress, 'x_attr_grp_ids', x_attr_grp_ids);

193: x_attr_grp_ids := l_attr_grp_ids;
194: x_return_status := 'S';
195:
196: IF PO_LOG.d_stmt THEN
197: PO_LOG.stmt(d_module, d_progress, 'x_attr_grp_ids', x_attr_grp_ids);
198: PO_LOG.stmt(d_module, d_progress, 'x_return_status', x_return_status);
199: END IF;
200:
201: EXCEPTION

Line 198: PO_LOG.stmt(d_module, d_progress, 'x_return_status', x_return_status);

194: x_return_status := 'S';
195:
196: IF PO_LOG.d_stmt THEN
197: PO_LOG.stmt(d_module, d_progress, 'x_attr_grp_ids', x_attr_grp_ids);
198: PO_LOG.stmt(d_module, d_progress, 'x_return_status', x_return_status);
199: END IF;
200:
201: EXCEPTION
202: WHEN No_Data_Found THEN

Line 208: IF PO_LOG.d_stmt THEN

204:
205: WHEN OTHERS THEN
206: d_progress := 40;
207: x_return_status := 'U';
208: IF PO_LOG.d_stmt THEN
209: PO_LOG.stmt(d_module, d_progress, 'x_return_status', x_return_status);
210: END IF;
211: END get_po_line_attr_group_ids;
212:

Line 209: PO_LOG.stmt(d_module, d_progress, 'x_return_status', x_return_status);

205: WHEN OTHERS THEN
206: d_progress := 40;
207: x_return_status := 'U';
208: IF PO_LOG.d_stmt THEN
209: PO_LOG.stmt(d_module, d_progress, 'x_return_status', x_return_status);
210: END IF;
211: END get_po_line_attr_group_ids;
212:
213:

Line 237: IF (PO_LOG.d_proc) THEN

233: SELECT DISTINCT(ATTRIBUTE_CATEGORY) FROM po_uda_ag_template_usages
234: WHERE template_id = p_template_id;
235:
236: BEGIN
237: IF (PO_LOG.d_proc) THEN
238: PO_LOG.proc_begin(d_module);
239: PO_LOG.proc_begin(d_module, 'p_template_id', p_template_id);
240: END IF;
241:

Line 238: PO_LOG.proc_begin(d_module);

234: WHERE template_id = p_template_id;
235:
236: BEGIN
237: IF (PO_LOG.d_proc) THEN
238: PO_LOG.proc_begin(d_module);
239: PO_LOG.proc_begin(d_module, 'p_template_id', p_template_id);
240: END IF;
241:
242: l_attr_grp_ids := PO_TBL_NUMBER();

Line 239: PO_LOG.proc_begin(d_module, 'p_template_id', p_template_id);

235:
236: BEGIN
237: IF (PO_LOG.d_proc) THEN
238: PO_LOG.proc_begin(d_module);
239: PO_LOG.proc_begin(d_module, 'p_template_id', p_template_id);
240: END IF;
241:
242: l_attr_grp_ids := PO_TBL_NUMBER();
243:

Line 246: IF PO_LOG.d_stmt THEN

242: l_attr_grp_ids := PO_TBL_NUMBER();
243:
244: FOR c_get_usages_rec IN c_get_usages(p_template_id) LOOP
245: IF(p_is_doc_mod = FND_API.G_TRUE AND c_get_usages_rec.attribute_category = 'CHAIN') THEN
246: IF PO_LOG.d_stmt THEN
247: PO_LOG.stmt(d_module, d_progress, 'Ignore Chain AG Ids');
248: END IF;
249:
250: ELSE

Line 247: PO_LOG.stmt(d_module, d_progress, 'Ignore Chain AG Ids');

243:
244: FOR c_get_usages_rec IN c_get_usages(p_template_id) LOOP
245: IF(p_is_doc_mod = FND_API.G_TRUE AND c_get_usages_rec.attribute_category = 'CHAIN') THEN
246: IF PO_LOG.d_stmt THEN
247: PO_LOG.stmt(d_module, d_progress, 'Ignore Chain AG Ids');
248: END IF;
249:
250: ELSE
251: l_po_uda_usage_object := po_uda_usage_object.new_instance(p_template_id,c_get_usages_rec.attribute_category,l_context );

Line 266: IF PO_LOG.d_stmt THEN

262:
263: x_attr_grp_ids := l_attr_grp_ids;
264: x_return_status := 'S';
265:
266: IF PO_LOG.d_stmt THEN
267: PO_LOG.stmt(d_module, d_progress, 'x_attr_grp_ids', x_attr_grp_ids);
268: PO_LOG.stmt(d_module, d_progress, 'x_return_status', x_return_status);
269: END IF;
270:

Line 267: PO_LOG.stmt(d_module, d_progress, 'x_attr_grp_ids', x_attr_grp_ids);

263: x_attr_grp_ids := l_attr_grp_ids;
264: x_return_status := 'S';
265:
266: IF PO_LOG.d_stmt THEN
267: PO_LOG.stmt(d_module, d_progress, 'x_attr_grp_ids', x_attr_grp_ids);
268: PO_LOG.stmt(d_module, d_progress, 'x_return_status', x_return_status);
269: END IF;
270:
271: EXCEPTION

Line 268: PO_LOG.stmt(d_module, d_progress, 'x_return_status', x_return_status);

264: x_return_status := 'S';
265:
266: IF PO_LOG.d_stmt THEN
267: PO_LOG.stmt(d_module, d_progress, 'x_attr_grp_ids', x_attr_grp_ids);
268: PO_LOG.stmt(d_module, d_progress, 'x_return_status', x_return_status);
269: END IF;
270:
271: EXCEPTION
272: WHEN OTHERS THEN

Line 275: IF PO_LOG.d_stmt THEN

271: EXCEPTION
272: WHEN OTHERS THEN
273: d_progress := 40;
274: x_return_status := 'U';
275: IF PO_LOG.d_stmt THEN
276: PO_LOG.stmt(d_module, d_progress, 'x_return_status', x_return_status);
277: END IF;
278: END get_po_line_loc_attr_group_ids;
279:

Line 276: PO_LOG.stmt(d_module, d_progress, 'x_return_status', x_return_status);

272: WHEN OTHERS THEN
273: d_progress := 40;
274: x_return_status := 'U';
275: IF PO_LOG.d_stmt THEN
276: PO_LOG.stmt(d_module, d_progress, 'x_return_status', x_return_status);
277: END IF;
278: END get_po_line_loc_attr_group_ids;
279:
280: PROCEDURE merge_mod_uda

Line 314: IF (PO_LOG.d_proc) THEN

310: FROM po_uda_ag_template_usages
311: WHERE template_id = l_template_id
312: AND ATTRIBUTE_CATEGORY IN ('ADDRESS', 'DOCUMENT_NUMBERING','MODIFICATIONS');
313: BEGIN
314: IF (PO_LOG.d_proc) THEN
315: PO_LOG.proc_begin(d_module);
316: PO_LOG.proc_begin(d_module, 'p_po_header_id', p_po_header_id);
317: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);
318: END IF;

Line 315: PO_LOG.proc_begin(d_module);

311: WHERE template_id = l_template_id
312: AND ATTRIBUTE_CATEGORY IN ('ADDRESS', 'DOCUMENT_NUMBERING','MODIFICATIONS');
313: BEGIN
314: IF (PO_LOG.d_proc) THEN
315: PO_LOG.proc_begin(d_module);
316: PO_LOG.proc_begin(d_module, 'p_po_header_id', p_po_header_id);
317: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);
318: END IF;
319: -- START WITH HEADER LEVEL MERGE

Line 316: PO_LOG.proc_begin(d_module, 'p_po_header_id', p_po_header_id);

312: AND ATTRIBUTE_CATEGORY IN ('ADDRESS', 'DOCUMENT_NUMBERING','MODIFICATIONS');
313: BEGIN
314: IF (PO_LOG.d_proc) THEN
315: PO_LOG.proc_begin(d_module);
316: PO_LOG.proc_begin(d_module, 'p_po_header_id', p_po_header_id);
317: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);
318: END IF;
319: -- START WITH HEADER LEVEL MERGE
320: SELECT uda_template_id

Line 317: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);

313: BEGIN
314: IF (PO_LOG.d_proc) THEN
315: PO_LOG.proc_begin(d_module);
316: PO_LOG.proc_begin(d_module, 'p_po_header_id', p_po_header_id);
317: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);
318: END IF;
319: -- START WITH HEADER LEVEL MERGE
320: SELECT uda_template_id
321: INTO l_template_id

Line 356: IF PO_LOG.d_stmt THEN

352: ,x_msg_count => l_msg_count
353: ,x_msg_data => l_msg_data
354: );
355:
356: IF PO_LOG.d_stmt THEN
357: PO_LOG.stmt(d_module, d_progress, 'l_return_status for Headers', l_return_status);
358: END IF;
359:
360: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 357: PO_LOG.stmt(d_module, d_progress, 'l_return_status for Headers', l_return_status);

353: ,x_msg_data => l_msg_data
354: );
355:
356: IF PO_LOG.d_stmt THEN
357: PO_LOG.stmt(d_module, d_progress, 'l_return_status for Headers', l_return_status);
358: END IF;
359:
360: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
361: RAISE FND_API.G_EXC_ERROR;

Line 367: IF PO_LOG.d_stmt THEN

363:
364: PO_UDA_DATA_UTIL.Merge_Mod_Address_AG(p_po_header_id => p_po_header_id
365: ,p_draft_id => p_draft_id
366: ,x_return_status => l_return_status );
367: IF PO_LOG.d_stmt THEN
368: PO_LOG.stmt(d_module, d_progress, 'Merge_Mod_Address_AG: l_return_status ', l_return_status);
369: END IF;
370:
371: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 368: PO_LOG.stmt(d_module, d_progress, 'Merge_Mod_Address_AG: l_return_status ', l_return_status);

364: PO_UDA_DATA_UTIL.Merge_Mod_Address_AG(p_po_header_id => p_po_header_id
365: ,p_draft_id => p_draft_id
366: ,x_return_status => l_return_status );
367: IF PO_LOG.d_stmt THEN
368: PO_LOG.stmt(d_module, d_progress, 'Merge_Mod_Address_AG: l_return_status ', l_return_status);
369: END IF;
370:
371: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
372: RAISE FND_API.G_EXC_ERROR;

Line 423: IF PO_LOG.d_stmt THEN

419: ,x_msg_count => l_msg_count
420: ,x_msg_data => l_msg_data
421: );
422:
423: IF PO_LOG.d_stmt THEN
424: PO_LOG.stmt(d_module, d_progress, 'Merging UDA for Line ID ', l_po_line_ids(i));
425: PO_LOG.stmt(d_module, d_progress, 'l_return_status ', l_return_status);
426: END IF;
427:

Line 424: PO_LOG.stmt(d_module, d_progress, 'Merging UDA for Line ID ', l_po_line_ids(i));

420: ,x_msg_data => l_msg_data
421: );
422:
423: IF PO_LOG.d_stmt THEN
424: PO_LOG.stmt(d_module, d_progress, 'Merging UDA for Line ID ', l_po_line_ids(i));
425: PO_LOG.stmt(d_module, d_progress, 'l_return_status ', l_return_status);
426: END IF;
427:
428: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 425: PO_LOG.stmt(d_module, d_progress, 'l_return_status ', l_return_status);

421: );
422:
423: IF PO_LOG.d_stmt THEN
424: PO_LOG.stmt(d_module, d_progress, 'Merging UDA for Line ID ', l_po_line_ids(i));
425: PO_LOG.stmt(d_module, d_progress, 'l_return_status ', l_return_status);
426: END IF;
427:
428: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
429: RAISE FND_API.G_EXC_ERROR;

Line 463: IF PO_LOG.d_stmt THEN

459: ,x_msg_count => l_msg_count
460: ,x_msg_data => l_msg_data
461: );
462:
463: IF PO_LOG.d_stmt THEN
464: PO_LOG.stmt(d_module, d_progress, 'Merging UDA for Shipment ID ', l_po_line_location_ids(j));
465: PO_LOG.stmt(d_module, d_progress, 'l_return_status ', l_return_status);
466: END IF;
467:

Line 464: PO_LOG.stmt(d_module, d_progress, 'Merging UDA for Shipment ID ', l_po_line_location_ids(j));

460: ,x_msg_data => l_msg_data
461: );
462:
463: IF PO_LOG.d_stmt THEN
464: PO_LOG.stmt(d_module, d_progress, 'Merging UDA for Shipment ID ', l_po_line_location_ids(j));
465: PO_LOG.stmt(d_module, d_progress, 'l_return_status ', l_return_status);
466: END IF;
467:
468: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 465: PO_LOG.stmt(d_module, d_progress, 'l_return_status ', l_return_status);

461: );
462:
463: IF PO_LOG.d_stmt THEN
464: PO_LOG.stmt(d_module, d_progress, 'Merging UDA for Shipment ID ', l_po_line_location_ids(j));
465: PO_LOG.stmt(d_module, d_progress, 'l_return_status ', l_return_status);
466: END IF;
467:
468: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
469: RAISE FND_API.G_EXC_ERROR;

Line 480: IF (PO_LOG.d_exc) THEN

476: EXCEPTION
477: WHEN FND_API.G_EXC_ERROR THEN
478: d_progress := 090;
479: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count, p_data => l_msg_data);
480: IF (PO_LOG.d_exc) THEN
481: PO_LOG.exc(d_module, d_progress, l_msg_data );
482: PO_LOG.proc_end(d_module);
483: END IF;
484: x_return_status := FND_API.G_RET_STS_ERROR;

Line 481: PO_LOG.exc(d_module, d_progress, l_msg_data );

477: WHEN FND_API.G_EXC_ERROR THEN
478: d_progress := 090;
479: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count, p_data => l_msg_data);
480: IF (PO_LOG.d_exc) THEN
481: PO_LOG.exc(d_module, d_progress, l_msg_data );
482: PO_LOG.proc_end(d_module);
483: END IF;
484: x_return_status := FND_API.G_RET_STS_ERROR;
485: WHEN OTHERS THEN

Line 482: PO_LOG.proc_end(d_module);

478: d_progress := 090;
479: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count, p_data => l_msg_data);
480: IF (PO_LOG.d_exc) THEN
481: PO_LOG.exc(d_module, d_progress, l_msg_data );
482: PO_LOG.proc_end(d_module);
483: END IF;
484: x_return_status := FND_API.G_RET_STS_ERROR;
485: WHEN OTHERS THEN
486: d_progress := 100;

Line 518: IF (PO_LOG.d_proc) THEN

514: AND B.MAPPED_ATTRIBUTE = p_external_param
515: AND ACT.CLASSIFICATION_CODE = p_template_id;
516:
517: BEGIN
518: IF (PO_LOG.d_proc) THEN
519: PO_LOG.proc_begin(d_module);
520: PO_LOG.proc_begin(d_module, 'p_template_id', p_template_id);
521: END IF;
522:

Line 519: PO_LOG.proc_begin(d_module);

515: AND ACT.CLASSIFICATION_CODE = p_template_id;
516:
517: BEGIN
518: IF (PO_LOG.d_proc) THEN
519: PO_LOG.proc_begin(d_module);
520: PO_LOG.proc_begin(d_module, 'p_template_id', p_template_id);
521: END IF;
522:
523: l_attr_grp_ids := PO_TBL_NUMBER();

Line 520: PO_LOG.proc_begin(d_module, 'p_template_id', p_template_id);

516:
517: BEGIN
518: IF (PO_LOG.d_proc) THEN
519: PO_LOG.proc_begin(d_module);
520: PO_LOG.proc_begin(d_module, 'p_template_id', p_template_id);
521: END IF;
522:
523: l_attr_grp_ids := PO_TBL_NUMBER();
524:

Line 533: IF PO_LOG.d_stmt THEN

529:
530: x_attr_grp_ids := l_attr_grp_ids;
531: x_return_status := FND_API.G_RET_STS_SUCCESS;
532:
533: IF PO_LOG.d_stmt THEN
534: PO_LOG.stmt(d_module, d_progress, 'x_return_status ', x_return_status);
535: END IF;
536:
537: EXCEPTION

Line 534: PO_LOG.stmt(d_module, d_progress, 'x_return_status ', x_return_status);

530: x_attr_grp_ids := l_attr_grp_ids;
531: x_return_status := FND_API.G_RET_STS_SUCCESS;
532:
533: IF PO_LOG.d_stmt THEN
534: PO_LOG.stmt(d_module, d_progress, 'x_return_status ', x_return_status);
535: END IF;
536:
537: EXCEPTION
538: WHEN OTHERS THEN

Line 541: IF PO_LOG.d_stmt THEN

537: EXCEPTION
538: WHEN OTHERS THEN
539: d_progress := 40;
540: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
541: IF PO_LOG.d_stmt THEN
542: PO_LOG.stmt(d_module, d_progress, 'x_return_status', x_return_status);
543: END IF;
544: END get_ext_param_xle_actions_ags;
545:

Line 542: PO_LOG.stmt(d_module, d_progress, 'x_return_status', x_return_status);

538: WHEN OTHERS THEN
539: d_progress := 40;
540: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
541: IF PO_LOG.d_stmt THEN
542: PO_LOG.stmt(d_module, d_progress, 'x_return_status', x_return_status);
543: END IF;
544: END get_ext_param_xle_actions_ags;
545:
546: PROCEDURE get_ext_param_xd_actions_ags(

Line 570: IF (PO_LOG.d_proc) THEN

566: AND B.MAPPED_ATTRIBUTE = p_external_param
567: AND ACT.CLASSIFICATION_CODE = p_template_id;
568:
569: BEGIN
570: IF (PO_LOG.d_proc) THEN
571: PO_LOG.proc_begin(d_module);
572: PO_LOG.proc_begin(d_module, 'p_template_id', p_template_id);
573: END IF;
574:

Line 571: PO_LOG.proc_begin(d_module);

567: AND ACT.CLASSIFICATION_CODE = p_template_id;
568:
569: BEGIN
570: IF (PO_LOG.d_proc) THEN
571: PO_LOG.proc_begin(d_module);
572: PO_LOG.proc_begin(d_module, 'p_template_id', p_template_id);
573: END IF;
574:
575: l_attr_grp_ids := PO_TBL_NUMBER();

Line 572: PO_LOG.proc_begin(d_module, 'p_template_id', p_template_id);

568:
569: BEGIN
570: IF (PO_LOG.d_proc) THEN
571: PO_LOG.proc_begin(d_module);
572: PO_LOG.proc_begin(d_module, 'p_template_id', p_template_id);
573: END IF;
574:
575: l_attr_grp_ids := PO_TBL_NUMBER();
576:

Line 585: IF PO_LOG.d_stmt THEN

581:
582: x_attr_grp_ids := l_attr_grp_ids;
583: x_return_status := FND_API.G_RET_STS_SUCCESS;
584:
585: IF PO_LOG.d_stmt THEN
586: PO_LOG.stmt(d_module, d_progress, 'x_return_status ', x_return_status);
587: END IF;
588:
589: EXCEPTION

Line 586: PO_LOG.stmt(d_module, d_progress, 'x_return_status ', x_return_status);

582: x_attr_grp_ids := l_attr_grp_ids;
583: x_return_status := FND_API.G_RET_STS_SUCCESS;
584:
585: IF PO_LOG.d_stmt THEN
586: PO_LOG.stmt(d_module, d_progress, 'x_return_status ', x_return_status);
587: END IF;
588:
589: EXCEPTION
590: WHEN OTHERS THEN

Line 593: IF PO_LOG.d_stmt THEN

589: EXCEPTION
590: WHEN OTHERS THEN
591: d_progress := 40;
592: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
593: IF PO_LOG.d_stmt THEN
594: PO_LOG.stmt(d_module, d_progress, 'x_return_status', x_return_status);
595: END IF;
596: END get_ext_param_xd_actions_ags;
597:

Line 594: PO_LOG.stmt(d_module, d_progress, 'x_return_status', x_return_status);

590: WHEN OTHERS THEN
591: d_progress := 40;
592: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
593: IF PO_LOG.d_stmt THEN
594: PO_LOG.stmt(d_module, d_progress, 'x_return_status', x_return_status);
595: END IF;
596: END get_ext_param_xd_actions_ags;
597:
598: END po_doc_uda_util;