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_CUSTACCEPTREP_PVT dependencies on OE_DEBUG_PUB

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

30:
31: g_org_id NUMBER;
32: g_operating_unit VARCHAR2(240);
33: --Get the value of debug level set by the user.
34: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
35: g_counter NUMBER := 0; --myerrams, Introduced for no_date_found logic.
36:
37: --=============================================================================
38: -- PROCEDURES AND FUNCTIONS

Line 108: oe_debug_pub.add( 'OEXCARR:' || l_api_name || '.begin') ;

104: BEGIN
105:
106: IF l_debug_level > 0
107: THEN
108: oe_debug_pub.add( 'OEXCARR:' || l_api_name || '.begin') ;
109: END IF;
110:
111: SELECT TO_CHAR(p_date, 'YYYY-MM-DD')
112: INTO l_xsd_date_string

Line 117: oe_debug_pub.add( 'OEXCARR:' || l_api_name || '.end: Returning XSD Date = ' || l_xsd_date_string ) ;

113: FROM DUAL;
114:
115: IF l_debug_level > 0
116: THEN
117: oe_debug_pub.add( 'OEXCARR:' || l_api_name || '.end: Returning XSD Date = ' || l_xsd_date_string ) ;
118: END IF;
119:
120: l_xsd_date_string := TRIM(l_xsd_date_string);
121:

Line 129: oe_debug_pub.add( 'OEXCARR:' || l_api_name || ': ' || sqlerrm ) ;

125:
126: WHEN OTHERS THEN
127: IF l_debug_level > 0
128: THEN
129: oe_debug_pub.add( 'OEXCARR:' || l_api_name || ': ' || sqlerrm ) ;
130: END IF;
131:
132: RETURN NULL;
133:

Line 161: oe_debug_pub.add( 'OEXCARR: Inside put_parameter_tags') ;

157:
158: BEGIN
159: IF l_debug_level > 0
160: THEN
161: oe_debug_pub.add( 'OEXCARR: Inside put_parameter_tags') ;
162: END IF;
163:
164: --myerrams, converting the sort by option to an appropriate display name.
165: --myerrams, Bug: 5480694

Line 290: oe_debug_pub.add( 'OEXCARR: Inside create_where_clause') ;

286: BEGIN
287:
288: IF l_debug_level > 0
289: THEN
290: oe_debug_pub.add( 'OEXCARR: Inside create_where_clause') ;
291: END IF;
292: l_query := p_where_clause;
293:
294: IF g_customer_no_low IS NOT NULL

Line 360: oe_debug_pub.add( 'OEXCARR: create_where_clause returns : '||l_query);

356: OR oln.accepted_quantity >= 0) ';
357: END IF;
358:
359: IF l_debug_level > 0 THEN
360: oe_debug_pub.add( 'OEXCARR: create_where_clause returns : '||l_query);
361: END IF;
362: return l_query;
363:
364: END;

Line 387: oe_debug_pub.add( 'OEXCARR: Inside create_ord_where_clause') ;

383: BEGIN
384:
385: IF l_debug_level > 0
386: THEN
387: oe_debug_pub.add( 'OEXCARR: Inside create_ord_where_clause') ;
388: END IF;
389: l_query := p_where_clause;
390: IF p_cust_id IS NOT NULL
391: THEN

Line 432: oe_debug_pub.add( 'OEXCARR: create_where_clause returns : '||l_query);

428: OR oln.accepted_quantity >= 0) ';
429: END IF;
430:
431: IF l_debug_level > 0 THEN
432: oe_debug_pub.add( 'OEXCARR: create_where_clause returns : '||l_query);
433: END IF;
434: return l_query;
435:
436: END;

Line 460: oe_debug_pub.add( 'OEXCARR: Inside create_curr_where_clause') ;

456: BEGIN
457:
458: IF l_debug_level > 0
459: THEN
460: oe_debug_pub.add( 'OEXCARR: Inside create_curr_where_clause') ;
461: END IF;
462: l_query := p_where_clause;
463: IF p_curr_code IS NOT NULL
464: THEN

Line 493: oe_debug_pub.add( 'OEXCARR: Inside create_lines_where_clause') ;

489: BEGIN
490:
491: IF l_debug_level > 0
492: THEN
493: oe_debug_pub.add( 'OEXCARR: Inside create_lines_where_clause') ;
494: END IF;
495: l_query := p_where_clause;
496: IF p_header_id IS NOT NULL
497: THEN

Line 533: oe_debug_pub.add( 'OEXCARR: create_where_clause returns : '||l_query);

529: OR oln.accepted_quantity >= 0) ';
530: END IF;
531:
532: IF l_debug_level > 0 THEN
533: oe_debug_pub.add( 'OEXCARR: create_where_clause returns : '||l_query);
534: END IF;
535: return l_query;
536:
537: END;

Line 552: oe_debug_pub.add( 'OEXCARR: Inside put_ghead_tags') ;

548: )
549: IS
550: BEGIN
551: IF l_debug_level > 0 THEN
552: oe_debug_pub.add( 'OEXCARR: Inside put_ghead_tags') ;
553: END IF;
554:
555: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
556: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || '' || '');

Line 575: oe_debug_pub.add( 'OEXCARR: Inside put_gcurr_tags') ;

571: IS
572:
573: BEGIN
574: IF l_debug_level > 0 THEN
575: oe_debug_pub.add( 'OEXCARR: Inside put_gcurr_tags') ;
576: END IF;
577: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
578: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_currency || '');
579: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_order_by || '');

Line 602: oe_debug_pub.add( 'OEXCARR: Inside put_ord_tags') ;

598: )
599: IS
600: BEGIN
601: IF l_debug_level > 0 THEN
602: oe_debug_pub.add( 'OEXCARR: Inside put_ord_tags') ;
603: END IF;
604:
605: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
606: IF p_party_name IS NOT NULL

Line 640: oe_debug_pub.add( 'OEXCARR: Inside put_line_tags') ;

636: ,p_currency VARCHAR2 --myerrams, added the currency to comply with XML Publisher Number Formatting Standards
637: ) IS
638: BEGIN
639: IF l_debug_level > 0 THEN
640: oe_debug_pub.add( 'OEXCARR: Inside put_line_tags') ;
641: END IF;
642: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
643: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_currency || ''); --myerrams, Added order level Currency Tag for formatting the number columns in the RTF template. Bug: 5460837
644: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_line_number || '');

Line 670: oe_debug_pub.add( 'OEXCARR: Inside put_order_total_tags') ;

666: )
667: IS
668: BEGIN
669: IF l_debug_level > 0 THEN
670: oe_debug_pub.add( 'OEXCARR: Inside put_order_total_tags') ;
671: END IF;
672: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_accepted_value || '');
673: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_rejected_value || '');
674: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_pending_value || '');

Line 691: oe_debug_pub.add( 'OEXCARR: Inside put_cust_total_tags') ;

687: )
688: IS
689: BEGIN
690: IF l_debug_level > 0 THEN
691: oe_debug_pub.add( 'OEXCARR: Inside put_cust_total_tags') ;
692: END IF;
693: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_accepted_value || '');
694: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_rejected_value || '');
695: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_pending_value || '');

Line 712: oe_debug_pub.add( 'OEXCARR: Inside put_rep_total_tags') ;

708: )
709: IS
710: BEGIN
711: IF l_debug_level > 0 THEN
712: oe_debug_pub.add( 'OEXCARR: Inside put_rep_total_tags') ;
713: END IF;
714: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_accepted_value || '');
715: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_rejected_value || '');
716: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_pending_value || '');

Line 861: oe_debug_pub.add( 'OEXCARR: Inside put_remaining_tags') ;

857:
858: BEGIN
859: IF l_debug_level > 0
860: THEN
861: oe_debug_pub.add( 'OEXCARR: Inside put_remaining_tags') ;
862: END IF;
863:
864: -- Get the query string by calling function create_where_clause, This
865: -- function creates the where clause for the query based on the user input parameters.

Line 869: oe_debug_pub.add( 'OEXCARR: Query to be executed: '||l_cust_query ) ;

865: -- function creates the where clause for the query based on the user input parameters.
866: l_cust_query := l_cust_cursor_query;
867: l_cust_query := create_where_clause (l_cust_query);
868: IF l_debug_level > 0 THEN
869: oe_debug_pub.add( 'OEXCARR: Query to be executed: '||l_cust_query ) ;
870: END IF;
871: OPEN c_cust_from_param FOR l_cust_query;
872: LOOP
873: IF l_debug_level > 0 THEN

Line 874: oe_debug_pub.add( 'OEXCARR: Inside the LOOP for Customer');

870: END IF;
871: OPEN c_cust_from_param FOR l_cust_query;
872: LOOP
873: IF l_debug_level > 0 THEN
874: oe_debug_pub.add( 'OEXCARR: Inside the LOOP for Customer');
875: END IF;
876:
877: FETCH c_cust_from_param
878: INTO l_party_name,

Line 897: oe_debug_pub.add( 'OEXCARR: Value of l_cust_acc_id : '||l_cust_acc_id) ;

893: END IF;
894: --myerrams, end
895:
896: IF l_debug_level > 0 THEN
897: oe_debug_pub.add( 'OEXCARR: Value of l_cust_acc_id : '||l_cust_acc_id) ;
898: END IF;
899: l_ord_query := create_ord_where_clause(l_ord_query,l_cust_acc_id);
900:
901: --myerrams, start

Line 913: oe_debug_pub.add( 'OEXCARR: Query to be executed for Order: '||l_ord_query ) ;

909: --myerrams, end
910:
911:
912: IF l_debug_level > 0 THEN
913: oe_debug_pub.add( 'OEXCARR: Query to be executed for Order: '||l_ord_query ) ;
914: END IF;
915:
916: OPEN c_ord_from_param FOR l_ord_query;
917: LOOP

Line 973: oe_debug_pub.add( 'OEXCARR: Value of l_ord_conversion_rate:'||l_ord_conversion_rate);

969: END IF;
970:
971: --myerrams, currency conversion
972: IF l_debug_level > 0 THEN
973: oe_debug_pub.add( 'OEXCARR: Value of l_ord_conversion_rate:'||l_ord_conversion_rate);
974: END IF;
975: IF(p_func_currency = 'Y' and g_currency <> g_func_currency) THEN
976: IF l_debug_level > 0 THEN
977: oe_debug_pub.add( 'OEXCARR: before calculating the conversion_rate');

Line 977: oe_debug_pub.add( 'OEXCARR: before calculating the conversion_rate');

973: oe_debug_pub.add( 'OEXCARR: Value of l_ord_conversion_rate:'||l_ord_conversion_rate);
974: END IF;
975: IF(p_func_currency = 'Y' and g_currency <> g_func_currency) THEN
976: IF l_debug_level > 0 THEN
977: oe_debug_pub.add( 'OEXCARR: before calculating the conversion_rate');
978: oe_debug_pub.add( 'OEXCARR: Value of g_currency:'||g_currency);
979: oe_debug_pub.add( 'OEXCARR: Value of g_func_currency:'||g_func_currency);
980: oe_debug_pub.add( 'OEXCARR: Value of l_ordered_date:'||l_ordered_date);
981: oe_debug_pub.add( 'OEXCARR: Value of l_conversion_type_code:'||l_conversion_type_code);

Line 978: oe_debug_pub.add( 'OEXCARR: Value of g_currency:'||g_currency);

974: END IF;
975: IF(p_func_currency = 'Y' and g_currency <> g_func_currency) THEN
976: IF l_debug_level > 0 THEN
977: oe_debug_pub.add( 'OEXCARR: before calculating the conversion_rate');
978: oe_debug_pub.add( 'OEXCARR: Value of g_currency:'||g_currency);
979: oe_debug_pub.add( 'OEXCARR: Value of g_func_currency:'||g_func_currency);
980: oe_debug_pub.add( 'OEXCARR: Value of l_ordered_date:'||l_ordered_date);
981: oe_debug_pub.add( 'OEXCARR: Value of l_conversion_type_code:'||l_conversion_type_code);
982: END IF;

Line 979: oe_debug_pub.add( 'OEXCARR: Value of g_func_currency:'||g_func_currency);

975: IF(p_func_currency = 'Y' and g_currency <> g_func_currency) THEN
976: IF l_debug_level > 0 THEN
977: oe_debug_pub.add( 'OEXCARR: before calculating the conversion_rate');
978: oe_debug_pub.add( 'OEXCARR: Value of g_currency:'||g_currency);
979: oe_debug_pub.add( 'OEXCARR: Value of g_func_currency:'||g_func_currency);
980: oe_debug_pub.add( 'OEXCARR: Value of l_ordered_date:'||l_ordered_date);
981: oe_debug_pub.add( 'OEXCARR: Value of l_conversion_type_code:'||l_conversion_type_code);
982: END IF;
983:

Line 980: oe_debug_pub.add( 'OEXCARR: Value of l_ordered_date:'||l_ordered_date);

976: IF l_debug_level > 0 THEN
977: oe_debug_pub.add( 'OEXCARR: before calculating the conversion_rate');
978: oe_debug_pub.add( 'OEXCARR: Value of g_currency:'||g_currency);
979: oe_debug_pub.add( 'OEXCARR: Value of g_func_currency:'||g_func_currency);
980: oe_debug_pub.add( 'OEXCARR: Value of l_ordered_date:'||l_ordered_date);
981: oe_debug_pub.add( 'OEXCARR: Value of l_conversion_type_code:'||l_conversion_type_code);
982: END IF;
983:
984: if(l_ord_conversion_rate is null) then

Line 981: oe_debug_pub.add( 'OEXCARR: Value of l_conversion_type_code:'||l_conversion_type_code);

977: oe_debug_pub.add( 'OEXCARR: before calculating the conversion_rate');
978: oe_debug_pub.add( 'OEXCARR: Value of g_currency:'||g_currency);
979: oe_debug_pub.add( 'OEXCARR: Value of g_func_currency:'||g_func_currency);
980: oe_debug_pub.add( 'OEXCARR: Value of l_ordered_date:'||l_ordered_date);
981: oe_debug_pub.add( 'OEXCARR: Value of l_conversion_type_code:'||l_conversion_type_code);
982: END IF;
983:
984: if(l_ord_conversion_rate is null) then
985: l_conversion_rate := gl_conversion_rate_func

Line 996: oe_debug_pub.add( 'OEXCARR: Value of l_conversion_rate:'||l_conversion_rate);

992: l_conversion_rate := l_ord_conversion_rate;
993: end if;
994:
995: IF l_debug_level > 0 THEN
996: oe_debug_pub.add( 'OEXCARR: Value of l_conversion_rate:'||l_conversion_rate);
997: END IF;
998: END IF;
999: --myerrams, currency conversion, end
1000: l_lines_query := l_line_cursor_query;

Line 1008: oe_debug_pub.add( 'OEXCARR: Query to be executed for Lines: '||l_lines_query ) ;

1004: l_lines_query := l_lines_query || ' Order by oln.line_number, oln.line_id ';
1005: --myerrams, end
1006:
1007: IF l_debug_level > 0 THEN
1008: oe_debug_pub.add( 'OEXCARR: Query to be executed for Lines: '||l_lines_query ) ;
1009: END IF;
1010:
1011: l_line_counter := 0; --myerrams, Initialize the Line counter.
1012:

Line 1105: oe_debug_pub.add( 'OEXCARR: Value of l_line_accepted_total 2: '||l_line_accepted_total ) ;

1101: END LOOP; -- LOOP END for c_line_from_param
1102: close c_line_from_param;
1103: l_lines_query := NULL;
1104: IF l_debug_level > 0 THEN
1105: oe_debug_pub.add( 'OEXCARR: Value of l_line_accepted_total 2: '||l_line_accepted_total ) ;
1106: oe_debug_pub.add( 'OEXCARR: Value of l_line_rejected_total 2: '||l_line_rejected_total ) ;
1107: oe_debug_pub.add( 'OEXCARR: Value of l_line_pending_total 2: '||l_line_pending_total ) ;
1108: END IF;
1109: IF l_line_counter > 0 THEN --myerrams, put the order total tags only when there are lines present.

Line 1106: oe_debug_pub.add( 'OEXCARR: Value of l_line_rejected_total 2: '||l_line_rejected_total ) ;

1102: close c_line_from_param;
1103: l_lines_query := NULL;
1104: IF l_debug_level > 0 THEN
1105: oe_debug_pub.add( 'OEXCARR: Value of l_line_accepted_total 2: '||l_line_accepted_total ) ;
1106: oe_debug_pub.add( 'OEXCARR: Value of l_line_rejected_total 2: '||l_line_rejected_total ) ;
1107: oe_debug_pub.add( 'OEXCARR: Value of l_line_pending_total 2: '||l_line_pending_total ) ;
1108: END IF;
1109: IF l_line_counter > 0 THEN --myerrams, put the order total tags only when there are lines present.
1110: --myerrams, currency conversion

Line 1107: oe_debug_pub.add( 'OEXCARR: Value of l_line_pending_total 2: '||l_line_pending_total ) ;

1103: l_lines_query := NULL;
1104: IF l_debug_level > 0 THEN
1105: oe_debug_pub.add( 'OEXCARR: Value of l_line_accepted_total 2: '||l_line_accepted_total ) ;
1106: oe_debug_pub.add( 'OEXCARR: Value of l_line_rejected_total 2: '||l_line_rejected_total ) ;
1107: oe_debug_pub.add( 'OEXCARR: Value of l_line_pending_total 2: '||l_line_pending_total ) ;
1108: END IF;
1109: IF l_line_counter > 0 THEN --myerrams, put the order total tags only when there are lines present.
1110: --myerrams, currency conversion
1111: IF(p_func_currency = 'Y' and g_currency <> g_func_currency) THEN

Line 1283: oe_debug_pub.add( 'OEXCARR: Starting Generate_ReportData procedure') ;

1279: BEGIN
1280:
1281: IF l_debug_level > 0
1282: THEN
1283: oe_debug_pub.add( 'OEXCARR: Starting Generate_ReportData procedure') ;
1284: END IF;
1285:
1286: --myerrams, Bug: 5214119. Converting the VARCHAR2 variables to DATE variables.
1287: g_order_date_low := fnd_date.canonical_to_date(p_order_date_low);

Line 1305: oe_debug_pub.add( 'OEXCARR: Error in MO Query, Value of g_org_id '||g_org_id) ;

1301: WHEN OTHERS
1302: THEN
1303: IF l_debug_level > 0
1304: THEN
1305: oe_debug_pub.add( 'OEXCARR: Error in MO Query, Value of g_org_id '||g_org_id) ;
1306: END IF;
1307: END;
1308:
1309: g_sorted_by := p_sorted_by;

Line 1322: oe_debug_pub.add('OEXCARR: Before call to put_parameter_tags procedure, p_func_currency:'||p_func_currency);

1318: g_acceptance_status := p_acceptance_status; --myerrams, Bug:4749985
1319: g_item_display := p_item_display;
1320: IF l_debug_level > 0
1321: THEN
1322: oe_debug_pub.add('OEXCARR: Before call to put_parameter_tags procedure, p_func_currency:'||p_func_currency);
1323: END IF;
1324: --myerrams, Bug: 5484771
1325: IF p_func_currency IS NOT NULL
1326: THEN

Line 1338: oe_debug_pub.add( 'OEXCARR: After call to put_parameter_tags procedure') ;

1334: --Call the procedure to place the parameter values in the XML output.
1335: put_parameter_tags;
1336: IF l_debug_level > 0
1337: THEN
1338: oe_debug_pub.add( 'OEXCARR: After call to put_parameter_tags procedure') ;
1339: END IF;
1340:
1341: IF p_func_currency = 'Y'
1342: THEN

Line 1376: oe_debug_pub.add( 'OEXCARR: Query to be executed: '||l_curr_query ) ;

1372: l_curr_query := l_curr_query || ' AND oha.sold_to_org_id in (' || l_cust_query_to_append || ') ';
1373: l_curr_query := create_ord_where_clause(l_curr_query,NULL);
1374:
1375: IF l_debug_level > 0 THEN
1376: oe_debug_pub.add( 'OEXCARR: Query to be executed: '||l_curr_query ) ;
1377: END IF;
1378: OPEN c_curr_from_param FOR l_curr_query;
1379: LOOP
1380: IF l_debug_level > 0 THEN

Line 1381: oe_debug_pub.add( 'OEXCARR: Inside the LOOP for Currency');

1377: END IF;
1378: OPEN c_curr_from_param FOR l_curr_query;
1379: LOOP
1380: IF l_debug_level > 0 THEN
1381: oe_debug_pub.add( 'OEXCARR: Inside the LOOP for Currency');
1382: END IF;
1383:
1384: FETCH c_curr_from_param
1385: INTO

Line 1389: oe_debug_pub.add( 'OEXCARR: Value of g_ord_currency:'||g_ord_currency);

1385: INTO
1386: g_ord_currency;
1387: EXIT WHEN c_curr_from_param%NOTFOUND;
1388: IF l_debug_level > 0 THEN
1389: oe_debug_pub.add( 'OEXCARR: Value of g_ord_currency:'||g_ord_currency);
1390: END IF;
1391: put_gcurr_tags(g_ord_currency,g_sorted_by);
1392: put_remaining_tags(p_sorted_by,P_FUNC_CURRENCY,ERRBUF,RETCODE);
1393: END LOOP; --c_curr_from_param loop