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

Line 7: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;

3:
4: ------------------------------------
5: -- Common constants and variables --
6: ------------------------------------
7: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
8: l_log_statement NUMBER := fnd_log.level_statement;
9: l_log_procedure NUMBER := fnd_log.level_procedure;
10: l_log_error NUMBER := fnd_log.level_error;
11: l_log_unexpected NUMBER := fnd_log.level_unexpected;

Line 8: l_log_statement NUMBER := fnd_log.level_statement;

4: ------------------------------------
5: -- Common constants and variables --
6: ------------------------------------
7: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
8: l_log_statement NUMBER := fnd_log.level_statement;
9: l_log_procedure NUMBER := fnd_log.level_procedure;
10: l_log_error NUMBER := fnd_log.level_error;
11: l_log_unexpected NUMBER := fnd_log.level_unexpected;
12:

Line 9: l_log_procedure NUMBER := fnd_log.level_procedure;

5: -- Common constants and variables --
6: ------------------------------------
7: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
8: l_log_statement NUMBER := fnd_log.level_statement;
9: l_log_procedure NUMBER := fnd_log.level_procedure;
10: l_log_error NUMBER := fnd_log.level_error;
11: l_log_unexpected NUMBER := fnd_log.level_unexpected;
12:
13:

Line 10: l_log_error NUMBER := fnd_log.level_error;

6: ------------------------------------
7: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
8: l_log_statement NUMBER := fnd_log.level_statement;
9: l_log_procedure NUMBER := fnd_log.level_procedure;
10: l_log_error NUMBER := fnd_log.level_error;
11: l_log_unexpected NUMBER := fnd_log.level_unexpected;
12:
13:
14: -- The purpose of this API is to get the final availability of the document line for which the reservation is being

Line 11: l_log_unexpected NUMBER := fnd_log.level_unexpected;

7: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
8: l_log_statement NUMBER := fnd_log.level_statement;
9: l_log_procedure NUMBER := fnd_log.level_procedure;
10: l_log_error NUMBER := fnd_log.level_error;
11: l_log_unexpected NUMBER := fnd_log.level_unexpected;
12:
13:
14: -- The purpose of this API is to get the final availability of the document line for which the reservation is being
15: -- created/ modified.This procedure will be called by the inventory APIs to get the expected availability at the

Line 45: l_log_current_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

41: , x_source_primary_uom_code OUT NOCOPY VARCHAR2
42: )
43: IS
44: -- Variables for logging
45: l_log_current_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
46: l_log_procedure NUMBER := FND_LOG.LEVEL_PROCEDURE;
47: -- Declare local variables
48: l_api_name CONSTANT VARCHAR2(30) := 'get_available_supply_demand';
49: l_api_version CONSTANT NUMBER := 1.0;

Line 46: l_log_procedure NUMBER := FND_LOG.LEVEL_PROCEDURE;

42: )
43: IS
44: -- Variables for logging
45: l_log_current_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
46: l_log_procedure NUMBER := FND_LOG.LEVEL_PROCEDURE;
47: -- Declare local variables
48: l_api_name CONSTANT VARCHAR2(30) := 'get_available_supply_demand';
49: l_api_version CONSTANT NUMBER := 1.0;
50: l_init_msg_list VARCHAR2(1) := 'F';

Line 103: fnd_log.string

99: END IF;
100:
101: -- Log API entry point
102: IF (l_log_procedure >= l_log_current_level)THEN
103: fnd_log.string
104: (
105: fnd_log.level_procedure,
106: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
107: 'At the start of PL SQL procedure '

Line 105: fnd_log.level_procedure,

101: -- Log API entry point
102: IF (l_log_procedure >= l_log_current_level)THEN
103: fnd_log.string
104: (
105: fnd_log.level_procedure,
106: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
107: 'At the start of PL SQL procedure '
108: );
109: END IF;

Line 119: fnd_log.string

115: -- The reservations should be against demand, not supply.
116: FND_MSG_PUB.add;
117: -- log the error
118: IF (l_log_statement >= l_log_current_level)THEN
119: fnd_log.string
120: (
121: fnd_log.level_statement,
122: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
123: 'The reservations should be against demand, not supply.'

Line 121: fnd_log.level_statement,

117: -- log the error
118: IF (l_log_statement >= l_log_current_level)THEN
119: fnd_log.string
120: (
121: fnd_log.level_statement,
122: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
123: 'The reservations should be against demand, not supply.'
124: );
125: END IF;

Line 136: fnd_log.string

132: FND_MSG_PUB.add;
133: -- Demand Line Detail is required for CMRO reservations
134: -- log the error
135: IF (l_log_statement >= l_log_current_level)THEN
136: fnd_log.string
137: (
138: fnd_log.level_statement,
139: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
140: 'Demand Line Detail is required for CMRO reservations'

Line 138: fnd_log.level_statement,

134: -- log the error
135: IF (l_log_statement >= l_log_current_level)THEN
136: fnd_log.string
137: (
138: fnd_log.level_statement,
139: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
140: 'Demand Line Detail is required for CMRO reservations'
141: );
142: END IF;

Line 169: fnd_log.string

165: -- AnRaj: Modified code, we are not subtracting reserved quantity from CMRO because this is being done in WMS also
166: x_available_quantity := l_requested_quantity - l_completed_quantity ;
167:
168: IF (l_log_statement >= l_log_current_level)THEN
169: fnd_log.string
170: (
171: fnd_log.level_statement,
172: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
173: 'x_available_quantity' || x_available_quantity

Line 171: fnd_log.level_statement,

167:
168: IF (l_log_statement >= l_log_current_level)THEN
169: fnd_log.string
170: (
171: fnd_log.level_statement,
172: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
173: 'x_available_quantity' || x_available_quantity
174: );
175: END IF;

Line 179: fnd_log.string

175: END IF;
176:
177: -- End logging
178: IF (l_log_procedure >= l_log_current_level)THEN
179: fnd_log.string
180: (
181: fnd_log.level_procedure,
182: l_debug_module||'.end',
183: 'At the end of PLSQL procedure'

Line 181: fnd_log.level_procedure,

177: -- End logging
178: IF (l_log_procedure >= l_log_current_level)THEN
179: fnd_log.string
180: (
181: fnd_log.level_procedure,
182: l_debug_module||'.end',
183: 'At the end of PLSQL procedure'
184: );
185: END IF;

Line 333: fnd_log.string

329: FND_MSG_PUB.INITIALIZE;
330: END IF;
331: -- Log API entry point
332: IF (l_log_procedure >= l_log_current_level)THEN
333: fnd_log.string
334: (
335: fnd_log.level_procedure,
336: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
337: 'At the start of PL SQL procedure '

Line 335: fnd_log.level_procedure,

331: -- Log API entry point
332: IF (l_log_procedure >= l_log_current_level)THEN
333: fnd_log.string
334: (
335: fnd_log.level_procedure,
336: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
337: 'At the start of PL SQL procedure '
338: );
339: END IF;

Line 343: fnd_log.string

339: END IF;
340:
341: -- log all the input parameters
342: IF (l_log_statement >= l_log_current_level)THEN
343: fnd_log.string
344: (
345: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
346: 'p_organization_id-->' || p_organization_id
347: );

Line 345: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,

341: -- log all the input parameters
342: IF (l_log_statement >= l_log_current_level)THEN
343: fnd_log.string
344: (
345: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
346: 'p_organization_id-->' || p_organization_id
347: );
348: fnd_log.string
349: (

Line 348: fnd_log.string

344: (
345: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
346: 'p_organization_id-->' || p_organization_id
347: );
348: fnd_log.string
349: (
350: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
351: 'p_item_id-->' || p_item_id
352: );

Line 350: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,

346: 'p_organization_id-->' || p_organization_id
347: );
348: fnd_log.string
349: (
350: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
351: 'p_item_id-->' || p_item_id
352: );
353: fnd_log.string
354: (

Line 353: fnd_log.string

349: (
350: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
351: 'p_item_id-->' || p_item_id
352: );
353: fnd_log.string
354: (
355: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
356: 'p_supply_demand_code-->' || p_supply_demand_code
357: );

Line 355: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,

351: 'p_item_id-->' || p_item_id
352: );
353: fnd_log.string
354: (
355: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
356: 'p_supply_demand_code-->' || p_supply_demand_code
357: );
358: fnd_log.string
359: (

Line 358: fnd_log.string

354: (
355: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
356: 'p_supply_demand_code-->' || p_supply_demand_code
357: );
358: fnd_log.string
359: (
360: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
361: 'p_supply_demand_type_id-->' || p_supply_demand_type_id
362: );

Line 360: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,

356: 'p_supply_demand_code-->' || p_supply_demand_code
357: );
358: fnd_log.string
359: (
360: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
361: 'p_supply_demand_type_id-->' || p_supply_demand_type_id
362: );
363: fnd_log.string
364: (

Line 363: fnd_log.string

359: (
360: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
361: 'p_supply_demand_type_id-->' || p_supply_demand_type_id
362: );
363: fnd_log.string
364: (
365: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
366: 'p_supply_demand_header_id-->' || p_supply_demand_header_id
367: );

Line 365: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,

361: 'p_supply_demand_type_id-->' || p_supply_demand_type_id
362: );
363: fnd_log.string
364: (
365: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
366: 'p_supply_demand_header_id-->' || p_supply_demand_header_id
367: );
368: fnd_log.string
369: (

Line 368: fnd_log.string

364: (
365: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
366: 'p_supply_demand_header_id-->' || p_supply_demand_header_id
367: );
368: fnd_log.string
369: (
370: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
371: 'p_supply_demand_line_id-->' || p_supply_demand_line_id
372: );

Line 370: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,

366: 'p_supply_demand_header_id-->' || p_supply_demand_header_id
367: );
368: fnd_log.string
369: (
370: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
371: 'p_supply_demand_line_id-->' || p_supply_demand_line_id
372: );
373: fnd_log.string
374: (

Line 373: fnd_log.string

369: (
370: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
371: 'p_supply_demand_line_id-->' || p_supply_demand_line_id
372: );
373: fnd_log.string
374: (
375: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
376: 'p_supply_demand_line_detail-->' || p_supply_demand_line_detail
377: );

Line 375: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,

371: 'p_supply_demand_line_id-->' || p_supply_demand_line_id
372: );
373: fnd_log.string
374: (
375: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
376: 'p_supply_demand_line_detail-->' || p_supply_demand_line_detail
377: );
378: fnd_log.string
379: (

Line 378: fnd_log.string

374: (
375: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
376: 'p_supply_demand_line_detail-->' || p_supply_demand_line_detail
377: );
378: fnd_log.string
379: (
380: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
381: 'p_demand_ship_date-->' || p_demand_ship_date
382: );

Line 380: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,

376: 'p_supply_demand_line_detail-->' || p_supply_demand_line_detail
377: );
378: fnd_log.string
379: (
380: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
381: 'p_demand_ship_date-->' || p_demand_ship_date
382: );
383: fnd_log.string
384: (

Line 383: fnd_log.string

379: (
380: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
381: 'p_demand_ship_date-->' || p_demand_ship_date
382: );
383: fnd_log.string
384: (
385: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
386: 'p_expected_receipt_date-->' || p_expected_receipt_date
387: );

Line 385: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,

381: 'p_demand_ship_date-->' || p_demand_ship_date
382: );
383: fnd_log.string
384: (
385: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
386: 'p_expected_receipt_date-->' || p_expected_receipt_date
387: );
388: END IF;
389:

Line 398: fnd_log.string

394: FND_MSG_PUB.add;
395: --The reservations should be against demand, not supply.
396: -- log the error
397: IF (l_log_statement >= l_log_current_level)THEN
398: fnd_log.string
399: (
400: fnd_log.level_statement,
401: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
402: 'The reservations should be against demand, not supply.'

Line 400: fnd_log.level_statement,

396: -- log the error
397: IF (l_log_statement >= l_log_current_level)THEN
398: fnd_log.string
399: (
400: fnd_log.level_statement,
401: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
402: 'The reservations should be against demand, not supply.'
403: );
404: END IF;

Line 415: fnd_log.string

411: FND_MSG_PUB.add;
412: -- Demand header is required for CMRO reservations
413: -- log the error
414: IF (l_log_statement >= l_log_current_level)THEN
415: fnd_log.string
416: (
417: fnd_log.level_statement,
418: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
419: 'Demand header is required for CMRO reservations'

Line 417: fnd_log.level_statement,

413: -- log the error
414: IF (l_log_statement >= l_log_current_level)THEN
415: fnd_log.string
416: (
417: fnd_log.level_statement,
418: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
419: 'Demand header is required for CMRO reservations'
420: );
421: END IF;

Line 432: fnd_log.string

428: FND_MSG_PUB.add;
429: -- Demand Line is required for CMRO reservations
430: -- log the error
431: IF (l_log_statement >= l_log_current_level)THEN
432: fnd_log.string
433: (
434: fnd_log.level_statement,
435: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
436: 'Demand Line is required for CMRO reservations'

Line 434: fnd_log.level_statement,

430: -- log the error
431: IF (l_log_statement >= l_log_current_level)THEN
432: fnd_log.string
433: (
434: fnd_log.level_statement,
435: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
436: 'Demand Line is required for CMRO reservations'
437: );
438: END IF;

Line 449: fnd_log.string

445: FND_MSG_PUB.add;
446: -- Demand Line Detail is required for CMRO reservations
447: -- log the error
448: IF (l_log_statement >= l_log_current_level)THEN
449: fnd_log.string
450: (
451: fnd_log.level_statement,
452: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
453: 'Demand Line Detail is required for CMRO reservations'

Line 451: fnd_log.level_statement,

447: -- log the error
448: IF (l_log_statement >= l_log_current_level)THEN
449: fnd_log.string
450: (
451: fnd_log.level_statement,
452: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
453: 'Demand Line Detail is required for CMRO reservations'
454: );
455: END IF;

Line 466: fnd_log.string

462: FND_MSG_PUB.add;
463: -- Organization is mandatory in validate_supply_demand.
464: -- log the error
465: IF (l_log_statement >= l_log_current_level)THEN
466: fnd_log.string
467: (
468: fnd_log.level_statement,
469: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
470: 'Organization is mandatory in validate_supply_demand.'

Line 468: fnd_log.level_statement,

464: -- log the error
465: IF (l_log_statement >= l_log_current_level)THEN
466: fnd_log.string
467: (
468: fnd_log.level_statement,
469: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
470: 'Organization is mandatory in validate_supply_demand.'
471: );
472: END IF;

Line 484: fnd_log.string

480: FND_MSG_PUB.add;
481: -- Item ID is mandatory in validate_supply_demand.
482: -- log the error
483: IF (l_log_statement >= l_log_current_level)THEN
484: fnd_log.string
485: (
486: fnd_log.level_statement,
487: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
488: 'Item ID is mandatory in validate_supply_demand.'

Line 486: fnd_log.level_statement,

482: -- log the error
483: IF (l_log_statement >= l_log_current_level)THEN
484: fnd_log.string
485: (
486: fnd_log.level_statement,
487: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
488: 'Item ID is mandatory in validate_supply_demand.'
489: );
490: END IF;

Line 515: fnd_log.string

511: ELSE
512: FND_MESSAGE.set_name( 'AHL', 'AHL_RSV_SUP_DEM_TYPE_INVLD' );
513: FND_MSG_PUB.add;
514: IF (l_log_statement >= l_log_current_level)THEN
515: fnd_log.string
516: (
517: fnd_log.level_statement,
518: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
519: 'Wrong value for Supply Demand Type.'

Line 517: fnd_log.level_statement,

513: FND_MSG_PUB.add;
514: IF (l_log_statement >= l_log_current_level)THEN
515: fnd_log.string
516: (
517: fnd_log.level_statement,
518: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
519: 'Wrong value for Supply Demand Type.'
520: );
521: END IF;

Line 532: fnd_log.string

528: ELSE
529: x_valid_status := 'Y';
530: END IF;
531: IF (l_log_statement >= l_log_current_level)THEN
532: fnd_log.string
533: (
534: fnd_log.level_statement,
535: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
536: 'Return Value: x_valid_status' || x_valid_status

Line 534: fnd_log.level_statement,

530: END IF;
531: IF (l_log_statement >= l_log_current_level)THEN
532: fnd_log.string
533: (
534: fnd_log.level_statement,
535: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
536: 'Return Value: x_valid_status' || x_valid_status
537: );
538: END IF;

Line 543: fnd_log.string

539:
540:
541: -- End logging
542: IF (l_log_procedure >= l_log_current_level)THEN
543: fnd_log.string
544: (
545: fnd_log.level_procedure,
546: l_debug_module||'.end',
547: 'At the end of PLSQL procedure'

Line 545: fnd_log.level_procedure,

541: -- End logging
542: IF (l_log_procedure >= l_log_current_level)THEN
543: fnd_log.string
544: (
545: fnd_log.level_procedure,
546: l_debug_module||'.end',
547: 'At the end of PLSQL procedure'
548: );
549: END IF;