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.CSD_RECEIVE_UTIL dependencies on FND_LOG

Line 95: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

91:
92: BEGIN
93:
94:
95: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
96: THEN
97: fnd_log.STRING
98: (fnd_log.level_procedure,
99: 'CSD.PLSQL.CSD_RECEIVE_UTIL.IS_AUTO_RCV_AVAILABLE.BEGIN',

Line 97: fnd_log.STRING

93:
94:
95: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
96: THEN
97: fnd_log.STRING
98: (fnd_log.level_procedure,
99: 'CSD.PLSQL.CSD_RECEIVE_UTIL.IS_AUTO_RCV_AVAILABLE.BEGIN',
100: 'Entered IS_AUTO_RCV_AVAILABLE'
101: );

Line 98: (fnd_log.level_procedure,

94:
95: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
96: THEN
97: fnd_log.STRING
98: (fnd_log.level_procedure,
99: 'CSD.PLSQL.CSD_RECEIVE_UTIL.IS_AUTO_RCV_AVAILABLE.BEGIN',
100: 'Entered IS_AUTO_RCV_AVAILABLE'
101: );
102: END IF;

Line 113: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

109:
110:
111: l_routing_header_id := -1;
112:
113: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
114: THEN
115: fnd_log.STRING (fnd_log.level_statement,
116: 'CSD.PLSQL.CSD_RECEIVE_UTIL.IS_AUTO_RCV_AVAILABLE',
117: 'Parameter:p_inventory_item_id['

Line 115: fnd_log.STRING (fnd_log.level_statement,

111: l_routing_header_id := -1;
112:
113: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
114: THEN
115: fnd_log.STRING (fnd_log.level_statement,
116: 'CSD.PLSQL.CSD_RECEIVE_UTIL.IS_AUTO_RCV_AVAILABLE',
117: 'Parameter:p_inventory_item_id['
118: || p_inventory_item_id
119: || ']'

Line 121: fnd_log.STRING (fnd_log.level_statement,

117: 'Parameter:p_inventory_item_id['
118: || p_inventory_item_id
119: || ']'
120: );
121: fnd_log.STRING (fnd_log.level_statement,
122: 'CSD.PLSQL.CSD_RECEIVE_UTIL.IS_AUTO_RCV_AVAILABLE',
123: 'Parameter:p_inv_org_id[' || p_inv_org_id || ']'
124: );
125: fnd_log.STRING (fnd_log.level_statement,

Line 125: fnd_log.STRING (fnd_log.level_statement,

121: fnd_log.STRING (fnd_log.level_statement,
122: 'CSD.PLSQL.CSD_RECEIVE_UTIL.IS_AUTO_RCV_AVAILABLE',
123: 'Parameter:p_inv_org_id[' || p_inv_org_id || ']'
124: );
125: fnd_log.STRING (fnd_log.level_statement,
126: 'CSD.PLSQL.CSD_RECEIVE_UTIL.IS_AUTO_RCV_AVAILABLE',
127: 'Parameter:p_internal_RO_flag['
128: || p_internal_ro_flag
129: || ']'

Line 131: fnd_log.STRING (fnd_log.level_statement,

127: 'Parameter:p_internal_RO_flag['
128: || p_internal_ro_flag
129: || ']'
130: );
131: fnd_log.STRING (fnd_log.level_statement,
132: 'CSD.PLSQL.CSD_RECEIVE_UTIL.IS_AUTO_RCV_AVAILABLE',
133: 'Parameter:p_from_inv_org_id['
134: || p_from_inv_org_id
135: || ']'

Line 139: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

135: || ']'
136: );
137: END IF;
138:
139: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
140: THEN
141: fnd_log.STRING (fnd_log.level_event,
142: 'CSD.PLSQL.CSD_RECEIVE_UTIL.IS_AUTO_RCV_AVAILABLE',
143: 'Checking item level routing'

Line 141: fnd_log.STRING (fnd_log.level_event,

137: END IF;
138:
139: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
140: THEN
141: fnd_log.STRING (fnd_log.level_event,
142: 'CSD.PLSQL.CSD_RECEIVE_UTIL.IS_AUTO_RCV_AVAILABLE',
143: 'Checking item level routing'
144: );
145: END IF;

Line 180: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

176: END IF;
177:
178:
179: -- Step 2: Check Shipping network
180: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
181: THEN
182: fnd_log.STRING
183: (fnd_log.level_event,
184: 'CSD.PLSQL.CSD_RECEIVE_UTIL.IS_AUTO_RCV_AVAILABLE',

Line 182: fnd_log.STRING

178:
179: -- Step 2: Check Shipping network
180: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
181: THEN
182: fnd_log.STRING
183: (fnd_log.level_event,
184: 'CSD.PLSQL.CSD_RECEIVE_UTIL.IS_AUTO_RCV_AVAILABLE',
185: 'Checking shipping network level routing'
186: );

Line 183: (fnd_log.level_event,

179: -- Step 2: Check Shipping network
180: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
181: THEN
182: fnd_log.STRING
183: (fnd_log.level_event,
184: 'CSD.PLSQL.CSD_RECEIVE_UTIL.IS_AUTO_RCV_AVAILABLE',
185: 'Checking shipping network level routing'
186: );
187: END IF;

Line 208: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

204: RETURN l_routing_header_id;
205: END IF;
206:
207: -- Organization level
208: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
209: THEN
210: fnd_log.STRING (fnd_log.level_event,
211: 'CSD.PLSQL.CSD_RECEIVE_UTIL.IS_AUTO_RCV_AVAILABLE',
212: 'Checking org level routing'

Line 210: fnd_log.STRING (fnd_log.level_event,

206:
207: -- Organization level
208: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
209: THEN
210: fnd_log.STRING (fnd_log.level_event,
211: 'CSD.PLSQL.CSD_RECEIVE_UTIL.IS_AUTO_RCV_AVAILABLE',
212: 'Checking org level routing'
213: );
214: END IF;

Line 297: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

293: IF(l_routing_header_id is null) THEN
294: l_routing_header_id := g_standard_routing;
295: END IF;
296:
297: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
298: THEN
299: fnd_log.STRING
300: (fnd_log.level_procedure,
301: 'CSD.PLSQL.CSD_RECEIVE_UTIL.IS_AUTO_RCV_AVAILABLE.END',

Line 299: fnd_log.STRING

295: END IF;
296:
297: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
298: THEN
299: fnd_log.STRING
300: (fnd_log.level_procedure,
301: 'CSD.PLSQL.CSD_RECEIVE_UTIL.IS_AUTO_RCV_AVAILABLE.END',
302: 'Leaving IS_AUTO_RCV_AVAILABLE'
303: );

Line 300: (fnd_log.level_procedure,

296:
297: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
298: THEN
299: fnd_log.STRING
300: (fnd_log.level_procedure,
301: 'CSD.PLSQL.CSD_RECEIVE_UTIL.IS_AUTO_RCV_AVAILABLE.END',
302: 'Leaving IS_AUTO_RCV_AVAILABLE'
303: );
304: END IF;

Line 364: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

360: AND serial_number = p_serial_number;
361: --AND current_status = 4; -- 4=> out of stores
362: BEGIN
363:
364: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
365: THEN
366: fnd_log.STRING
367: (fnd_log.level_procedure,
368: 'CSD.PLSQL.CSD_RECEIVE_UTIL.VALIDATE_RCV_INPUT.BEGIN',

Line 366: fnd_log.STRING

362: BEGIN
363:
364: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
365: THEN
366: fnd_log.STRING
367: (fnd_log.level_procedure,
368: 'CSD.PLSQL.CSD_RECEIVE_UTIL.VALIDATE_RCV_INPUT.BEGIN',
369: 'Entered VALIDATE_RCV_INPUT'
370: );

Line 367: (fnd_log.level_procedure,

363:
364: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
365: THEN
366: fnd_log.STRING
367: (fnd_log.level_procedure,
368: 'CSD.PLSQL.CSD_RECEIVE_UTIL.VALIDATE_RCV_INPUT.BEGIN',
369: 'Entered VALIDATE_RCV_INPUT'
370: );
371: END IF;

Line 453: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

449: CLOSE cur_serial_status;
450: END IF; -- end of if serail _number is not null
451:
452:
453: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
454: THEN
455: fnd_log.STRING (fnd_log.level_procedure,
456: 'CSD.PLSQL.CSD_RECEIVE_UTIL.VALIDATE_RCV_INPUT.END',
457: 'Leaving VALIDATE_RCV_INPUT'

Line 455: fnd_log.STRING (fnd_log.level_procedure,

451:
452:
453: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
454: THEN
455: fnd_log.STRING (fnd_log.level_procedure,
456: 'CSD.PLSQL.CSD_RECEIVE_UTIL.VALIDATE_RCV_INPUT.END',
457: 'Leaving VALIDATE_RCV_INPUT'
458: );
459: END IF;

Line 465: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)

461: EXCEPTION
462: WHEN fnd_api.g_exc_error
463: THEN
464: x_return_status := fnd_api.g_ret_sts_error;
465: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)
466: THEN
467: fnd_log.STRING (fnd_log.level_error,
468: 'CSD.PLSQL.CSD_RECEIVE_UTIL.VALIDATE_RCV_INPUT',
469: 'EXC_ERROR in validate_rcv_input '

Line 467: fnd_log.STRING (fnd_log.level_error,

463: THEN
464: x_return_status := fnd_api.g_ret_sts_error;
465: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)
466: THEN
467: fnd_log.STRING (fnd_log.level_error,
468: 'CSD.PLSQL.CSD_RECEIVE_UTIL.VALIDATE_RCV_INPUT',
469: 'EXC_ERROR in validate_rcv_input '
470: );
471: END IF;

Line 481: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)

477: THEN
478: fnd_msg_pub.add_exc_msg (g_pkg_name, l_c_api_name);
479: END IF;
480:
481: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
482: THEN
483: fnd_log.STRING (fnd_log.level_unexpected,
484: 'CSD.PLSQL.CSD_RECEIVE_UTIL.VALIDATE_RCV_INPUT',
485: 'SQL Message in validate_rcv_input[' || SQLERRM || ']'

Line 483: fnd_log.STRING (fnd_log.level_unexpected,

479: END IF;
480:
481: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
482: THEN
483: fnd_log.STRING (fnd_log.level_unexpected,
484: 'CSD.PLSQL.CSD_RECEIVE_UTIL.VALIDATE_RCV_INPUT',
485: 'SQL Message in validate_rcv_input[' || SQLERRM || ']'
486: );
487: END IF;

Line 557: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

553:
554: BEGIN
555:
556:
557: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
558: THEN
559: fnd_log.STRING (fnd_log.level_procedure,
560: 'CSD.PLSQL.CSD_RECEIVE_UTIL.CHECK_RCV_ERRORS.BEGIN',
561: 'Entered CHECK_RCV_ERRORS'

Line 559: fnd_log.STRING (fnd_log.level_procedure,

555:
556:
557: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
558: THEN
559: fnd_log.STRING (fnd_log.level_procedure,
560: 'CSD.PLSQL.CSD_RECEIVE_UTIL.CHECK_RCV_ERRORS.BEGIN',
561: 'Entered CHECK_RCV_ERRORS'
562: );
563: END IF;

Line 644: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

640: if(cur_rcv_lines%ISOPEN) then
641: close cur_rcv_lines;
642: end if;
643:
644: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
645: THEN
646: fnd_log.STRING (fnd_log.level_procedure,
647: 'CSD.PLSQL.CSD_RECEIVE_UTIL.CHECK_RCV_ERRORS.END',
648: 'Leaving CHECK_RCV_ERRORS'

Line 646: fnd_log.STRING (fnd_log.level_procedure,

642: end if;
643:
644: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
645: THEN
646: fnd_log.STRING (fnd_log.level_procedure,
647: 'CSD.PLSQL.CSD_RECEIVE_UTIL.CHECK_RCV_ERRORS.END',
648: 'Leaving CHECK_RCV_ERRORS'
649: );
650: END IF;

Line 661: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)

657: THEN
658: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
659: END IF;
660:
661: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
662: THEN
663: fnd_log.STRING (fnd_log.level_unexpected,
664: 'CSD.PLSQL.CSD_RECEIVE_UTIL.CHECK_RCV_ERRORS',
665: 'SQL Error Message in check_rcv_errors[' || SQLERRM || ']'

Line 663: fnd_log.STRING (fnd_log.level_unexpected,

659: END IF;
660:
661: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
662: THEN
663: fnd_log.STRING (fnd_log.level_unexpected,
664: 'CSD.PLSQL.CSD_RECEIVE_UTIL.CHECK_RCV_ERRORS',
665: 'SQL Error Message in check_rcv_errors[' || SQLERRM || ']'
666: );
667: END IF;

Line 698: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

694: AND ROWNUM = 1;
695:
696: l_emp_id NUMBER;
697: BEGIN
698: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
699: THEN
700: fnd_log.STRING (fnd_log.level_procedure,
701: 'CSD.PLSQL.CSD_RECEIVE_UTIL.GET_EMPLOYEE_ID.BEGIN',
702: 'Entered get_employee_id'

Line 700: fnd_log.STRING (fnd_log.level_procedure,

696: l_emp_id NUMBER;
697: BEGIN
698: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
699: THEN
700: fnd_log.STRING (fnd_log.level_procedure,
701: 'CSD.PLSQL.CSD_RECEIVE_UTIL.GET_EMPLOYEE_ID.BEGIN',
702: 'Entered get_employee_id'
703: );
704: END IF;

Line 729: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

725: END IF;
726:
727: CLOSE cur_get_employee_id;
728:
729: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
730: THEN
731: fnd_log.STRING (fnd_log.level_procedure,
732: 'CSD.PLSQL.CSD_RECEIVE_UTIL.GET_EMPLOYEE_ID.END',
733: 'Leaving get_employee_id'

Line 731: fnd_log.STRING (fnd_log.level_procedure,

727: CLOSE cur_get_employee_id;
728:
729: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
730: THEN
731: fnd_log.STRING (fnd_log.level_procedure,
732: 'CSD.PLSQL.CSD_RECEIVE_UTIL.GET_EMPLOYEE_ID.END',
733: 'Leaving get_employee_id'
734: );
735: END IF;

Line 739: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

735: END IF;
736: EXCEPTION
737: WHEN fnd_api.g_exc_unexpected_error
738: THEN
739: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
740: THEN
741: fnd_log.STRING (fnd_log.level_exception,
742: 'CSD.PLSQL.CSD_RECEIVE_UTIL.GET_EMPLOYEE_ID',
743: 'EXC_UNEXPECTED_ERROR in get_employee_id'

Line 741: fnd_log.STRING (fnd_log.level_exception,

737: WHEN fnd_api.g_exc_unexpected_error
738: THEN
739: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
740: THEN
741: fnd_log.STRING (fnd_log.level_exception,
742: 'CSD.PLSQL.CSD_RECEIVE_UTIL.GET_EMPLOYEE_ID',
743: 'EXC_UNEXPECTED_ERROR in get_employee_id'
744: );
745: END IF;

Line 750: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)

746:
747: RAISE;
748: WHEN OTHERS
749: THEN
750: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
751: THEN
752: fnd_log.STRING (fnd_log.level_unexpected,
753: 'CSD.PLSQL.CSD_RECEIVE_UTIL.GET_EMPLOYEE_ID',
754: 'SQL MEssage in get_employee_id[' || SQLERRM

Line 752: fnd_log.STRING (fnd_log.level_unexpected,

748: WHEN OTHERS
749: THEN
750: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
751: THEN
752: fnd_log.STRING (fnd_log.level_unexpected,
753: 'CSD.PLSQL.CSD_RECEIVE_UTIL.GET_EMPLOYEE_ID',
754: 'SQL MEssage in get_employee_id[' || SQLERRM
755: || ']'
756: );

Line 841: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

837: l_category_set NUMBER;
838:
839: BEGIN
840:
841: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
842: THEN
843: fnd_log.STRING
844: (fnd_log.level_procedure,
845: 'CSD.PLSQL.CSD_RECEIVE_UTIL.GET_RCV_ITEM_PARAMS.BEGIN',

Line 843: fnd_log.STRING

839: BEGIN
840:
841: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
842: THEN
843: fnd_log.STRING
844: (fnd_log.level_procedure,
845: 'CSD.PLSQL.CSD_RECEIVE_UTIL.GET_RCV_ITEM_PARAMS.BEGIN',
846: 'Entered get_rcv_item_params'
847: );

Line 844: (fnd_log.level_procedure,

840:
841: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
842: THEN
843: fnd_log.STRING
844: (fnd_log.level_procedure,
845: 'CSD.PLSQL.CSD_RECEIVE_UTIL.GET_RCV_ITEM_PARAMS.BEGIN',
846: 'Entered get_rcv_item_params'
847: );
848: END IF;

Line 939: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

935: END IF;
936: CLOSE cur_get_unit_of_measure;
937:
938:
939: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
940: THEN
941: fnd_log.STRING
942: (fnd_log.level_procedure,
943: 'CSD.PLSQL.CSD_RECEIVE_UTIL.GET_RCV_ITEM_PARAMS.END',

Line 941: fnd_log.STRING

937:
938:
939: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
940: THEN
941: fnd_log.STRING
942: (fnd_log.level_procedure,
943: 'CSD.PLSQL.CSD_RECEIVE_UTIL.GET_RCV_ITEM_PARAMS.END',
944: 'Leaving get_rcv_item_params'
945: );

Line 942: (fnd_log.level_procedure,

938:
939: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
940: THEN
941: fnd_log.STRING
942: (fnd_log.level_procedure,
943: 'CSD.PLSQL.CSD_RECEIVE_UTIL.GET_RCV_ITEM_PARAMS.END',
944: 'Leaving get_rcv_item_params'
945: );
946: END IF;

Line 951: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

947:
948: EXCEPTION
949: WHEN fnd_api.g_exc_unexpected_error
950: THEN
951: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
952: THEN
953: fnd_log.STRING (fnd_log.level_exception,
954: 'CSD.PLSQL.CSD_RECEIVE_UTIL.GET_RCV_ITEM_PARAMS',
955: 'EXC_UNEXPECTED_ERROR in get_rcv_item_params'

Line 953: fnd_log.STRING (fnd_log.level_exception,

949: WHEN fnd_api.g_exc_unexpected_error
950: THEN
951: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
952: THEN
953: fnd_log.STRING (fnd_log.level_exception,
954: 'CSD.PLSQL.CSD_RECEIVE_UTIL.GET_RCV_ITEM_PARAMS',
955: 'EXC_UNEXPECTED_ERROR in get_rcv_item_params'
956: );
957: END IF;

Line 962: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)

958:
959: RAISE;
960: WHEN OTHERS
961: THEN
962: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
963: THEN
964: fnd_log.STRING (fnd_log.level_unexpected,
965: 'CSD.PLSQL.CSD_RECEIVE_UTIL.GET_RCV_ITEM_PARAMS',
966: 'SQL Error Message in get_rcv_item_params ['

Line 964: fnd_log.STRING (fnd_log.level_unexpected,

960: WHEN OTHERS
961: THEN
962: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
963: THEN
964: fnd_log.STRING (fnd_log.level_unexpected,
965: 'CSD.PLSQL.CSD_RECEIVE_UTIL.GET_RCV_ITEM_PARAMS',
966: 'SQL Error Message in get_rcv_item_params ['
967: || SQLERRM
968: || ']'