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 124: fnd_log.string

120: END IF;
121: l_msg_count := FND_MSG_PUB.count_msg;
122: -- Log API entry point
123: IF (l_log_procedure >= l_log_current_level)THEN
124: fnd_log.string
125: (
126: fnd_log.level_procedure,
127: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
128: 'At the start of PL SQL procedure '

Line 126: fnd_log.level_procedure,

122: -- Log API entry point
123: IF (l_log_procedure >= l_log_current_level)THEN
124: fnd_log.string
125: (
126: fnd_log.level_procedure,
127: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
128: 'At the start of PL SQL procedure '
129: );
130: END IF;

Line 144: fnd_log.string

140: -- Invalid value for supply demand code.
141: FND_MSG_PUB.add;
142: -- log the error
143: IF (l_log_statement >= l_log_current_level)THEN
144: fnd_log.string
145: (
146: fnd_log.level_statement,
147: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
148: --'The reservations should be against demand, not supply.'

Line 146: fnd_log.level_statement,

142: -- log the error
143: IF (l_log_statement >= l_log_current_level)THEN
144: fnd_log.string
145: (
146: fnd_log.level_statement,
147: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
148: --'The reservations should be against demand, not supply.'
149: 'Invalid value for supply demand code.'
150: );

Line 164: fnd_log.string

160: FND_MSG_PUB.add;
161: -- Demand Line Detail is required for CMRO reservations
162: -- log the error
163: IF (l_log_statement >= l_log_current_level)THEN
164: fnd_log.string
165: (
166: fnd_log.level_statement,
167: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
168: 'Demand Line Detail is required for CMRO reservations'

Line 166: fnd_log.level_statement,

162: -- log the error
163: IF (l_log_statement >= l_log_current_level)THEN
164: fnd_log.string
165: (
166: fnd_log.level_statement,
167: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
168: 'Demand Line Detail is required for CMRO reservations'
169: );
170: END IF;

Line 197: fnd_log.string

193: -- AnRaj: Modified code, we are not subtracting reserved quantity from CMRO because this is being done in WMS also
194: x_available_quantity := l_requested_quantity - l_completed_quantity ;
195:
196: IF (l_log_statement >= l_log_current_level)THEN
197: fnd_log.string
198: (
199: fnd_log.level_statement,
200: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
201: 'x_available_quantity' || x_available_quantity

Line 199: fnd_log.level_statement,

195:
196: IF (l_log_statement >= l_log_current_level)THEN
197: fnd_log.string
198: (
199: fnd_log.level_statement,
200: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
201: 'x_available_quantity' || x_available_quantity
202: );
203: END IF;

Line 214: fnd_log.string

210: FND_MSG_PUB.add;
211: -- Demand header is required for CMRO reservations
212: -- log the error
213: IF (l_log_statement >= l_log_current_level)THEN
214: fnd_log.string
215: (
216: fnd_log.level_statement,
217: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
218: 'Demand header is required for CMRO reservations'

Line 216: fnd_log.level_statement,

212: -- log the error
213: IF (l_log_statement >= l_log_current_level)THEN
214: fnd_log.string
215: (
216: fnd_log.level_statement,
217: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
218: 'Demand header is required for CMRO reservations'
219: );
220: END IF;

Line 236: fnd_log.string

232: --If Supply demand type is not equal to WIP then raise error, as this supply check is only applicable on WIP supply.
233: FND_MESSAGE.set_name( 'AHL', 'AHL_RSV_SUP_DEM_TYPE_INVLD' );
234: FND_MSG_PUB.add;
235: IF (l_log_statement >= l_log_current_level)THEN
236: fnd_log.string
237: (
238: fnd_log.level_statement,
239: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
240: 'Wrong value for Supply Demand Type.'

Line 238: fnd_log.level_statement,

234: FND_MSG_PUB.add;
235: IF (l_log_statement >= l_log_current_level)THEN
236: fnd_log.string
237: (
238: fnd_log.level_statement,
239: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
240: 'Wrong value for Supply Demand Type.'
241: );
242: END IF;

Line 255: fnd_log.string

251: END IF;
252:
253: --Start Logging
254: IF (l_log_statement >= l_log_current_level)THEN
255: fnd_log.string
256: (
257: fnd_log.level_statement,
258: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
259: 'x_available_quantity' || x_available_quantity

Line 257: fnd_log.level_statement,

253: --Start Logging
254: IF (l_log_statement >= l_log_current_level)THEN
255: fnd_log.string
256: (
257: fnd_log.level_statement,
258: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
259: 'x_available_quantity' || x_available_quantity
260: );
261: END IF;

Line 267: fnd_log.string

263:
264: END IF; -- p_supply_demand_code check
265:
266: IF (l_log_procedure >= l_log_current_level)THEN
267: fnd_log.string
268: (
269: fnd_log.level_procedure,
270: l_debug_module||'.end',
271: 'At the end of PLSQL procedure'

Line 269: fnd_log.level_procedure,

265:
266: IF (l_log_procedure >= l_log_current_level)THEN
267: fnd_log.string
268: (
269: fnd_log.level_procedure,
270: l_debug_module||'.end',
271: 'At the end of PLSQL procedure'
272: );
273: END IF;

Line 450: fnd_log.string

446: END IF;
447: l_msg_count := FND_MSG_PUB.count_msg;
448: -- Log API entry point
449: IF (l_log_procedure >= l_log_current_level)THEN
450: fnd_log.string
451: (
452: fnd_log.level_procedure,
453: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
454: 'At the start of PL SQL procedure '

Line 452: fnd_log.level_procedure,

448: -- Log API entry point
449: IF (l_log_procedure >= l_log_current_level)THEN
450: fnd_log.string
451: (
452: fnd_log.level_procedure,
453: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
454: 'At the start of PL SQL procedure '
455: );
456: END IF;

Line 460: fnd_log.string

456: END IF;
457:
458: -- log all the input parameters
459: IF (l_log_statement >= l_log_current_level)THEN
460: fnd_log.string
461: (
462: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
463: 'p_organization_id-->' || p_organization_id
464: );

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

458: -- log all the input parameters
459: IF (l_log_statement >= l_log_current_level)THEN
460: fnd_log.string
461: (
462: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
463: 'p_organization_id-->' || p_organization_id
464: );
465: fnd_log.string
466: (

Line 465: fnd_log.string

461: (
462: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
463: 'p_organization_id-->' || p_organization_id
464: );
465: fnd_log.string
466: (
467: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
468: 'p_item_id-->' || p_item_id
469: );

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

463: 'p_organization_id-->' || p_organization_id
464: );
465: fnd_log.string
466: (
467: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
468: 'p_item_id-->' || p_item_id
469: );
470: fnd_log.string
471: (

Line 470: fnd_log.string

466: (
467: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
468: 'p_item_id-->' || p_item_id
469: );
470: fnd_log.string
471: (
472: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
473: 'p_supply_demand_code-->' || p_supply_demand_code
474: );

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

468: 'p_item_id-->' || p_item_id
469: );
470: fnd_log.string
471: (
472: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
473: 'p_supply_demand_code-->' || p_supply_demand_code
474: );
475: fnd_log.string
476: (

Line 475: fnd_log.string

471: (
472: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
473: 'p_supply_demand_code-->' || p_supply_demand_code
474: );
475: fnd_log.string
476: (
477: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
478: 'p_supply_demand_type_id-->' || p_supply_demand_type_id
479: );

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

473: 'p_supply_demand_code-->' || p_supply_demand_code
474: );
475: fnd_log.string
476: (
477: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
478: 'p_supply_demand_type_id-->' || p_supply_demand_type_id
479: );
480: fnd_log.string
481: (

Line 480: fnd_log.string

476: (
477: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
478: 'p_supply_demand_type_id-->' || p_supply_demand_type_id
479: );
480: fnd_log.string
481: (
482: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
483: 'p_supply_demand_header_id-->' || p_supply_demand_header_id
484: );

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

478: 'p_supply_demand_type_id-->' || p_supply_demand_type_id
479: );
480: fnd_log.string
481: (
482: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
483: 'p_supply_demand_header_id-->' || p_supply_demand_header_id
484: );
485: fnd_log.string
486: (

Line 485: fnd_log.string

481: (
482: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
483: 'p_supply_demand_header_id-->' || p_supply_demand_header_id
484: );
485: fnd_log.string
486: (
487: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
488: 'p_supply_demand_line_id-->' || p_supply_demand_line_id
489: );

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

483: 'p_supply_demand_header_id-->' || p_supply_demand_header_id
484: );
485: fnd_log.string
486: (
487: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
488: 'p_supply_demand_line_id-->' || p_supply_demand_line_id
489: );
490: fnd_log.string
491: (

Line 490: fnd_log.string

486: (
487: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
488: 'p_supply_demand_line_id-->' || p_supply_demand_line_id
489: );
490: fnd_log.string
491: (
492: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
493: 'p_supply_demand_line_detail-->' || p_supply_demand_line_detail
494: );

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

488: 'p_supply_demand_line_id-->' || p_supply_demand_line_id
489: );
490: fnd_log.string
491: (
492: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
493: 'p_supply_demand_line_detail-->' || p_supply_demand_line_detail
494: );
495: fnd_log.string
496: (

Line 495: fnd_log.string

491: (
492: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
493: 'p_supply_demand_line_detail-->' || p_supply_demand_line_detail
494: );
495: fnd_log.string
496: (
497: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
498: 'p_demand_ship_date-->' || p_demand_ship_date
499: );

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

493: 'p_supply_demand_line_detail-->' || p_supply_demand_line_detail
494: );
495: fnd_log.string
496: (
497: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
498: 'p_demand_ship_date-->' || p_demand_ship_date
499: );
500: fnd_log.string
501: (

Line 500: fnd_log.string

496: (
497: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
498: 'p_demand_ship_date-->' || p_demand_ship_date
499: );
500: fnd_log.string
501: (
502: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
503: 'p_expected_receipt_date-->' || p_expected_receipt_date
504: );

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

498: 'p_demand_ship_date-->' || p_demand_ship_date
499: );
500: fnd_log.string
501: (
502: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
503: 'p_expected_receipt_date-->' || p_expected_receipt_date
504: );
505: END IF;
506:

Line 518: fnd_log.string

514: FND_MSG_PUB.add;
515: --Invalid value for supply demand code.
516: -- log the error
517: IF (l_log_statement >= l_log_current_level)THEN
518: fnd_log.string
519: (
520: fnd_log.level_statement,
521: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
522: --'The reservations should be against demand, not supply.'

Line 520: fnd_log.level_statement,

516: -- log the error
517: IF (l_log_statement >= l_log_current_level)THEN
518: fnd_log.string
519: (
520: fnd_log.level_statement,
521: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
522: --'The reservations should be against demand, not supply.'
523: 'Invalid value for supply demand code.'
524: );

Line 538: fnd_log.string

534: FND_MSG_PUB.add;
535: -- Demand header is required for CMRO reservations
536: -- log the error
537: IF (l_log_statement >= l_log_current_level)THEN
538: fnd_log.string
539: (
540: fnd_log.level_statement,
541: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
542: 'Demand header is required for CMRO reservations'

Line 540: fnd_log.level_statement,

536: -- log the error
537: IF (l_log_statement >= l_log_current_level)THEN
538: fnd_log.string
539: (
540: fnd_log.level_statement,
541: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
542: 'Demand header is required for CMRO reservations'
543: );
544: END IF;

Line 555: fnd_log.string

551: FND_MSG_PUB.add;
552: -- Organization is mandatory in validate_supply_demand.
553: -- log the error
554: IF (l_log_statement >= l_log_current_level)THEN
555: fnd_log.string
556: (
557: fnd_log.level_statement,
558: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
559: 'Organization is mandatory in validate_supply_demand.'

Line 557: fnd_log.level_statement,

553: -- log the error
554: IF (l_log_statement >= l_log_current_level)THEN
555: fnd_log.string
556: (
557: fnd_log.level_statement,
558: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
559: 'Organization is mandatory in validate_supply_demand.'
560: );
561: END IF;

Line 573: fnd_log.string

569: FND_MSG_PUB.add;
570: -- Item ID is mandatory in validate_supply_demand.
571: -- log the error
572: IF (l_log_statement >= l_log_current_level)THEN
573: fnd_log.string
574: (
575: fnd_log.level_statement,
576: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
577: 'Item ID is mandatory in validate_supply_demand.'

Line 575: fnd_log.level_statement,

571: -- log the error
572: IF (l_log_statement >= l_log_current_level)THEN
573: fnd_log.string
574: (
575: fnd_log.level_statement,
576: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
577: 'Item ID is mandatory in validate_supply_demand.'
578: );
579: END IF;

Line 592: fnd_log.string

588: FND_MSG_PUB.add;
589: -- Demand Line is required for CMRO reservations
590: -- log the error
591: IF (l_log_statement >= l_log_current_level)THEN
592: fnd_log.string
593: (
594: fnd_log.level_statement,
595: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
596: 'Demand Line is required for CMRO reservations'

Line 594: fnd_log.level_statement,

590: -- log the error
591: IF (l_log_statement >= l_log_current_level)THEN
592: fnd_log.string
593: (
594: fnd_log.level_statement,
595: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
596: 'Demand Line is required for CMRO reservations'
597: );
598: END IF;

Line 609: fnd_log.string

605: FND_MSG_PUB.add;
606: -- Demand Line Detail is required for CMRO reservations
607: -- log the error
608: IF (l_log_statement >= l_log_current_level)THEN
609: fnd_log.string
610: (
611: fnd_log.level_statement,
612: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
613: 'Demand Line Detail is required for CMRO reservations'

Line 611: fnd_log.level_statement,

607: -- log the error
608: IF (l_log_statement >= l_log_current_level)THEN
609: fnd_log.string
610: (
611: fnd_log.level_statement,
612: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
613: 'Demand Line Detail is required for CMRO reservations'
614: );
615: END IF;

Line 640: fnd_log.string

636: ELSE
637: FND_MESSAGE.set_name( 'AHL', 'AHL_RSV_SUP_DEM_TYPE_INVLD' );
638: FND_MSG_PUB.add;
639: IF (l_log_statement >= l_log_current_level)THEN
640: fnd_log.string
641: (
642: fnd_log.level_statement,
643: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
644: 'Wrong value for Supply Demand Type.'

Line 642: fnd_log.level_statement,

638: FND_MSG_PUB.add;
639: IF (l_log_statement >= l_log_current_level)THEN
640: fnd_log.string
641: (
642: fnd_log.level_statement,
643: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
644: 'Wrong value for Supply Demand Type.'
645: );
646: END IF;

Line 672: fnd_log.string

668: --If Supply demand type is not equal to WIP then raise error, as this supply check is only applicable on WIP supply.
669: FND_MESSAGE.set_name( 'AHL', 'AHL_RSV_SUP_DEM_TYPE_INVLD' );
670: FND_MSG_PUB.add;
671: IF (l_log_statement >= l_log_current_level)THEN
672: fnd_log.string
673: (
674: fnd_log.level_statement,
675: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
676: 'Wrong value for Supply Demand Type.'

Line 674: fnd_log.level_statement,

670: FND_MSG_PUB.add;
671: IF (l_log_statement >= l_log_current_level)THEN
672: fnd_log.string
673: (
674: fnd_log.level_statement,
675: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
676: 'Wrong value for Supply Demand Type.'
677: );
678: END IF;

Line 691: fnd_log.string

687:
688: END IF; -- end if for p_supply_demand_code check
689: --sukhwsin::Marshling enhancements - changes ends
690: IF (l_log_statement >= l_log_current_level)THEN
691: fnd_log.string
692: (
693: fnd_log.level_statement,
694: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
695: 'Return Value: x_valid_status' || x_valid_status

Line 693: fnd_log.level_statement,

689: --sukhwsin::Marshling enhancements - changes ends
690: IF (l_log_statement >= l_log_current_level)THEN
691: fnd_log.string
692: (
693: fnd_log.level_statement,
694: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
695: 'Return Value: x_valid_status' || x_valid_status
696: );
697: END IF;

Line 702: fnd_log.string

698:
699:
700: -- End logging
701: IF (l_log_procedure >= l_log_current_level)THEN
702: fnd_log.string
703: (
704: fnd_log.level_procedure,
705: l_debug_module||'.end',
706: 'At the end of PLSQL procedure'

Line 704: fnd_log.level_procedure,

700: -- End logging
701: IF (l_log_procedure >= l_log_current_level)THEN
702: fnd_log.string
703: (
704: fnd_log.level_procedure,
705: l_debug_module||'.end',
706: 'At the end of PLSQL procedure'
707: );
708: END IF;

Line 725: fnd_log.string

721: p_data => x_msg_data,
722: p_encoded => FND_API.G_FALSE
723: );
724: IF (l_log_procedure >= l_log_current_level)THEN
725: fnd_log.string
726: (
727: fnd_log.level_procedure,
728: l_debug_module||'.end',
729: 'At the last line PLSQL procedure, return status := '|| x_return_status ||

Line 727: fnd_log.level_procedure,

723: );
724: IF (l_log_procedure >= l_log_current_level)THEN
725: fnd_log.string
726: (
727: fnd_log.level_procedure,
728: l_debug_module||'.end',
729: 'At the last line PLSQL procedure, return status := '|| x_return_status ||
730: ' and x_valid_status = ' || x_valid_status
731: );