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.

[Home] [Help]

APPS.PO_UDA_AUTOCREATE_PKG dependencies on PO_DEBUG

Line 8: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;

4: g_pkg_name CONSTANT VARCHAR2(240) := 'PO_UDA_AUTOCREATE_PKG';
5: g_log_head CONSTANT VARCHAR2(240) := 'po.plsql.PO_UDA_AUTOCREATE_PKG.';
6:
7:
8: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;
9: g_debug_unexp CONSTANT BOOLEAN := PO_DEBUG.is_debug_unexp_on;
10:
11: g_tar_head_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
12:

Line 9: g_debug_unexp CONSTANT BOOLEAN := PO_DEBUG.is_debug_unexp_on;

5: g_log_head CONSTANT VARCHAR2(240) := 'po.plsql.PO_UDA_AUTOCREATE_PKG.';
6:
7:
8: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;
9: g_debug_unexp CONSTANT BOOLEAN := PO_DEBUG.is_debug_unexp_on;
10:
11: g_tar_head_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
12:
13: g_src_func_area VARCHAR2(100);

Line 73: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);

69:
70: BEGIN
71:
72: IF g_debug_stmt THEN
73: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);
74: END IF;
75:
76: IF g_debug_stmt THEN
77: po_debug.debug_stmt( p_log_head => g_log_head||l_api_name

Line 77: po_debug.debug_stmt( p_log_head => g_log_head||l_api_name

73: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);
74: END IF;
75:
76: IF g_debug_stmt THEN
77: po_debug.debug_stmt( p_log_head => g_log_head||l_api_name
78: , p_token => l_progress
79: , p_message => ' p_func_area : ' || p_func_area
80: ||' p_doc_type : ' || p_doc_type
81: ||' p_doc_style : ' || p_doc_style

Line 109: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name

105: )
106: AND document_level <> 'DISTRIBUTION'; -- bug 12611018
107:
108: IF g_debug_stmt THEN
109: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name
110: ,p_token => l_progress
111: ,p_message => 'No of available document Levels : ' || x_doc_level_tbl.Count
112: );
113:

Line 117: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);

113:
114: END IF;
115:
116: IF g_debug_stmt THEN
117: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);
118: END IF;
119:
120: EXCEPTION
121: WHEN OTHERS THEN

Line 123: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);

119:
120: EXCEPTION
121: WHEN OTHERS THEN
122: IF g_debug_unexp THEN
123: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
124: END IF;
125: RAISE;
126: END get_document_levels;
127:

Line 147: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);

143:
144: BEGIN
145:
146: IF g_debug_stmt THEN
147: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);
148: END IF;
149: l_progress := '010';
150:
151: l_template_id := po_uda_data_util.get_template_id(

Line 162: PO_DEBUG.debug_stmt( p_log_head => g_log_head||l_api_name,

158: x_err_msg => l_err_msg
159: );
160:
161: IF g_debug_stmt THEN
162: PO_DEBUG.debug_stmt( p_log_head => g_log_head||l_api_name,
163: p_token => l_progress,
164: p_message => ' Return Status : ' ||l_return_status || ' Template ID ' || l_template_id
165: );
166: END IF;

Line 175: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);

171: RETURN NULL;
172: END IF;
173:
174: IF g_debug_stmt THEN
175: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);
176: END IF;
177: EXCEPTION
178: WHEN OTHERS THEN
179: IF g_debug_unexp THEN

Line 180: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);

176: END IF;
177: EXCEPTION
178: WHEN OTHERS THEN
179: IF g_debug_unexp THEN
180: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
181: END IF;
182: RAISE;
183: END get_uda_template_id;
184:

Line 200: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);

196: l_attr_group_tbl PO_TBL_VARCHAR30;
197:
198: BEGIN
199: IF g_debug_stmt THEN
200: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);
201: END IF;
202: l_progress := '010';
203:
204: SELECT DISTINCT ag.attr_group_name

Line 213: PO_DEBUG.debug_var(p_log_head => g_log_head||l_api_name,

209: AND tu.attribute_category NOT IN ('PRICING','DOCUMENT_NUMBERING'); --12611018 Document numbering added
210:
211:
212: IF g_debug_stmt THEN
213: PO_DEBUG.debug_var(p_log_head => g_log_head||l_api_name,
214: p_progress => l_progress,
215: p_name => 'l_attr_group_tbl',
216: p_value => x_attr_group_tbl
217: );

Line 222: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);

218: END IF;
219:
220:
221: IF g_debug_stmt THEN
222: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);
223: END IF;
224: EXCEPTION
225: WHEN OTHERS THEN
226: IF g_debug_unexp THEN

Line 227: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);

223: END IF;
224: EXCEPTION
225: WHEN OTHERS THEN
226: IF g_debug_unexp THEN
227: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
228: END IF;
229: END get_attribute_groups;
230:
231:

Line 257: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);

253: l_priority VARCHAR2(4);
254:
255: BEGIN
256: IF g_debug_stmt THEN
257: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);
258: END IF;
259: l_progress := '010';
260:
261: IF g_debug_stmt THEN

Line 262: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

258: END IF;
259: l_progress := '010';
260:
261: IF g_debug_stmt THEN
262: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
263: p_token => l_progress,
264: p_message => 'p_doc_level : '|| p_doc_level
265: || 'p_attr_group : ' || p_attr_group
266: || 'p_src_doc_type : ' ||p_src_doc_type

Line 309: PO_DEBUG.debug_var(p_log_head => g_log_head||l_api_name,

305: END IF;
306: /*bug 12611018 ends*/
307:
308: IF g_debug_stmt THEN
309: PO_DEBUG.debug_var(p_log_head => g_log_head||l_api_name,
310: p_progress => l_progress,
311: p_name => 'l_priorities_tbl',
312: p_value => l_priorities_tbl(i)
313: );

Line 329: PO_DEBUG.debug_var(p_log_head => g_log_head||l_api_name,

325: END;
326:
327:
328: IF g_debug_stmt THEN
329: PO_DEBUG.debug_var(p_log_head => g_log_head||l_api_name,
330: p_progress => l_progress,
331: p_name => 'x_priorities_tbl Count',
332: p_value => x_priorities_tbl.count
333: );

Line 358: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

354: END IF;
355:
356:
357: IF g_debug_stmt THEN
358: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
359: p_token => l_progress,
360: p_message => 'source_doc_level : '|| x_source_doc_level
361: || 'group_type : ' || x_group_type
362: );

Line 367: po_debug.debug_end(p_log_head => g_log_head||l_api_name);

363: END IF;
364:
365:
366: IF g_debug_stmt THEN
367: po_debug.debug_end(p_log_head => g_log_head||l_api_name);
368: END IF;
369: EXCEPTION
370: WHEN OTHERS THEN
371: IF g_debug_unexp THEN

Line 372: po_debug.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);

368: END IF;
369: EXCEPTION
370: WHEN OTHERS THEN
371: IF g_debug_unexp THEN
372: po_debug.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
373: END IF;
374: --??Return l_priorities_tbl;
375: END get_autocreate_priorities;
376:

Line 398: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);

394: l_priority VARCHAR2(4);
395:
396: BEGIN
397: IF g_debug_stmt THEN
398: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);
399: END IF;
400:
401: IF g_debug_stmt THEN
402: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

Line 402: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

398: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);
399: END IF;
400:
401: IF g_debug_stmt THEN
402: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
403: p_token => l_progress,
404: p_message => 'p_doc_level : '|| p_doc_level
405: || 'p_attr_group : ' || p_attr_group
406: || 'p_src_doc_type : ' ||p_src_doc_type

Line 424: PO_DEBUG.debug_var(p_log_head => g_log_head||l_api_name,

420:
421:
422:
423: IF g_debug_stmt THEN
424: PO_DEBUG.debug_var(p_log_head => g_log_head||l_api_name,
425: p_progress => l_progress,
426: p_name => 'x_group_property_tbl',
427: p_value => x_group_property_tbl
428: );

Line 440: po_debug.debug_end(p_log_head => g_log_head||l_api_name);

436: END IF;
437:
438:
439: IF g_debug_stmt THEN
440: po_debug.debug_end(p_log_head => g_log_head||l_api_name);
441: END IF;
442: EXCEPTION
443: WHEN OTHERS THEN
444: IF g_debug_unexp THEN

Line 445: po_debug.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);

441: END IF;
442: EXCEPTION
443: WHEN OTHERS THEN
444: IF g_debug_unexp THEN
445: po_debug.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
446: END IF;
447: --??Return l_priorities_tbl;
448: END get_autocreate_properties;
449:

Line 471: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);

467:
468: l_ag_type VARCHAR2(300);
469: BEGIN
470: IF g_debug_stmt THEN
471: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);
472: END IF;
473:
474: IF g_debug_stmt THEN
475: po_debug.debug_stmt( p_log_head => g_log_head||l_api_name

Line 475: po_debug.debug_stmt( p_log_head => g_log_head||l_api_name

471: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);
472: END IF;
473:
474: IF g_debug_stmt THEN
475: po_debug.debug_stmt( p_log_head => g_log_head||l_api_name
476: , p_token => l_progress
477: , p_message => ' p_func_area : ' || p_func_area
478: ||' p_doc_type : ' || p_doc_type
479: ||' p_doc_style : ' || p_doc_style

Line 501: po_debug.debug_stmt( p_log_head => g_log_head||l_api_name

497: AND compiled_flag = 'Y';
498:
499:
500: IF g_debug_stmt THEN
501: po_debug.debug_stmt( p_log_head => g_log_head||l_api_name
502: , p_token => l_progress
503: , p_message => ' Attribute Group Type (Entity Code) ' || l_ag_type
504: );
505:

Line 509: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);

505:
506: END IF;
507:
508: IF g_debug_stmt THEN
509: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);
510: END IF;
511:
512: RETURN l_ag_type;
513: EXCEPTION

Line 516: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);

512: RETURN l_ag_type;
513: EXCEPTION
514: WHEN OTHERS THEN
515: IF g_debug_unexp THEN
516: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
517: END IF;
518: RETURN NULL;
519: END get_attribute_group_type;
520:

Line 531: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);

527: l_ext_table_name VARCHAR2(100);
528: BEGIN
529:
530: IF g_debug_stmt THEN
531: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);
532: END IF;
533:
534: IF g_debug_stmt THEN
535: po_debug.debug_stmt( p_log_head => g_log_head||l_api_name

Line 535: po_debug.debug_stmt( p_log_head => g_log_head||l_api_name

531: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);
532: END IF;
533:
534: IF g_debug_stmt THEN
535: po_debug.debug_stmt( p_log_head => g_log_head||l_api_name
536: , p_token => l_progress
537: , p_message => ' Attribute Group Type (Entity Code) ' || p_ag_type
538: );
539:

Line 551: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name

547: WHERE 1=1
548: AND attr_group_type = p_ag_type;
549:
550: IF g_debug_stmt THEN
551: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name
552: ,p_token => l_progress
553: ,p_message => 'Ext table for Attribute Group ' || l_ext_table_name
554: );
555:

Line 559: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);

555:
556: END IF;
557:
558: IF g_debug_stmt THEN
559: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);
560: END IF;
561:
562: RETURN l_ext_table_name;
563: EXCEPTION

Line 566: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);

562: RETURN l_ext_table_name;
563: EXCEPTION
564: WHEN OTHERS THEN
565: IF g_debug_unexp THEN
566: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
567: END IF;
568: RETURN NULL;
569: END get_tbl_for_ag_type;
570:

Line 588: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);

584: l_query VARCHAR2(1500);
585: BEGIN
586:
587: IF g_debug_stmt THEN
588: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);
589: END IF;
590:
591: IF g_debug_stmt THEN
592: po_debug.debug_stmt( p_log_head => g_log_head||l_api_name

Line 592: po_debug.debug_stmt( p_log_head => g_log_head||l_api_name

588: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);
589: END IF;
590:
591: IF g_debug_stmt THEN
592: po_debug.debug_stmt( p_log_head => g_log_head||l_api_name
593: , p_token => l_progress
594: , p_message => ' p_table_name : ' || p_table_name
595: ||' p_pkey1_col_name : ' || p_pkey1_col_name
596: ||' p_pkey1_val : ' || p_pkey1_val

Line 614: po_debug.debug_stmt( p_log_head => g_log_head||l_api_name

610: END IF;
611:
612:
613: IF g_debug_stmt THEN
614: po_debug.debug_stmt( p_log_head => g_log_head||l_api_name
615: , p_token => l_progress
616: , p_message => ' Query to fetch the UDA template ID : ' || l_query
617: );
618:

Line 625: po_debug.debug_stmt( p_log_head => g_log_head||l_api_name

621: l_progress := '020';
622: EXECUTE IMMEDIATE l_query INTO l_template_id;
623:
624: IF g_debug_stmt THEN
625: po_debug.debug_stmt( p_log_head => g_log_head||l_api_name
626: , p_token => l_progress
627: , p_message => ' Template ID ' || l_template_id
628: );
629:

Line 633: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);

629:
630: END IF;
631:
632: IF g_debug_stmt THEN
633: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);
634: END IF;
635:
636: RETURN l_template_id;
637: EXCEPTION

Line 640: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);

636: RETURN l_template_id;
637: EXCEPTION
638: WHEN OTHERS THEN
639: IF g_debug_unexp THEN
640: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
641: END IF;
642: RETURN NULL;
643: END get_template_id;
644:

Line 677: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);

673: l_src_table_name VARCHAR2(200);
674: BEGIN
675:
676: IF g_debug_stmt THEN
677: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);
678: END IF;
679:
680: IF g_debug_stmt THEN
681: po_debug.debug_stmt( p_log_head => g_log_head||l_api_name

Line 681: po_debug.debug_stmt( p_log_head => g_log_head||l_api_name

677: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);
678: END IF;
679:
680: IF g_debug_stmt THEN
681: po_debug.debug_stmt( p_log_head => g_log_head||l_api_name
682: , p_token => l_progress
683: , p_message => ' p_doc_level : ' || p_doc_level
684: ||' p_doc_type : ' || p_doc_type
685: ||' p_intf_line_id : '|| p_intf_line_id

Line 790: po_debug.debug_stmt( p_log_head => g_log_head||l_api_name

786:
787: END IF;
788:
789: IF g_debug_stmt THEN
790: po_debug.debug_stmt( p_log_head => g_log_head||l_api_name
791: , p_token => l_progress
792: , p_message => ' Completed Initialization'
793: );
794:

Line 1039: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name

1035: END IF;
1036: END IF;
1037:
1038: IF g_debug_stmt THEN
1039: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name
1040: , p_token => l_progress
1041: , p_message => ' Completed Getting Primary Key Info'
1042: || x_pk1_col_name ||' : '|| x_pk1_value
1043: || x_pk2_col_name ||' : '|| x_pk2_value

Line 1082: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);

1078: END IF;
1079: END IF;
1080:
1081: IF g_debug_stmt THEN
1082: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);
1083: END IF;
1084:
1085: EXCEPTION
1086: WHEN OTHERS THEN

Line 1088: PO_DEBUG.debug_exc (p_log_head => g_log_head||l_api_name, p_progress => l_progress);

1084:
1085: EXCEPTION
1086: WHEN OTHERS THEN
1087: IF g_debug_unexp THEN
1088: PO_DEBUG.debug_exc (p_log_head => g_log_head||l_api_name, p_progress => l_progress);
1089: END IF;
1090: END get_src_primary_key;
1091:
1092: FUNCTION get_ag_id( p_ag_type IN VARCHAR2

Line 1106: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);

1102:
1103: BEGIN
1104:
1105: IF g_debug_stmt THEN
1106: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);
1107: END IF;
1108:
1109: IF g_debug_stmt THEN
1110: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name

Line 1110: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name

1106: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);
1107: END IF;
1108:
1109: IF g_debug_stmt THEN
1110: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name
1111: , p_token => l_progress
1112: , p_message => ' p_ag_type : ' || p_ag_type
1113: || ' p_attr_grp : '|| p_attr_grp );
1114: END IF;

Line 1125: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name

1121: WHERE ATTR_GROUP_TYPE = p_ag_type
1122: AND ATTR_GROUP_NAME = p_attr_grp;
1123:
1124: IF g_debug_stmt THEN
1125: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name
1126: , p_token => l_progress
1127: , p_message => ' Attribute ID : ' || l_attr_group_id);
1128: END IF;
1129:

Line 1136: PO_DEBUG.debug_exc (p_log_head => g_log_head||l_api_name, p_progress => l_progress);

1132:
1133:
1134: EXCEPTION WHEN OTHERS THEN
1135: IF g_debug_unexp THEN
1136: PO_DEBUG.debug_exc (p_log_head => g_log_head||l_api_name, p_progress => l_progress);
1137: END IF;
1138: RETURN NULL;
1139: END get_ag_id;
1140:

Line 1161: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);

1157: l_extension_id NUMBER;
1158:
1159: BEGIN
1160: IF g_debug_stmt THEN
1161: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);
1162: END IF;
1163:
1164: IF g_debug_stmt THEN
1165: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name

Line 1165: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name

1161: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);
1162: END IF;
1163:
1164: IF g_debug_stmt THEN
1165: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name
1166: , p_token => l_progress
1167: , p_message => ' p_ag_id : ' || p_ag_id
1168: ||' p_ext_table_name : '|| p_ext_table_name
1169: ||' p_pk1_col_name : ' || p_pk1_col_name

Line 1196: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

1192: l_query := l_query || ' AND '||p_pk2_col_name || ' = ' || p_pk2_value;
1193: END IF;
1194:
1195: IF g_debug_stmt THEN
1196: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
1197: p_token => l_progress,
1198: p_message => ' Sql to get the extension_id : '||l_query
1199: );
1200:

Line 1210: PO_DEBUG.debug_stmt (p_log_head => g_log_head||l_api_name,

1206: EXECUTE IMMEDIATE l_query INTO l_extension_id;
1207:
1208:
1209: IF g_debug_stmt THEN
1210: PO_DEBUG.debug_stmt (p_log_head => g_log_head||l_api_name,
1211: p_token => l_progress,
1212: p_message => ' Source Extension ID : '||l_extension_id
1213: );
1214:

Line 1221: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);

1217: RETURN l_extension_id;
1218:
1219:
1220: IF g_debug_stmt THEN
1221: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);
1222: END IF;
1223: EXCEPTION
1224: WHEN OTHERS THEN
1225: IF g_debug_unexp THEN

Line 1226: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);

1222: END IF;
1223: EXCEPTION
1224: WHEN OTHERS THEN
1225: IF g_debug_unexp THEN
1226: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
1227: END IF;
1228: RETURN NULL;
1229: END get_extension_id;
1230:

Line 1250: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);

1246: l_count NUMBER;
1247:
1248: BEGIN
1249: IF g_debug_stmt THEN
1250: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);
1251: END IF;
1252:
1253: IF g_debug_stmt THEN
1254: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name

Line 1254: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name

1250: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);
1251: END IF;
1252:
1253: IF g_debug_stmt THEN
1254: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name
1255: , p_token => l_progress
1256: , p_message => ' p_ag_id : ' || p_ag_id
1257: ||' p_ext_table_name : '|| p_ext_table_name
1258: ||' p_pk1_col_name : ' || p_pk1_col_name

Line 1290: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

1286: -- so that the value gets picked up as bind variables.
1287: END IF;
1288:
1289: IF g_debug_stmt THEN
1290: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
1291: p_token => l_progress,
1292: p_message => ' Sql to get Data Exists or not : '||l_query
1293: );
1294:

Line 1303: PO_DEBUG.debug_stmt (p_log_head => g_log_head||l_api_name,

1299: EXECUTE IMMEDIATE l_query INTO l_count;
1300:
1301:
1302: IF g_debug_stmt THEN
1303: PO_DEBUG.debug_stmt (p_log_head => g_log_head||l_api_name,
1304: p_token => l_progress,
1305: p_message => ' No of Rows : '||l_count
1306: );
1307:

Line 1317: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);

1313: END IF;
1314:
1315:
1316: IF g_debug_stmt THEN
1317: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);
1318: END IF;
1319: EXCEPTION
1320: WHEN OTHERS THEN
1321: IF g_debug_unexp THEN

Line 1322: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);

1318: END IF;
1319: EXCEPTION
1320: WHEN OTHERS THEN
1321: IF g_debug_unexp THEN
1322: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
1323: END IF;
1324: RETURN FALSE;
1325: END check_data_exists;
1326:

Line 1370: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);

1366:
1367: BEGIN
1368:
1369: IF g_debug_stmt THEN
1370: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);
1371: END IF;
1372:
1373:
1374: l_progress := '010';

Line 1383: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name

1379:
1380: FOR i IN 1.. p_priorities_tbl.Count
1381: LOOP
1382: IF g_debug_stmt THEN
1383: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name
1384: , p_token => l_progress
1385: , p_message => ' p_priorities_tbl(i) : ' || p_priorities_tbl(i)
1386: );
1387: END IF;

Line 1516: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name

1512: ,x_msg_data => x_msg_data
1513: );
1514:
1515: IF g_debug_stmt THEN
1516: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name
1517: , p_token => l_progress
1518: , p_message => ' After Calling PO_UDA_DATA_UTIL.AutoCreate_User_Attrs
1519: Return Status ' || x_return_status || ' Message Count :' || x_msg_count
1520: ||' Message Data: '|| x_msg_data

Line 1532: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);

1528: END IF;
1529: END LOOP;
1530:
1531: IF g_debug_stmt THEN
1532: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);
1533: END IF;
1534:
1535: EXCEPTION
1536: WHEN OTHERS THEN

Line 1538: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);

1534:
1535: EXCEPTION
1536: WHEN OTHERS THEN
1537: IF g_debug_unexp THEN
1538: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
1539: END IF;
1540: END autocreate_attr_group;
1541:
1542:

Line 1556: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);

1552:
1553: BEGIN
1554:
1555: IF g_debug_stmt THEN
1556: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);
1557: END IF;
1558:
1559: autocreate_attr_group (p_group_type => p_group_type
1560: ,p_group_property => p_group_property

Line 1572: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);

1568:
1569:
1570:
1571: IF g_debug_stmt THEN
1572: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);
1573: END IF;
1574:
1575:
1576: EXCEPTION

Line 1579: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);

1575:
1576: EXCEPTION
1577: WHEN OTHERS THEN
1578: IF g_debug_unexp THEN
1579: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
1580: END IF;
1581: END autocreate_ag_header;
1582:
1583:

Line 1619: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);

1615:
1616: BEGIN
1617:
1618: IF g_debug_stmt THEN
1619: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);
1620: END IF;
1621:
1622: FOR l_rec IN cur_lines
1623: LOOP

Line 1636: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);

1632: );
1633: END LOOP;
1634:
1635: IF g_debug_stmt THEN
1636: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);
1637: END IF;
1638:
1639: EXCEPTION
1640: WHEN OTHERS THEN

Line 1642: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);

1638:
1639: EXCEPTION
1640: WHEN OTHERS THEN
1641: IF g_debug_unexp THEN
1642: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
1643: END IF;
1644: END autocreate_ag_lines;
1645:
1646:

Line 1694: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);

1690:
1691: BEGIN
1692:
1693: IF g_debug_stmt THEN
1694: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);
1695: END IF;
1696:
1697: FOR l_rec IN cur_ship_lines
1698: LOOP

Line 1711: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);

1707: );
1708: END LOOP;
1709:
1710: IF g_debug_stmt THEN
1711: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);
1712: END IF;
1713:
1714: EXCEPTION
1715: WHEN OTHERS THEN

Line 1717: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);

1713:
1714: EXCEPTION
1715: WHEN OTHERS THEN
1716: IF g_debug_unexp THEN
1717: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
1718: END IF;
1719: END autocreate_ag_shipments;
1720:
1721:

Line 1736: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);

1732: l_progress VARCHAR2(3) := '000';
1733: BEGIN
1734:
1735: IF g_debug_stmt THEN
1736: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);
1737: END IF;
1738:
1739:
1740: IF p_doc_level = 'HEADER'

Line 1776: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);

1772: );
1773: END IF;
1774:
1775: IF g_debug_stmt THEN
1776: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);
1777: END IF;
1778:
1779:
1780: EXCEPTION

Line 1783: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);

1779:
1780: EXCEPTION
1781: WHEN OTHERS THEN
1782: IF g_debug_unexp THEN
1783: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
1784: END IF;
1785: END autocreate_ag_level;
1786:
1787: PROCEDURE auto_complexpricing_ag

Line 1845: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);

1841:
1842: BEGIN
1843:
1844: IF g_debug_stmt THEN
1845: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);
1846: END IF;
1847:
1848: l_progress := '020';
1849: l_target_template_id := get_uda_template_id

Line 1857: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name

1853: ,p_doc_style_id => g_target_doc_style
1854: );
1855:
1856: IF g_debug_stmt THEN
1857: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name
1858: ,p_token => l_progress
1859: ,p_message => 'Target Tempalte ID :' || l_target_template_id
1860: );
1861: END IF;

Line 1875: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name

1871: ,'LINE_NUMBER'
1872: ,l_src_rec.bid_line_number);
1873:
1874: IF g_debug_stmt THEN
1875: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name
1876: ,p_token => l_progress
1877: ,p_message => 'l_src_template_id' || l_src_template_id
1878: );
1879: END IF;

Line 1889: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name

1885: 'LINE_NUMBER', l_src_rec.bid_line_number
1886: )
1887: );
1888: IF g_debug_stmt THEN
1889: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name
1890: ,p_token => l_progress
1891: ,p_message => 'BID_NUMBER : ' || l_src_rec.bid_number || 'LINE NUMBER : ' || l_src_rec.bid_line_number
1892: );
1893: END IF;

Line 1909: po_debug.debug_var(p_log_head => g_log_head||l_api_name

1905: AND tu.template_id = l_src_template_id
1906: AND tu.attribute_category = 'PRICING';
1907:
1908: IF g_debug_stmt THEN
1909: po_debug.debug_var(p_log_head => g_log_head||l_api_name
1910: ,p_progress => l_progress
1911: ,p_name => 'l_attr_group_tbl'
1912: ,p_value => l_attr_group_tbl
1913: );

Line 1925: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name

1921: ,NULL,
1922: NULL);
1923:
1924: IF g_debug_stmt THEN
1925: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name
1926: ,p_token => l_progress
1927: ,p_message => 'l_src_template_id' || l_src_template_id
1928: );
1929: END IF;

Line 1938: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name

1934: l_src_rec.requisition_line_id
1935: )
1936: );
1937: IF g_debug_stmt THEN
1938: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name
1939: ,p_token => l_progress
1940: ,p_message => 'REQUISITION_LINE_ID : ' || l_src_rec.requisition_line_id
1941: );
1942: END IF;

Line 1957: po_debug.debug_var(p_log_head => g_log_head||l_api_name

1953: AND tu.template_id = l_src_template_id
1954: AND tu.attribute_category = 'PRICING';
1955:
1956: IF g_debug_stmt THEN
1957: po_debug.debug_var(p_log_head => g_log_head||l_api_name
1958: ,p_progress => l_progress
1959: ,p_name => 'l_attr_group_tbl'
1960: ,p_value => l_attr_group_tbl
1961: );

Line 1972: po_debug.debug_var(p_log_head => g_log_head||l_api_name

1968: FETCH cur_target_lines INTO l_to_pk1_value;
1969: CLOSE cur_target_lines;
1970:
1971: IF g_debug_stmt THEN
1972: po_debug.debug_var(p_log_head => g_log_head||l_api_name
1973: ,p_progress => l_progress
1974: ,p_name => 'l_to_pk1_value'
1975: ,p_value => l_to_pk1_value
1976: );

Line 2006: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name

2002: ,x_msg_count => x_msg_count
2003: ,x_msg_data => x_msg_data
2004: );
2005: IF g_debug_stmt THEN
2006: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name
2007: , p_token => l_progress
2008: , p_message => ' After Calling PO_UDA_DATA_UTIL.AutoCreate_User_Attrs
2009: Return Status ' || x_return_status || ' Message Count :' || x_msg_count
2010: ||' Message Data: '|| x_msg_data

Line 2027: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);

2023: END IF;
2024: END LOOP;
2025:
2026: IF g_debug_stmt THEN
2027: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);
2028: END IF;
2029:
2030: EXCEPTION
2031: WHEN OTHERS THEN

Line 2033: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);

2029:
2030: EXCEPTION
2031: WHEN OTHERS THEN
2032: IF g_debug_unexp THEN
2033: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
2034: END IF;
2035: RAISE;
2036: END auto_complexpricing_ag;
2037:

Line 2114: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);

2110: BEGIN
2111:
2112:
2113: IF g_debug_stmt THEN
2114: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);
2115: END IF;
2116:
2117: IF g_debug_stmt THEN
2118: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name

Line 2118: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name

2114: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);
2115: END IF;
2116:
2117: IF g_debug_stmt THEN
2118: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name
2119: ,p_token => l_progress
2120: , p_message => ' p_address_type : ' || p_address_type
2121: );
2122: END IF;

Line 2156: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name

2152: l_attr_grp_ids_list := l_po_uda_usage_object.Attr_group_Id;
2153: l_attr_group_id := l_attr_grp_ids_list(1);
2154:
2155: IF g_debug_stmt THEN
2156: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name
2157: ,p_token => l_progress
2158: ,p_message => ' l_attr_group_id : ' || l_attr_group_id
2159: );
2160: END IF;

Line 2176: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name

2172: FETCH cur_address INTO l_address;
2173: CLOSE cur_address;
2174:
2175: IF g_debug_stmt THEN
2176: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name
2177: ,p_token => l_progress
2178: ,p_message => ' l_address : ' || l_address
2179: );
2180: END IF;

Line 2261: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name

2257: ,x_msg_data => x_msg_data
2258: );
2259:
2260: IF g_debug_stmt THEN
2261: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name
2262: ,p_token => l_progress
2263: ,p_message => ' Call to EXECUTE_IMPORT_UDA_FUNCTION : x_return_status '
2264: || x_return_status
2265: );

Line 2269: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name

2265: );
2266: END IF;
2267:
2268: IF g_debug_stmt THEN
2269: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name
2270: ,p_token => l_progress
2271: ,p_message => ' l_attr_name_value_pairs.count '
2272: || l_attr_name_value_pairs. Count
2273: ||' l_attributes_row_table '

Line 2300: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name

2296: END IF;
2297:
2298:
2299: IF g_debug_stmt THEN
2300: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name
2301: , p_token => l_progress
2302: , p_message => ' After Calling ego_user_attrs_data_pvt.process_user_attrs_data
2303: Return Status ' || x_return_status || ' Message Count :' || x_msg_count
2304: ||' Message Data: '|| x_msg_data || ' Error Code : '|| x_errorcode

Line 2329: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);

2325: x_return_status := 'F' ;
2326: END IF;
2327:
2328: IF g_debug_stmt THEN
2329: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);
2330: END IF;
2331:
2332: EXCEPTION
2333: WHEN OTHERS THEN

Line 2335: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);

2331:
2332: EXCEPTION
2333: WHEN OTHERS THEN
2334: IF g_debug_unexp THEN
2335: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
2336: RAISE;
2337: END IF;
2338: END auto_default_sys_addresses;
2339:

Line 2395: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);

2391:
2392: BEGIN
2393:
2394: IF g_debug_stmt THEN
2395: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);
2396: END IF;
2397:
2398: IF g_debug_stmt THEN
2399: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name

Line 2399: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name

2395: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);
2396: END IF;
2397:
2398: IF g_debug_stmt THEN
2399: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name
2400: ,p_token => l_progress
2401: ,p_message => ' p_ag_type ' || p_ag_type
2402: ||' p_attr_group_id ' || p_attr_group_id
2403: ||' p_extension_id ' || p_extension_id

Line 2415: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name

2411: WHERE attr_group_type = p_ag_type
2412: AND data_level_name NOT LIKE '%ARCHIVE%';
2413:
2414: IF g_debug_stmt THEN
2415: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name
2416: ,p_token => l_progress
2417: ,p_message => ' l_src_data_level ' || l_src_data_level
2418: );
2419: END IF;

Line 2433: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name

2429: END IF;
2430: END LOOP;
2431:
2432: IF g_debug_stmt THEN
2433: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name
2434: ,p_token => l_progress
2435: ,p_message => ' l_attr_list ' || l_attr_list
2436: );
2437: END IF;

Line 2476: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name

2472: );
2473:
2474: IF g_debug_stmt
2475: THEN
2476: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name
2477: , p_token => l_progress
2478: , p_message => ' After Calling ego_user_attrs_data_pvt.get_user_attrs_data
2479: Return Status ' || x_return_status || ' Message Count :' || x_msg_count
2480: ||' Message Data: '|| x_msg_data || ' Error Code : '|| x_errorcode

Line 2537: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name

2533: ,x_msg_data => x_msg_data
2534: );
2535: IF g_debug_stmt
2536: THEN
2537: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name
2538: , p_token => l_progress
2539: , p_message => ' After Calling ego_user_attrs_data_pvt.get_user_attrs_data
2540: Return Status ' || x_return_status || ' Message Count :' || x_msg_count
2541: ||' Message Data: '|| x_msg_data || ' Error Code : '|| x_errorcode

Line 2548: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);

2544:
2545: END IF;
2546:
2547: IF g_debug_stmt THEN
2548: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);
2549: END IF;
2550: EXCEPTION
2551: WHEN OTHERS THEN
2552: IF g_debug_unexp THEN

Line 2553: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);

2549: END IF;
2550: EXCEPTION
2551: WHEN OTHERS THEN
2552: IF g_debug_unexp THEN
2553: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
2554: RAISE;
2555: END IF;
2556:
2557: END process_addresses;

Line 2571: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);

2567:
2568: BEGIN
2569:
2570: IF g_debug_stmt THEN
2571: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);
2572: END IF;
2573:
2574: IF g_debug_stmt THEN
2575: PO_DEBUG.debug_stmt (p_log_head => g_log_head||l_api_name,

Line 2575: PO_DEBUG.debug_stmt (p_log_head => g_log_head||l_api_name,

2571: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);
2572: END IF;
2573:
2574: IF g_debug_stmt THEN
2575: PO_DEBUG.debug_stmt (p_log_head => g_log_head||l_api_name,
2576: p_token => l_progress,
2577: p_message => ' p_level : '|| p_level
2578: );
2579: END IF;

Line 2695: PO_DEBUG.debug_stmt (p_log_head => g_log_head||l_api_name,

2691: END IF;
2692: --bug 13640946 end
2693:
2694: IF g_debug_stmt THEN
2695: PO_DEBUG.debug_stmt (p_log_head => g_log_head||l_api_name,
2696: p_token => l_progress,
2697: p_message => ' x_attr_group_id_tbl.count '|| x_attr_group_id_tbl.count
2698: );
2699: END IF;

Line 2703: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);

2699: END IF;
2700:
2701:
2702: IF g_debug_stmt THEN
2703: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);
2704: END IF;
2705:
2706: EXCEPTION
2707: WHEN OTHERS THEN

Line 2709: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);

2705:
2706: EXCEPTION
2707: WHEN OTHERS THEN
2708: IF g_debug_unexp THEN
2709: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
2710: END IF;
2711: END get_group_id_tbl;
2712: /*bug 12611018 ends*/
2713:

Line 2755: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);

2751:
2752: BEGIN
2753:
2754: IF g_debug_stmt THEN
2755: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);
2756: END IF;
2757:
2758: l_progress := '010';
2759:

Line 2822: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);

2818: END LOOP;
2819: END IF;
2820:
2821: IF g_debug_stmt THEN
2822: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);
2823: END IF;
2824:
2825: EXCEPTION
2826: WHEN OTHERS THEN

Line 2828: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);

2824:
2825: EXCEPTION
2826: WHEN OTHERS THEN
2827: IF g_debug_unexp THEN
2828: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
2829: END IF;
2830: END autocreate_uda_postprocess;
2831:
2832:

Line 2885: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);

2881: RETURN;
2882: END IF; */
2883:
2884: IF g_debug_stmt THEN
2885: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);
2886: END IF;
2887:
2888: IF g_debug_stmt THEN
2889: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name

Line 2889: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name

2885: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);
2886: END IF;
2887:
2888: IF g_debug_stmt THEN
2889: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name
2890: ,p_token => l_progress
2891: ,p_message =>' p_template_id ' || p_template_id
2892: ||' p_pk1_col_name ' || p_pk1_col_name
2893: ||' p_pk1_col_value ' || p_pk1_col_value

Line 2897: po_debug.debug_var(p_log_head => g_log_head||l_api_name

2893: ||' p_pk1_col_value ' || p_pk1_col_value
2894: ||' p_pk1_col2_name ' || p_pk2_col_name
2895: ||' p_pk2_col2_value ' || p_pk2_col_value);
2896:
2897: po_debug.debug_var(p_log_head => g_log_head||l_api_name
2898: ,p_progress => l_progress
2899: ,p_name => 'p_attr_group_id_tbl'
2900: ,p_value => p_attr_group_id_tbl
2901: );

Line 2920: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name

2916: FROM po_uda_ag_templates
2917: WHERE template_id = p_template_id;
2918:
2919: IF g_debug_stmt THEN
2920: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name
2921: ,p_token => l_progress
2922: ,p_message => ' l_entity_code : ' || l_entity_code
2923: );
2924: END IF;

Line 2934: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name

2930: WHERE attr_group_type = l_entity_code
2931: AND data_level_name NOT LIKE '%ARCHIVE%';
2932:
2933: IF g_debug_stmt THEN
2934: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name
2935: ,p_token => l_progress
2936: ,p_message => ' l_data_level : ' || l_data_level
2937: ||' l_entity_code : ' || l_entity_code
2938:

Line 2957: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name

2953: WHERE ATTR_GROUP_TYPE = l_entity_code
2954: AND attr_group_id = p_attr_group_id_tbl(i);
2955:
2956: IF g_debug_stmt THEN
2957: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name
2958: ,p_token => l_progress
2959: ,p_message => ' l_attr_group_name : '|| l_attr_group_name
2960: );
2961: END IF;

Line 2975: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name

2971: END IF;
2972: END LOOP;
2973:
2974: IF g_debug_stmt THEN
2975: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name
2976: ,p_token => l_progress
2977: ,p_message => ' l_attr_list : ' || l_attr_list
2978: );
2979: END IF;

Line 3019: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name

3015: );
3016:
3017: IF g_debug_stmt
3018: THEN
3019: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name
3020: , p_token => l_progress
3021: , p_message => ' After Calling ego_user_attrs_data_pvt.get_user_attrs_data
3022: Return Status ' || x_return_status || ' Message Count :' || x_msg_count
3023: ||' Message Data: '|| x_msg_data || ' Error Code : '|| x_errorcode

Line 3051: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name

3047: ,x_msg_data => x_msg_data
3048: );
3049: IF g_debug_stmt
3050: THEN
3051: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name
3052: , p_token => l_progress
3053: , p_message => ' After Calling po_uda_import_pkg.execute_import_uda_function
3054: Return Status ' || x_return_status || ' Message Count :' || x_msg_count
3055: ||' Message Data: '|| x_msg_data || ' Error Code : '|| x_errorcode

Line 3062: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);

3058: END IF;
3059:
3060:
3061: IF g_debug_stmt THEN
3062: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);
3063: END IF;
3064:
3065: EXCEPTION
3066: WHEN OTHERS THEN

Line 3068: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);

3064:
3065: EXCEPTION
3066: WHEN OTHERS THEN
3067: IF g_debug_unexp THEN
3068: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
3069: END IF;
3070: END exec_uda_function;
3071:
3072: PROCEDURE init_info

Line 3092: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);

3088: -- PO_AUTOCREATE_PARAMS.g_document_subtype in ('STANDARD', 'PLANNED', 'RELEASE'))
3089:
3090:
3091: IF g_debug_stmt THEN
3092: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);
3093: END IF;
3094:
3095: l_progress := '010';
3096: SELECT interface_source_code, document_type_code, document_subtype, style_id

Line 3148: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);

3144: );
3145:
3146:
3147: IF g_debug_stmt THEN
3148: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);
3149: END IF;
3150:
3151: EXCEPTION
3152: WHEN OTHERS THEN

Line 3154: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);

3150:
3151: EXCEPTION
3152: WHEN OTHERS THEN
3153: IF g_debug_unexp THEN
3154: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
3155: RAISE;
3156: END IF;
3157: END init_info;
3158:

Line 3215: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);

3211:
3212: BEGIN
3213:
3214: IF g_debug_stmt THEN
3215: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);
3216: END IF;
3217:
3218: -- If we know the interface header id we can find out whether the call is
3219: -- from sourcing or PO BWC and also we can find out the target document style

Line 3357: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);

3353: l_progress :='070';
3354:
3355:
3356: IF g_debug_stmt THEN
3357: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);
3358: END IF;
3359:
3360: EXCEPTION
3361: WHEN OTHERS THEN

Line 3363: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);

3359:
3360: EXCEPTION
3361: WHEN OTHERS THEN
3362: IF g_debug_unexp THEN
3363: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
3364: END IF;
3365: END autocreate_uda_data;
3366:
3367: /* Bug 9879573 and 12611018 Start

Line 3417: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name

3413: );
3414:
3415:
3416: IF g_debug_stmt THEN
3417: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name
3418: , p_token => l_progress
3419: , p_message => 'x_src_template_id :'||x_src_template_id
3420: );
3421: END IF;

Line 3446: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name

3442: FROM PO_UDA_AG_TEMPLATES
3443: WHERE TEMPLATE_ID = x_src_template_id;
3444:
3445: IF g_debug_stmt THEN
3446: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name
3447: , p_token => l_progress
3448: , p_message => 'l_attr_group_Type :'||l_attr_group_Type
3449: );
3450: END IF;

Line 3469: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);

3465:
3466: EXCEPTION
3467: WHEN OTHERS THEN
3468: IF g_debug_unexp THEN
3469: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
3470: END IF;
3471:
3472: END;
3473:

Line 3481: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name

3477: )
3478: );
3479:
3480: IF g_debug_stmt THEN
3481: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name
3482: , p_token => l_progress
3483: , p_message => 'l_object.object_id : '||l_object_id ||
3484: 'l_object_dff_cr.l_object_name' ||l_object_dff_cr.l_object_name ||
3485: 'l_main_data_level.data_level_id'||l_main_data_level_id