DBA Data[Home] [Help]

APPS.OE_PORTAL_HEADER dependencies on OE_DEBUG_PUB

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

112: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
113: l_control_rec OE_GLOBALS.Control_Rec_Type;
114: l_return_status VARCHAR2(1);
115: --
116: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
117: --
118: BEGIN
119: IF l_debug_level > 0 THEN
120: oe_debug_pub.add( 'ENTERING OE_PORTAL_HEADER.DEFAULT_HEADER_ATTRIBUTES' , 1 ) ;

Line 120: oe_debug_pub.add( 'ENTERING OE_PORTAL_HEADER.DEFAULT_HEADER_ATTRIBUTES' , 1 ) ;

116: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
117: --
118: BEGIN
119: IF l_debug_level > 0 THEN
120: oe_debug_pub.add( 'ENTERING OE_PORTAL_HEADER.DEFAULT_HEADER_ATTRIBUTES' , 1 ) ;
121: END IF;
122:
123: IF l_debug_level > 0 THEN
124: oe_debug_pub.add( 'ESHAS TEST' ) ;

Line 124: oe_debug_pub.add( 'ESHAS TEST' ) ;

120: oe_debug_pub.add( 'ENTERING OE_PORTAL_HEADER.DEFAULT_HEADER_ATTRIBUTES' , 1 ) ;
121: END IF;
122:
123: IF l_debug_level > 0 THEN
124: oe_debug_pub.add( 'ESHAS TEST' ) ;
125: END IF;
126:
127: -- Set the UI flag
128: OE_GLOBALS.G_UI_FLAG := TRUE;

Line 234: oe_debug_pub.add( 'L_HEADER_REC.TAX_EXEMPT_FLAG ' || L_HEADER_REC.TAX_EXEMPT_FLAG ) ;

230: RAISE FND_API.G_EXC_ERROR;
231: END IF;
232:
233: IF l_debug_level > 0 THEN
234: oe_debug_pub.add( 'L_HEADER_REC.TAX_EXEMPT_FLAG ' || L_HEADER_REC.TAX_EXEMPT_FLAG ) ;
235: END IF;
236: -- Load OUT parameters.
237:
238: l_header_val_rec := OE_Header_Util.Get_Values

Line 313: oe_debug_pub.add( 'EXITING OE_PORTAL_HEADER.DEFAULT_ATTRIBUTES' , 1 ) ;

309: x_partial_shipments := 'No';
310: end if;
311:
312: IF l_debug_level > 0 THEN
313: oe_debug_pub.add( 'EXITING OE_PORTAL_HEADER.DEFAULT_ATTRIBUTES' , 1 ) ;
314: END IF;
315: EXCEPTION
316:
317: WHEN FND_API.G_EXC_ERROR THEN

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

480: l_return_status VARCHAR2(1);
481: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
482: l_header_val_rec OE_Order_Pub.Header_Val_Rec_Type;
483: --
484: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
485: --
486: BEGIN
487:
488: SAVEPOINT Header_Validate_And_Write;

Line 491: oe_debug_pub.add( 'ENTERING OE_PORTAL_HEADER.VALIDATE_WRITE_HEADER' , 1 ) ;

487:
488: SAVEPOINT Header_Validate_And_Write;
489:
490: IF l_debug_level > 0 THEN
491: oe_debug_pub.add( 'ENTERING OE_PORTAL_HEADER.VALIDATE_WRITE_HEADER' , 1 ) ;
492: oe_debug_pub.add( 'HEADER ID' || P_HEADER_ID , 1 ) ;
493: oe_debug_pub.add( 'DB FLAG' || P_DB_RECORD , 1 ) ;
494: END IF;
495:

Line 492: oe_debug_pub.add( 'HEADER ID' || P_HEADER_ID , 1 ) ;

488: SAVEPOINT Header_Validate_And_Write;
489:
490: IF l_debug_level > 0 THEN
491: oe_debug_pub.add( 'ENTERING OE_PORTAL_HEADER.VALIDATE_WRITE_HEADER' , 1 ) ;
492: oe_debug_pub.add( 'HEADER ID' || P_HEADER_ID , 1 ) ;
493: oe_debug_pub.add( 'DB FLAG' || P_DB_RECORD , 1 ) ;
494: END IF;
495:
496: if p_db_record = 'Y' THEN

Line 493: oe_debug_pub.add( 'DB FLAG' || P_DB_RECORD , 1 ) ;

489:
490: IF l_debug_level > 0 THEN
491: oe_debug_pub.add( 'ENTERING OE_PORTAL_HEADER.VALIDATE_WRITE_HEADER' , 1 ) ;
492: oe_debug_pub.add( 'HEADER ID' || P_HEADER_ID , 1 ) ;
493: oe_debug_pub.add( 'DB FLAG' || P_DB_RECORD , 1 ) ;
494: END IF;
495:
496: if p_db_record = 'Y' THEN
497: l_db_record := TRUE;

Line 530: oe_debug_pub.add( 'HEADER ID' || L_X_HEADER_REC.HEADER_ID , 1 ) ;

526: , p_header_id => p_header_id
527: , x_header_rec => l_x_header_rec
528: );
529: IF l_debug_level > 0 THEN
530: oe_debug_pub.add( 'HEADER ID' || L_X_HEADER_REC.HEADER_ID , 1 ) ;
531: END IF;
532:
533: if p_freight_terms_code is not null then
534: l_x_header_rec.freight_terms_code := p_freight_terms_code;

Line 591: oe_debug_pub.add( 'L_X_HEADER_REC.TAX_EXEMPT_FLA_G ' || L_X_HEADER_REC.TAX_EXEMPT_FLAG ) ;

587: , x_return_status => l_return_status
588: );
589:
590: IF l_debug_level > 0 THEN
591: oe_debug_pub.add( 'L_X_HEADER_REC.TAX_EXEMPT_FLA_G ' || L_X_HEADER_REC.TAX_EXEMPT_FLAG ) ;
592: END IF;
593:
594: IF l_debug_level > 0 THEN
595: oe_debug_pub.add( 'HEADER ID' || L_X_HEADER_REC.HEADER_ID , 1 ) ;

Line 595: oe_debug_pub.add( 'HEADER ID' || L_X_HEADER_REC.HEADER_ID , 1 ) ;

591: oe_debug_pub.add( 'L_X_HEADER_REC.TAX_EXEMPT_FLA_G ' || L_X_HEADER_REC.TAX_EXEMPT_FLAG ) ;
592: END IF;
593:
594: IF l_debug_level > 0 THEN
595: oe_debug_pub.add( 'HEADER ID' || L_X_HEADER_REC.HEADER_ID , 1 ) ;
596: END IF;
597: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
598: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
599: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 613: oe_debug_pub.add( 'L_HEADER_REC.TAX_EXEMPT_FLAG ' || L_X_HEADER_REC.TAX_EXEMPT_FLAG ) ;

609: , p_header_rec => l_x_header_rec
610: , p_old_header_rec => l_x_old_header_rec
611: );
612: IF l_debug_level > 0 THEN
613: oe_debug_pub.add( 'L_HEADER_REC.TAX_EXEMPT_FLAG ' || L_X_HEADER_REC.TAX_EXEMPT_FLAG ) ;
614: END IF;
615:
616: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
617: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 635: oe_debug_pub.add( 'L_HEADER_REC.TAX_EXEMPT_FLAG ' || L_X_HEADER_REC.TAX_EXEMPT_FLAG ) ;

631:
632: -- Load OUT parameters.
633:
634: IF l_debug_level > 0 THEN
635: oe_debug_pub.add( 'L_HEADER_REC.TAX_EXEMPT_FLAG ' || L_X_HEADER_REC.TAX_EXEMPT_FLAG ) ;
636: END IF;
637:
638: x_order_number := l_x_header_rec.order_number;
639: l_lock_control := l_x_header_rec.lock_control;

Line 649: oe_debug_pub.add( 'HEADER ID' || L_X_HEADER_REC.HEADER_ID , 1 ) ;

645: , x_header_rec => l_x_header_rec
646: );
647: END IF;
648: IF l_debug_level > 0 THEN
649: oe_debug_pub.add( 'HEADER ID' || L_X_HEADER_REC.HEADER_ID , 1 ) ;
650: END IF;
651:
652: l_header_val_rec := OE_Header_Util.Get_Values
653: ( p_header_rec => l_x_header_rec

Line 722: oe_debug_pub.add( 'RETURN STATUS'|| X_RETURN_STATUS , 1 ) ;

718: , p_data => x_msg_data
719: );
720:
721: IF l_debug_level > 0 THEN
722: oe_debug_pub.add( 'RETURN STATUS'|| X_RETURN_STATUS , 1 ) ;
723: oe_debug_pub.add( 'HEADER_ID'|| X_HEADER_ID , 1 ) ;
724: oe_debug_pub.add( 'EXITING OE_PORTAL_HEADER.VALIDATE_WRITE_HEADER' , 1 ) ;
725: END IF;
726:

Line 723: oe_debug_pub.add( 'HEADER_ID'|| X_HEADER_ID , 1 ) ;

719: );
720:
721: IF l_debug_level > 0 THEN
722: oe_debug_pub.add( 'RETURN STATUS'|| X_RETURN_STATUS , 1 ) ;
723: oe_debug_pub.add( 'HEADER_ID'|| X_HEADER_ID , 1 ) ;
724: oe_debug_pub.add( 'EXITING OE_PORTAL_HEADER.VALIDATE_WRITE_HEADER' , 1 ) ;
725: END IF;
726:
727: /*

Line 724: oe_debug_pub.add( 'EXITING OE_PORTAL_HEADER.VALIDATE_WRITE_HEADER' , 1 ) ;

720:
721: IF l_debug_level > 0 THEN
722: oe_debug_pub.add( 'RETURN STATUS'|| X_RETURN_STATUS , 1 ) ;
723: oe_debug_pub.add( 'HEADER_ID'|| X_HEADER_ID , 1 ) ;
724: oe_debug_pub.add( 'EXITING OE_PORTAL_HEADER.VALIDATE_WRITE_HEADER' , 1 ) ;
725: END IF;
726:
727: /*
728: oe_debug_pub.add('no. of OE messages :'||x_msg_count,1);

Line 728: oe_debug_pub.add('no. of OE messages :'||x_msg_count,1);

724: oe_debug_pub.add( 'EXITING OE_PORTAL_HEADER.VALIDATE_WRITE_HEADER' , 1 ) ;
725: END IF;
726:
727: /*
728: oe_debug_pub.add('no. of OE messages :'||x_msg_count,1);
729: dbms_output.put_line('no. of OE messages :'||x_msg_count);
730: for k in 1 .. x_msg_count loop
731: x_msg_data := oe_msg_pub.get( p_msg_index => k,
732: p_encoded => 'F'

Line 734: oe_debug_pub.add(substr(x_msg_data,1,255));

730: for k in 1 .. x_msg_count loop
731: x_msg_data := oe_msg_pub.get( p_msg_index => k,
732: p_encoded => 'F'
733: );
734: oe_debug_pub.add(substr(x_msg_data,1,255));
735: dbms_output.put_line('Error msg: '||substr(x_msg_data,1,2000));
736: end loop;
737:
738: fnd_msg_pub.count_and_get( p_encoded => 'F'

Line 741: oe_debug_pub.add('no. of FND messages :'||x_msg_count,1);

737:
738: fnd_msg_pub.count_and_get( p_encoded => 'F'
739: , p_count => x_msg_count
740: , p_data => x_msg_data);
741: oe_debug_pub.add('no. of FND messages :'||x_msg_count,1);
742: dbms_output.put_line('no. of FND messages :'||x_msg_count);
743: for k in 1 .. x_msg_count loop
744: x_msg_data := fnd_msg_pub.get( p_msg_index => k,
745: p_encoded => 'F'

Line 748: oe_debug_pub.add(substr(x_msg_data,1,255));

744: x_msg_data := fnd_msg_pub.get( p_msg_index => k,
745: p_encoded => 'F'
746: );
747: dbms_output.put_line('Error msg: '||substr(x_msg_data,1,200));
748: oe_debug_pub.add(substr(x_msg_data,1,255));
749:
750: end loop;
751: */
752: EXCEPTION

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

821: l_control_rec OE_GLOBALS.Control_Rec_Type;
822: l_return_status VARCHAR2(1);
823: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
824: --
825: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
826: --
827: BEGIN
828:
829: IF l_debug_level > 0 THEN

Line 830: oe_debug_pub.add( 'ENTERING OE_OE_FORM_HEADER.DELETE_ROW' , 1 ) ;

826: --
827: BEGIN
828:
829: IF l_debug_level > 0 THEN
830: oe_debug_pub.add( 'ENTERING OE_OE_FORM_HEADER.DELETE_ROW' , 1 ) ;
831: END IF;
832:
833: -- Set the UI flag
834: OE_GLOBALS.G_UI_FLAG := TRUE;

Line 947: oe_debug_pub.add( 'EXITING OE_OE_FORM_HEADER.DELETE_ROW' , 1 ) ;

943: , p_data => x_msg_data
944: );
945:
946: IF l_debug_level > 0 THEN
947: oe_debug_pub.add( 'EXITING OE_OE_FORM_HEADER.DELETE_ROW' , 1 ) ;
948: END IF;
949:
950: EXCEPTION
951:

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

1018:
1019: )
1020: IS
1021: --
1022: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1023: --
1024: BEGIN
1025:
1026: IF p_header_id is NULL OR p_header_id = FND_API.G_MISS_NUM THEN

Line 1068: oe_debug_pub.add( 'EXITING OE_PORTAL_HEADER.GET_ORDER_TOTALS' , 1 ) ;

1064: , p_data => x_msg_data
1065: );
1066:
1067: IF l_debug_level > 0 THEN
1068: oe_debug_pub.add( 'EXITING OE_PORTAL_HEADER.GET_ORDER_TOTALS' , 1 ) ;
1069: END IF;
1070:
1071: EXCEPTION
1072:

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

1126: , x_header_rec OUT NOCOPY OE_Order_PUB.Header_Rec_Type
1127: )
1128: IS
1129: --
1130: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1131: --
1132: BEGIN
1133:
1134: IF l_debug_level > 0 THEN

Line 1135: oe_debug_pub.add( 'ENTERING OE_PORTAL_HEADER.GET_HEADER' , 1 ) ;

1131: --
1132: BEGIN
1133:
1134: IF l_debug_level > 0 THEN
1135: oe_debug_pub.add( 'ENTERING OE_PORTAL_HEADER.GET_HEADER' , 1 ) ;
1136: oe_debug_pub.add( 'CACHED HEADER ID ' || G_HEADER_REC.HEADER_ID , 1 ) ;
1137: END IF;
1138:
1139: IF p_header_id <> NVL(g_header_rec.header_id,FND_API.G_MISS_NUM)

Line 1136: oe_debug_pub.add( 'CACHED HEADER ID ' || G_HEADER_REC.HEADER_ID , 1 ) ;

1132: BEGIN
1133:
1134: IF l_debug_level > 0 THEN
1135: oe_debug_pub.add( 'ENTERING OE_PORTAL_HEADER.GET_HEADER' , 1 ) ;
1136: oe_debug_pub.add( 'CACHED HEADER ID ' || G_HEADER_REC.HEADER_ID , 1 ) ;
1137: END IF;
1138:
1139: IF p_header_id <> NVL(g_header_rec.header_id,FND_API.G_MISS_NUM)
1140: THEN

Line 1168: oe_debug_pub.add( 'EXITING OE_PORTAL_HEADER.GET_HEADER' , 1 ) ;

1164:
1165: END IF;
1166:
1167: IF l_debug_level > 0 THEN
1168: oe_debug_pub.add( 'EXITING OE_PORTAL_HEADER.GET_HEADER' , 1 ) ;
1169: END IF;
1170:
1171: END Get_Header;
1172:

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

1172:
1173: PROCEDURE Clear_Header
1174: IS
1175: --
1176: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1177: --
1178: BEGIN
1179:
1180: IF l_debug_level > 0 THEN

Line 1181: oe_debug_pub.add( 'ENTERING OE_PORTAL_HEADER.CLEAR_HEADER' , 1 ) ;

1177: --
1178: BEGIN
1179:
1180: IF l_debug_level > 0 THEN
1181: oe_debug_pub.add( 'ENTERING OE_PORTAL_HEADER.CLEAR_HEADER' , 1 ) ;
1182: END IF;
1183:
1184: g_header_rec := OE_Order_PUB.G_MISS_HEADER_REC;
1185: g_db_header_rec := OE_Order_PUB.G_MISS_HEADER_REC;

Line 1188: oe_debug_pub.add( 'EXITING OE_PORTAL_HEADER.CLEAR_HEADER' , 1 ) ;

1184: g_header_rec := OE_Order_PUB.G_MISS_HEADER_REC;
1185: g_db_header_rec := OE_Order_PUB.G_MISS_HEADER_REC;
1186:
1187: IF l_debug_level > 0 THEN
1188: oe_debug_pub.add( 'EXITING OE_PORTAL_HEADER.CLEAR_HEADER' , 1 ) ;
1189: END IF;
1190:
1191: END Clear_Header;
1192:

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

1197: , p_db_record IN BOOLEAN := FALSE
1198: )
1199: IS
1200: --
1201: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1202: --
1203: BEGIN
1204:
1205: IF l_debug_level > 0 THEN

Line 1206: oe_debug_pub.add( 'ENTERING OE_PORTAL_HEADER.WRITE_HEADER' , 1 ) ;

1202: --
1203: BEGIN
1204:
1205: IF l_debug_level > 0 THEN
1206: oe_debug_pub.add( 'ENTERING OE_PORTAL_HEADER.WRITE_HEADER' , 1 ) ;
1207: END IF;
1208:
1209: g_header_rec := p_header_rec;
1210:

Line 1218: oe_debug_pub.add( 'EXITING OE_PORTAL_HEADER.WRITE_HEADER' , 1 ) ;

1214:
1215: END IF;
1216:
1217: IF l_debug_level > 0 THEN
1218: oe_debug_pub.add( 'EXITING OE_PORTAL_HEADER.WRITE_HEADER' , 1 ) ;
1219: oe_debug_pub.add( 'G_HEADER_REC.HEADER_ID ' || G_HEADER_REC.HEADER_ID , 1 ) ;
1220: END IF;
1221: END Write_Header;
1222:

Line 1219: oe_debug_pub.add( 'G_HEADER_REC.HEADER_ID ' || G_HEADER_REC.HEADER_ID , 1 ) ;

1215: END IF;
1216:
1217: IF l_debug_level > 0 THEN
1218: oe_debug_pub.add( 'EXITING OE_PORTAL_HEADER.WRITE_HEADER' , 1 ) ;
1219: oe_debug_pub.add( 'G_HEADER_REC.HEADER_ID ' || G_HEADER_REC.HEADER_ID , 1 ) ;
1220: END IF;
1221: END Write_Header;
1222:
1223: