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.OE_FND_ATTACHMENTS_PVT dependencies on OE_DEBUG_PUB

Line 80: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

76: l_pk3_Column fnd_document_entities.pk3_column%TYPE;
77: l_pk4_Column fnd_document_entities.pk4_column%TYPE;
78: l_pk5_Column fnd_document_entities.pk5_column%TYPE;
79: --
80: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
81: --
82: BEGIN
83: IF l_debug_level > 0 THEN
84: oe_debug_pub.add( 'ENTER FETCH_ATTRIBUTE_VALUES' , 1 ) ;

Line 84: oe_debug_pub.add( 'ENTER FETCH_ATTRIBUTE_VALUES' , 1 ) ;

80: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
81: --
82: BEGIN
83: IF l_debug_level > 0 THEN
84: oe_debug_pub.add( 'ENTER FETCH_ATTRIBUTE_VALUES' , 1 ) ;
85: END IF;
86:
87: SELECT table_name, pk1_column, pk2_column
88: , pk3_column, pk4_column, pk5_column

Line 101: oe_debug_pub.add( 'CACHING ATTACHMENT ATTRIBUTES' , 1 ) ;

97:
98: IF g_cached_attributes = 'N' THEN
99: --cache header and line entities
100: IF l_debug_level > 0 THEN
101: oe_debug_pub.add( 'CACHING ATTACHMENT ATTRIBUTES' , 1 ) ;
102: END IF;
103: l_dummy := 1;
104:
105: LOOP -- loop twice: once for header, once for lines

Line 112: oe_debug_pub.add( 'BUILDING SQL TO SELECT COLUMNS FROM ENTITY' , 1 ) ;

108: l_attribute_tbl.delete;
109: END IF;
110:
111: IF l_debug_level > 0 THEN
112: oe_debug_pub.add( 'BUILDING SQL TO SELECT COLUMNS FROM ENTITY' , 1 ) ;
113: END IF;
114: l_index := 1;
115:
116: -- select columns that have attachments_enabled_flag = 'Y'

Line 162: oe_debug_pub.add( 'USING HEADER ATTRIBUTES CACHE' , 1 ) ;

158: END IF; --attributes aren't cached
159:
160: IF p_database_object_name = 'OE_AK_ORDER_HEADERS_V' THEN
161: IF l_debug_level > 0 THEN
162: oe_debug_pub.add( 'USING HEADER ATTRIBUTES CACHE' , 1 ) ;
163: END IF;
164: l_entity_sql := g_hdr_entity_sql;
165: l_attribute_tbl := g_hdr_attribute_tbl;
166: ELSE

Line 168: oe_debug_pub.add( 'USING LINE ATTRIBUTES CACHE' , 1 ) ;

164: l_entity_sql := g_hdr_entity_sql;
165: l_attribute_tbl := g_hdr_attribute_tbl;
166: ELSE
167: IF l_debug_level > 0 THEN
168: oe_debug_pub.add( 'USING LINE ATTRIBUTES CACHE' , 1 ) ;
169: END IF;
170: l_entity_sql := g_lin_entity_sql;
171: l_attribute_tbl := g_lin_attribute_tbl;
172: END IF;

Line 203: oe_debug_pub.add( 'FINAL SQL TO RETRIEVE ENTITY REFERENCE : ' ) ;

199: l_entity_sql := l_entity_sql || ' OR ' || l_pk5_column || ' = :p_pk5_value) ';
200: end if;
201:
202: IF l_debug_level > 0 THEN
203: oe_debug_pub.add( 'FINAL SQL TO RETRIEVE ENTITY REFERENCE : ' ) ;
204: END IF;
205: IF l_debug_level > 0 THEN
206: oe_debug_pub.add( L_ENTITY_SQL ) ;
207: END IF;

Line 206: oe_debug_pub.add( L_ENTITY_SQL ) ;

202: IF l_debug_level > 0 THEN
203: oe_debug_pub.add( 'FINAL SQL TO RETRIEVE ENTITY REFERENCE : ' ) ;
204: END IF;
205: IF l_debug_level > 0 THEN
206: oe_debug_pub.add( L_ENTITY_SQL ) ;
207: END IF;
208:
209:
210: -------------------------------------------------------------------

Line 215: oe_debug_pub.add( 'FETCH_ATTRIBUTE_VALUES:CURSOR OPEN OK' ) ;

211: -- CREATE DYNAMIC SQL CURSOR AND EXECUTE
212: -------------------------------------------------------------------
213: l_sqlCursor := DBMS_SQL.open_cursor;
214: IF l_debug_level > 0 THEN
215: oe_debug_pub.add( 'FETCH_ATTRIBUTE_VALUES:CURSOR OPEN OK' ) ;
216: END IF;
217:
218: DBMS_SQL.parse(l_sqlCursor, l_entity_sql, DBMS_SQL.NATIVE);
219:

Line 236: oe_debug_pub.add( 'DEFINING COLUMN FOR ATTRIBUTE: '|| L_ATTRIBUTE_TBL ( L_INDEX ) .ATTRIBUTE_CODE ) ;

232: end if;
233:
234: for l_index in 1..l_attribute_tbl.COUNT loop
235: IF l_debug_level > 0 THEN
236: oe_debug_pub.add( 'DEFINING COLUMN FOR ATTRIBUTE: '|| L_ATTRIBUTE_TBL ( L_INDEX ) .ATTRIBUTE_CODE ) ;
237: END IF;
238: DBMS_SQL.define_column(l_sqlCursor, l_index, l_attribute_tbl(l_index).value, 50);
239: end loop;
240:

Line 243: oe_debug_pub.add( 'FETCH_ATTRIBUTE_VALUES:EXECUTE OK' ) ;

239: end loop;
240:
241: l_dummy := DBMS_SQL.execute(l_sqlCursor);
242: IF l_debug_level > 0 THEN
243: oe_debug_pub.add( 'FETCH_ATTRIBUTE_VALUES:EXECUTE OK' ) ;
244: END IF;
245:
246:
247: -------------------------------------------------------------------

Line 253: oe_debug_pub.add( 'FETCH_ATTRIBUTE_VALUES:FETCH_ROWS OK' ) ;

249: -------------------------------------------------------------------
250:
251: if (DBMS_SQL.fetch_rows(l_sqlCursor) <> 0) then
252: IF l_debug_level > 0 THEN
253: oe_debug_pub.add( 'FETCH_ATTRIBUTE_VALUES:FETCH_ROWS OK' ) ;
254: END IF;
255: for l_index in 1..l_attribute_tbl.COUNT loop
256: DBMS_SQL.column_value(l_sqlcursor, l_index, l_attribute_tbl(l_index).value);
257: IF l_debug_level > 0 THEN

Line 258: oe_debug_pub.add( 'ATTRIBUTE VALUE: '||L_ATTRIBUTE_TBL ( L_INDEX ) .VALUE ) ;

254: END IF;
255: for l_index in 1..l_attribute_tbl.COUNT loop
256: DBMS_SQL.column_value(l_sqlcursor, l_index, l_attribute_tbl(l_index).value);
257: IF l_debug_level > 0 THEN
258: oe_debug_pub.add( 'ATTRIBUTE VALUE: '||L_ATTRIBUTE_TBL ( L_INDEX ) .VALUE ) ;
259: END IF;
260: end loop;
261: else
262: raise no_data_found;

Line 267: oe_debug_pub.add( 'EXIT FETCH_ATTRIBUTE_VALUES' , 1 ) ;

263: end if;
264: DBMS_SQL.close_cursor(l_sqlCursor);
265:
266: IF l_debug_level > 0 THEN
267: oe_debug_pub.add( 'EXIT FETCH_ATTRIBUTE_VALUES' , 1 ) ;
268: END IF;
269:
270: RETURN l_attribute_tbl;
271:

Line 299: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

295: ';
296: l_first_value BOOLEAN;
297: l_rows NUMBER;
298: --
299: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
300: --
301: BEGIN
302:
303: IF l_debug_level > 0 THEN

Line 304: oe_debug_pub.add( 'ENTER FETCH_DOCUMENTS' , 1 ) ;

300: --
301: BEGIN
302:
303: IF l_debug_level > 0 THEN
304: oe_debug_pub.add( 'ENTER FETCH_DOCUMENTS' , 1 ) ;
305: END IF;
306:
307: -------------------------------------------------------------------
308: -- CONSTRUCT THE SQL STATEMENT

Line 380: oe_debug_pub.add( 'FINISHED BUILDING RULES SQL:' ) ;

376: l_rule_sql := l_rule_sql||l_newline
377: ||' ) )';
378:
379: IF l_debug_level > 0 THEN
380: oe_debug_pub.add( 'FINISHED BUILDING RULES SQL:' ) ;
381: END IF;
382: IF l_debug_level > 0 THEN
383: oe_debug_pub.add( L_RULE_SQL ) ;
384: END IF;

Line 383: oe_debug_pub.add( L_RULE_SQL ) ;

379: IF l_debug_level > 0 THEN
380: oe_debug_pub.add( 'FINISHED BUILDING RULES SQL:' ) ;
381: END IF;
382: IF l_debug_level > 0 THEN
383: oe_debug_pub.add( L_RULE_SQL ) ;
384: END IF;
385:
386: -------------------------------------------------------------------
387: -- CREATE DYNAMIC SQL CURSOR AND EXECUTE

Line 391: oe_debug_pub.add( 'FETCH_DOCUMENTS:CURSOR OPEN OK' ) ;

387: -- CREATE DYNAMIC SQL CURSOR AND EXECUTE
388: -------------------------------------------------------------------
389: l_sqlCursor := DBMS_SQL.open_cursor;
390: IF l_debug_level > 0 THEN
391: oe_debug_pub.add( 'FETCH_DOCUMENTS:CURSOR OPEN OK' ) ;
392: END IF;
393:
394: DBMS_SQL.parse(l_sqlCursor, l_rule_sql, DBMS_SQL.NATIVE);
395:

Line 406: oe_debug_pub.add( 'FETCH_DOCUMENTS:EXECUTE OK' ) ;

402: DBMS_SQL.define_column(l_sqlCursor, 1, l_document_id);
403:
404: l_dummy := DBMS_SQL.execute(l_sqlCursor);
405: IF l_debug_level > 0 THEN
406: oe_debug_pub.add( 'FETCH_DOCUMENTS:EXECUTE OK' ) ;
407: END IF;
408:
409:
410: -------------------------------------------------------------------

Line 417: oe_debug_pub.add( 'FETCH_DOCUMENTS:FETCH_ROWS OK' ) ;

413:
414: l_index := 1;
415: while (DBMS_SQL.fetch_rows(l_sqlCursor)<> 0) loop
416: IF l_debug_level > 0 THEN
417: oe_debug_pub.add( 'FETCH_DOCUMENTS:FETCH_ROWS OK' ) ;
418: END IF;
419: DBMS_SQL.column_value(l_sqlcursor, 1, l_document_id);
420: IF l_debug_level > 0 THEN
421: oe_debug_pub.add( 'DOCUMENT ID:'||L_DOCUMENT_ID ) ;

Line 421: oe_debug_pub.add( 'DOCUMENT ID:'||L_DOCUMENT_ID ) ;

417: oe_debug_pub.add( 'FETCH_DOCUMENTS:FETCH_ROWS OK' ) ;
418: END IF;
419: DBMS_SQL.column_value(l_sqlcursor, 1, l_document_id);
420: IF l_debug_level > 0 THEN
421: oe_debug_pub.add( 'DOCUMENT ID:'||L_DOCUMENT_ID ) ;
422: END IF;
423: l_document_tbl(l_index).document_id := l_document_id;
424: l_index := l_index+1;
425: end loop;

Line 429: oe_debug_pub.add( 'EXIT FETCH_DOCUMENTS' , 1 ) ;

425: end loop;
426: DBMS_SQL.close_cursor(l_sqlCursor);
427:
428: IF l_debug_level > 0 THEN
429: oe_debug_pub.add( 'EXIT FETCH_DOCUMENTS' , 1 ) ;
430: END IF;
431:
432: RETURN l_document_tbl;
433:

Line 472: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

468: i number;
469: l_attachment_exist number:=0;
470: l_need_delete_insert BOOLEAN :=TRUE;
471: --
472: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
473: --
474: BEGIN
475: IF l_debug_level > 0 THEN
476: oe_debug_pub.add( 'ENTER OE_FND_ATTACHMENTS_PVT.ADD_ATTACHMENTS_AUTOMATIC' , 1 ) ;

Line 476: oe_debug_pub.add( 'ENTER OE_FND_ATTACHMENTS_PVT.ADD_ATTACHMENTS_AUTOMATIC' , 1 ) ;

472: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
473: --
474: BEGIN
475: IF l_debug_level > 0 THEN
476: oe_debug_pub.add( 'ENTER OE_FND_ATTACHMENTS_PVT.ADD_ATTACHMENTS_AUTOMATIC' , 1 ) ;
477: END IF;
478:
479: -- Initialize API return status to success
480: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 497: oe_debug_pub.add( 'GET DATABASE_OBJECT_NAME' , 1 ) ;

493:
494: x_attachment_count := 0;
495:
496: IF l_debug_level > 0 THEN
497: oe_debug_pub.add( 'GET DATABASE_OBJECT_NAME' , 1 ) ;
498: END IF;
499:
500: SELECT database_object_name
501: INTO l_database_object_name

Line 531: oe_debug_pub.add( 'COUNT OF DOCUMENTS :'||L_DOCUMENTTBL.COUNT ||'FIRST ELEMENT: '||L_DOCUMENTTBL.FIRST ) ;

527: ,p_attribute_tbl => l_attribute_tbl
528: );
529:
530: IF l_debug_level > 0 THEN
531: oe_debug_pub.add( 'COUNT OF DOCUMENTS :'||L_DOCUMENTTBL.COUNT ||'FIRST ELEMENT: '||L_DOCUMENTTBL.FIRST ) ;
532: END IF;
533:
534:
535: ---------------------------------------------------------------------

Line 540: oe_debug_pub.add( 'DELETING EXISTING AUTOMATIC ATTACHMENTS' ) ;

536: -- DELETE EXISTING AUTOMATIC ATTACHMENTS
537: ---------------------------------------------------------------------
538:
539: IF l_debug_level > 0 THEN
540: oe_debug_pub.add( 'DELETING EXISTING AUTOMATIC ATTACHMENTS' ) ;
541: END IF;
542: /* Check if the same attachment is already there */
543:
544: /*6896311

Line 559: oe_debug_pub.add( 'ATTACHMENTS EXIST DO NOT DELETE IT' ) ;

555:
556: if l_attachment_exist > 0 THEN
557: l_need_delete_insert := FALSE;
558: IF l_debug_level > 0 THEN
559: oe_debug_pub.add( 'ATTACHMENTS EXIST DO NOT DELETE IT' ) ;
560: oe_debug_pub.add( 'entity Name :'|| p_entity_name,1);
561: oe_debug_pub.add( 'x_pk1_value:'|| p_pk1_value,1);
562: oe_debug_pub.add( 'x_pk2_value:'|| p_pk2_value,1);
563: oe_debug_pub.add( 'x_pk3_value:'|| p_pk3_value,1);

Line 560: oe_debug_pub.add( 'entity Name :'|| p_entity_name,1);

556: if l_attachment_exist > 0 THEN
557: l_need_delete_insert := FALSE;
558: IF l_debug_level > 0 THEN
559: oe_debug_pub.add( 'ATTACHMENTS EXIST DO NOT DELETE IT' ) ;
560: oe_debug_pub.add( 'entity Name :'|| p_entity_name,1);
561: oe_debug_pub.add( 'x_pk1_value:'|| p_pk1_value,1);
562: oe_debug_pub.add( 'x_pk2_value:'|| p_pk2_value,1);
563: oe_debug_pub.add( 'x_pk3_value:'|| p_pk3_value,1);
564: oe_debug_pub.add( ' x_pk4_value:'|| p_pk4_value,1);

Line 561: oe_debug_pub.add( 'x_pk1_value:'|| p_pk1_value,1);

557: l_need_delete_insert := FALSE;
558: IF l_debug_level > 0 THEN
559: oe_debug_pub.add( 'ATTACHMENTS EXIST DO NOT DELETE IT' ) ;
560: oe_debug_pub.add( 'entity Name :'|| p_entity_name,1);
561: oe_debug_pub.add( 'x_pk1_value:'|| p_pk1_value,1);
562: oe_debug_pub.add( 'x_pk2_value:'|| p_pk2_value,1);
563: oe_debug_pub.add( 'x_pk3_value:'|| p_pk3_value,1);
564: oe_debug_pub.add( ' x_pk4_value:'|| p_pk4_value,1);
565: oe_debug_pub.add( 'x_pk5_value:'|| p_pk5_value,1);

Line 562: oe_debug_pub.add( 'x_pk2_value:'|| p_pk2_value,1);

558: IF l_debug_level > 0 THEN
559: oe_debug_pub.add( 'ATTACHMENTS EXIST DO NOT DELETE IT' ) ;
560: oe_debug_pub.add( 'entity Name :'|| p_entity_name,1);
561: oe_debug_pub.add( 'x_pk1_value:'|| p_pk1_value,1);
562: oe_debug_pub.add( 'x_pk2_value:'|| p_pk2_value,1);
563: oe_debug_pub.add( 'x_pk3_value:'|| p_pk3_value,1);
564: oe_debug_pub.add( ' x_pk4_value:'|| p_pk4_value,1);
565: oe_debug_pub.add( 'x_pk5_value:'|| p_pk5_value,1);
566: END IF;

Line 563: oe_debug_pub.add( 'x_pk3_value:'|| p_pk3_value,1);

559: oe_debug_pub.add( 'ATTACHMENTS EXIST DO NOT DELETE IT' ) ;
560: oe_debug_pub.add( 'entity Name :'|| p_entity_name,1);
561: oe_debug_pub.add( 'x_pk1_value:'|| p_pk1_value,1);
562: oe_debug_pub.add( 'x_pk2_value:'|| p_pk2_value,1);
563: oe_debug_pub.add( 'x_pk3_value:'|| p_pk3_value,1);
564: oe_debug_pub.add( ' x_pk4_value:'|| p_pk4_value,1);
565: oe_debug_pub.add( 'x_pk5_value:'|| p_pk5_value,1);
566: END IF;
567: else

Line 564: oe_debug_pub.add( ' x_pk4_value:'|| p_pk4_value,1);

560: oe_debug_pub.add( 'entity Name :'|| p_entity_name,1);
561: oe_debug_pub.add( 'x_pk1_value:'|| p_pk1_value,1);
562: oe_debug_pub.add( 'x_pk2_value:'|| p_pk2_value,1);
563: oe_debug_pub.add( 'x_pk3_value:'|| p_pk3_value,1);
564: oe_debug_pub.add( ' x_pk4_value:'|| p_pk4_value,1);
565: oe_debug_pub.add( 'x_pk5_value:'|| p_pk5_value,1);
566: END IF;
567: else
568: l_need_delete_insert := TRUE;

Line 565: oe_debug_pub.add( 'x_pk5_value:'|| p_pk5_value,1);

561: oe_debug_pub.add( 'x_pk1_value:'|| p_pk1_value,1);
562: oe_debug_pub.add( 'x_pk2_value:'|| p_pk2_value,1);
563: oe_debug_pub.add( 'x_pk3_value:'|| p_pk3_value,1);
564: oe_debug_pub.add( ' x_pk4_value:'|| p_pk4_value,1);
565: oe_debug_pub.add( 'x_pk5_value:'|| p_pk5_value,1);
566: END IF;
567: else
568: l_need_delete_insert := TRUE;
569: IF l_debug_level > 0 THEN

Line 570: oe_debug_pub.add( 'ATTACHMENTS DO NOT EXIST DELETE IF THERE IS

566: END IF;
567: else
568: l_need_delete_insert := TRUE;
569: IF l_debug_level > 0 THEN
570: oe_debug_pub.add( 'ATTACHMENTS DO NOT EXIST DELETE IF THERE IS
571: ANY' ) ;
572: oe_debug_pub.add( 'entity Name :'|| p_entity_name,1);
573: oe_debug_pub.add( 'x_pk1_value:'|| p_pk1_value,1);
574: oe_debug_pub.add( 'x_pk2_value:'|| p_pk2_value,1);

Line 572: oe_debug_pub.add( 'entity Name :'|| p_entity_name,1);

568: l_need_delete_insert := TRUE;
569: IF l_debug_level > 0 THEN
570: oe_debug_pub.add( 'ATTACHMENTS DO NOT EXIST DELETE IF THERE IS
571: ANY' ) ;
572: oe_debug_pub.add( 'entity Name :'|| p_entity_name,1);
573: oe_debug_pub.add( 'x_pk1_value:'|| p_pk1_value,1);
574: oe_debug_pub.add( 'x_pk2_value:'|| p_pk2_value,1);
575: oe_debug_pub.add( 'x_pk3_value:'|| p_pk3_value,1);
576: oe_debug_pub.add( 'x_pk4_value:'|| p_pk4_value,1);

Line 573: oe_debug_pub.add( 'x_pk1_value:'|| p_pk1_value,1);

569: IF l_debug_level > 0 THEN
570: oe_debug_pub.add( 'ATTACHMENTS DO NOT EXIST DELETE IF THERE IS
571: ANY' ) ;
572: oe_debug_pub.add( 'entity Name :'|| p_entity_name,1);
573: oe_debug_pub.add( 'x_pk1_value:'|| p_pk1_value,1);
574: oe_debug_pub.add( 'x_pk2_value:'|| p_pk2_value,1);
575: oe_debug_pub.add( 'x_pk3_value:'|| p_pk3_value,1);
576: oe_debug_pub.add( 'x_pk4_value:'|| p_pk4_value,1);
577: oe_debug_pub.add( 'x_pk5_value:'|| p_pk5_value,1);

Line 574: oe_debug_pub.add( 'x_pk2_value:'|| p_pk2_value,1);

570: oe_debug_pub.add( 'ATTACHMENTS DO NOT EXIST DELETE IF THERE IS
571: ANY' ) ;
572: oe_debug_pub.add( 'entity Name :'|| p_entity_name,1);
573: oe_debug_pub.add( 'x_pk1_value:'|| p_pk1_value,1);
574: oe_debug_pub.add( 'x_pk2_value:'|| p_pk2_value,1);
575: oe_debug_pub.add( 'x_pk3_value:'|| p_pk3_value,1);
576: oe_debug_pub.add( 'x_pk4_value:'|| p_pk4_value,1);
577: oe_debug_pub.add( 'x_pk5_value:'|| p_pk5_value,1);
578: END IF;

Line 575: oe_debug_pub.add( 'x_pk3_value:'|| p_pk3_value,1);

571: ANY' ) ;
572: oe_debug_pub.add( 'entity Name :'|| p_entity_name,1);
573: oe_debug_pub.add( 'x_pk1_value:'|| p_pk1_value,1);
574: oe_debug_pub.add( 'x_pk2_value:'|| p_pk2_value,1);
575: oe_debug_pub.add( 'x_pk3_value:'|| p_pk3_value,1);
576: oe_debug_pub.add( 'x_pk4_value:'|| p_pk4_value,1);
577: oe_debug_pub.add( 'x_pk5_value:'|| p_pk5_value,1);
578: END IF;
579: end if;

Line 576: oe_debug_pub.add( 'x_pk4_value:'|| p_pk4_value,1);

572: oe_debug_pub.add( 'entity Name :'|| p_entity_name,1);
573: oe_debug_pub.add( 'x_pk1_value:'|| p_pk1_value,1);
574: oe_debug_pub.add( 'x_pk2_value:'|| p_pk2_value,1);
575: oe_debug_pub.add( 'x_pk3_value:'|| p_pk3_value,1);
576: oe_debug_pub.add( 'x_pk4_value:'|| p_pk4_value,1);
577: oe_debug_pub.add( 'x_pk5_value:'|| p_pk5_value,1);
578: END IF;
579: end if;
580: EXCEPTION

Line 577: oe_debug_pub.add( 'x_pk5_value:'|| p_pk5_value,1);

573: oe_debug_pub.add( 'x_pk1_value:'|| p_pk1_value,1);
574: oe_debug_pub.add( 'x_pk2_value:'|| p_pk2_value,1);
575: oe_debug_pub.add( 'x_pk3_value:'|| p_pk3_value,1);
576: oe_debug_pub.add( 'x_pk4_value:'|| p_pk4_value,1);
577: oe_debug_pub.add( 'x_pk5_value:'|| p_pk5_value,1);
578: END IF;
579: end if;
580: EXCEPTION
581: when others then

Line 604: oe_debug_pub.add( 'CREATING AUTOMATIC ATTACHMENTS' ) ;

600: -- CREATE AUTOMATIC ATTACHMENTS
601: ---------------------------------------------------------------------
602:
603: IF l_debug_level > 0 THEN
604: oe_debug_pub.add( 'CREATING AUTOMATIC ATTACHMENTS' ) ;
605: END IF;
606:
607: i := l_documentTbl.first;
608: while i is not null loop

Line 648: oe_debug_pub.add( 'EXIT OE_FND_ATTACHMENTS_PVT.ADD_ATTACHMENTS_AUTOMATIC' , 1 ) ;

644:
645: --6896311 END IF; --l_need_delete_insert ?
646:
647: IF l_debug_level > 0 THEN
648: oe_debug_pub.add( 'EXIT OE_FND_ATTACHMENTS_PVT.ADD_ATTACHMENTS_AUTOMATIC' , 1 ) ;
649: END IF;
650:
651: EXCEPTION
652: WHEN FND_API.G_EXC_ERROR THEN

Line 666: oe_debug_pub.add( 'ADD_ATTACHMENTS_AUTOMATIC:AN EXCEPTION HAS OCCURED' , 1 ) ;

662: , p_data => x_msg_data
663: );
664: WHEN OTHERS THEN
665: IF l_debug_level > 0 THEN
666: oe_debug_pub.add( 'ADD_ATTACHMENTS_AUTOMATIC:AN EXCEPTION HAS OCCURED' , 1 ) ;
667: END IF;
668: IF l_debug_level > 0 THEN
669: oe_debug_pub.add( 'ERROR: '||SUBSTR ( SQLERRM , 1 , 250 ) , 1 ) ;
670: END IF;

Line 669: oe_debug_pub.add( 'ERROR: '||SUBSTR ( SQLERRM , 1 , 250 ) , 1 ) ;

665: IF l_debug_level > 0 THEN
666: oe_debug_pub.add( 'ADD_ATTACHMENTS_AUTOMATIC:AN EXCEPTION HAS OCCURED' , 1 ) ;
667: END IF;
668: IF l_debug_level > 0 THEN
669: oe_debug_pub.add( 'ERROR: '||SUBSTR ( SQLERRM , 1 , 250 ) , 1 ) ;
670: END IF;
671: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
672: IF OE_MSG_PUB.Check_Msg_Level
673: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 743: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

739: l_create_doc varchar2(1):= null;
740: --included to fix bug 1903257 End
741:
742: --
743: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
744: --
745: BEGIN
746:
747: -- Initialize API return status to success

Line 956: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

952:
953: )
954: IS
955: --
956: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
957: --
958: BEGIN
959:
960: x_return_status := FND_API.G_RET_STS_SUCCESS;