DBA Data[Home] [Help]

APPS.CS_MESSAGES_PKG dependencies on FND_LOG

Line 505: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level

501:
502: BEGIN
503: x_return_status := FND_API.G_RET_STS_SUCCESS;
504:
505: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
506: THEN
507: FND_LOG.String
508: (
509: FND_LOG.level_procedure

Line 507: FND_LOG.String

503: x_return_status := FND_API.G_RET_STS_SUCCESS;
504:
505: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
506: THEN
507: FND_LOG.String
508: (
509: FND_LOG.level_procedure
510: , L_LOG_MODULE || 'start'
511: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'

Line 509: FND_LOG.level_procedure

505: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
506: THEN
507: FND_LOG.String
508: (
509: FND_LOG.level_procedure
510: , L_LOG_MODULE || 'start'
511: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
512: );
513: FND_LOG.String

Line 513: FND_LOG.String

509: FND_LOG.level_procedure
510: , L_LOG_MODULE || 'start'
511: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
512: );
513: FND_LOG.String
514: (
515: FND_LOG.level_procedure
516: , L_LOG_MODULE || 'param 1'
517: , 'p_api_version_number:' || p_api_version_number

Line 515: FND_LOG.level_procedure

511: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
512: );
513: FND_LOG.String
514: (
515: FND_LOG.level_procedure
516: , L_LOG_MODULE || 'param 1'
517: , 'p_api_version_number:' || p_api_version_number
518: );
519: FND_LOG.String

Line 519: FND_LOG.String

515: FND_LOG.level_procedure
516: , L_LOG_MODULE || 'param 1'
517: , 'p_api_version_number:' || p_api_version_number
518: );
519: FND_LOG.String
520: (
521: FND_LOG.level_procedure
522: , L_LOG_MODULE || 'param 2'
523: , 'p_init_msg_list:' || p_init_msg_list

Line 521: FND_LOG.level_procedure

517: , 'p_api_version_number:' || p_api_version_number
518: );
519: FND_LOG.String
520: (
521: FND_LOG.level_procedure
522: , L_LOG_MODULE || 'param 2'
523: , 'p_init_msg_list:' || p_init_msg_list
524: );
525: FND_LOG.String

Line 525: FND_LOG.String

521: FND_LOG.level_procedure
522: , L_LOG_MODULE || 'param 2'
523: , 'p_init_msg_list:' || p_init_msg_list
524: );
525: FND_LOG.String
526: (
527: FND_LOG.level_procedure
528: , L_LOG_MODULE || 'param 3'
529: , 'p_commit:' || p_commit

Line 527: FND_LOG.level_procedure

523: , 'p_init_msg_list:' || p_init_msg_list
524: );
525: FND_LOG.String
526: (
527: FND_LOG.level_procedure
528: , L_LOG_MODULE || 'param 3'
529: , 'p_commit:' || p_commit
530: );
531: FND_LOG.String

Line 531: FND_LOG.String

527: FND_LOG.level_procedure
528: , L_LOG_MODULE || 'param 3'
529: , 'p_commit:' || p_commit
530: );
531: FND_LOG.String
532: (
533: FND_LOG.level_procedure
534: , L_LOG_MODULE || 'param 4'
535: , 'p_object_type:' || p_object_type

Line 533: FND_LOG.level_procedure

529: , 'p_commit:' || p_commit
530: );
531: FND_LOG.String
532: (
533: FND_LOG.level_procedure
534: , L_LOG_MODULE || 'param 4'
535: , 'p_object_type:' || p_object_type
536: );
537: FND_LOG.String

Line 537: FND_LOG.String

533: FND_LOG.level_procedure
534: , L_LOG_MODULE || 'param 4'
535: , 'p_object_type:' || p_object_type
536: );
537: FND_LOG.String
538: (
539: FND_LOG.level_procedure
540: , L_LOG_MODULE || 'param 5'
541: , 'p_processing_set_id:' || p_processing_set_id

Line 539: FND_LOG.level_procedure

535: , 'p_object_type:' || p_object_type
536: );
537: FND_LOG.String
538: (
539: FND_LOG.level_procedure
540: , L_LOG_MODULE || 'param 5'
541: , 'p_processing_set_id:' || p_processing_set_id
542: );
543: END IF ;

Line 572: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level

568: ------------------------------------------------------------------------------
569:
570: IF NVL(p_object_type, 'X') <> 'SR'
571: THEN
572: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
573: THEN
574: FND_LOG.String
575: (
576: FND_LOG.level_unexpected

Line 574: FND_LOG.String

570: IF NVL(p_object_type, 'X') <> 'SR'
571: THEN
572: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
573: THEN
574: FND_LOG.String
575: (
576: FND_LOG.level_unexpected
577: , L_LOG_MODULE || 'object_type_invalid'
578: , 'p_object_type has to be SR.'

Line 576: FND_LOG.level_unexpected

572: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
573: THEN
574: FND_LOG.String
575: (
576: FND_LOG.level_unexpected
577: , L_LOG_MODULE || 'object_type_invalid'
578: , 'p_object_type has to be SR.'
579: );
580: END IF ;

Line 595: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level

591: ---
592:
593: IF p_processing_set_id IS NULL
594: THEN
595: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
596: THEN
597: FND_LOG.String
598: (
599: FND_LOG.level_unexpected

Line 597: FND_LOG.String

593: IF p_processing_set_id IS NULL
594: THEN
595: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
596: THEN
597: FND_LOG.String
598: (
599: FND_LOG.level_unexpected
600: , L_LOG_MODULE || 'proc_set_id_invalid'
601: , 'p_processing_set_id should not be NULL.'

Line 599: FND_LOG.level_unexpected

595: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
596: THEN
597: FND_LOG.String
598: (
599: FND_LOG.level_unexpected
600: , L_LOG_MODULE || 'proc_set_id_invalid'
601: , 'p_processing_set_id should not be NULL.'
602: );
603: END IF ;

Line 618: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

614: ------------------------------------------------------------------------------
615: -- Actual Logic starts below:
616: ------------------------------------------------------------------------------
617:
618: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
619: THEN
620: FND_LOG.String
621: (
622: FND_LOG.level_statement

Line 620: FND_LOG.String

616: ------------------------------------------------------------------------------
617:
618: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
619: THEN
620: FND_LOG.String
621: (
622: FND_LOG.level_statement
623: , L_LOG_MODULE || 'del_sr_message_start'
624: , 'deleting data in table cs_messages'

Line 622: FND_LOG.level_statement

618: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
619: THEN
620: FND_LOG.String
621: (
622: FND_LOG.level_statement
623: , L_LOG_MODULE || 'del_sr_message_start'
624: , 'deleting data in table cs_messages'
625: );
626: END IF ;

Line 652: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

648: AND NVL(purge_status, 'S') = 'S'
649: );
650: l_row_count := SQL%ROWCOUNT;
651:
652: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
653: THEN
654: FND_LOG.String
655: (
656: FND_LOG.level_statement

Line 654: FND_LOG.String

650: l_row_count := SQL%ROWCOUNT;
651:
652: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
653: THEN
654: FND_LOG.String
655: (
656: FND_LOG.level_statement
657: , L_LOG_MODULE || 'del_sr_message_end'
658: , 'after deleting data in table cs_messages ' || l_row_count

Line 656: FND_LOG.level_statement

652: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
653: THEN
654: FND_LOG.String
655: (
656: FND_LOG.level_statement
657: , L_LOG_MODULE || 'del_sr_message_end'
658: , 'after deleting data in table cs_messages ' || l_row_count
659: );
660: END IF ;

Line 662: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level

658: , 'after deleting data in table cs_messages ' || l_row_count
659: );
660: END IF ;
661:
662: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
663: THEN
664: FND_LOG.String
665: (
666: FND_LOG.level_procedure

Line 664: FND_LOG.String

660: END IF ;
661:
662: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
663: THEN
664: FND_LOG.String
665: (
666: FND_LOG.level_procedure
667: , L_LOG_MODULE || 'end'
668: , 'Completed work in ' || L_API_NAME_FULL || ' successfully'

Line 666: FND_LOG.level_procedure

662: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
663: THEN
664: FND_LOG.String
665: (
666: FND_LOG.level_procedure
667: , L_LOG_MODULE || 'end'
668: , 'Completed work in ' || L_API_NAME_FULL || ' successfully'
669: );
670: END IF ;

Line 675: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level

671: EXCEPTION
672: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
673: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
674:
675: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
676: THEN
677: FND_LOG.String
678: (
679: FND_LOG.level_unexpected

Line 677: FND_LOG.String

673: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
674:
675: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
676: THEN
677: FND_LOG.String
678: (
679: FND_LOG.level_unexpected
680: , L_LOG_MODULE || 'unexpected_error'
681: , 'Inside WHEN FND_API.G_EXC_UNEXPECTED_ERROR of ' || L_API_NAME_FULL

Line 679: FND_LOG.level_unexpected

675: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
676: THEN
677: FND_LOG.String
678: (
679: FND_LOG.level_unexpected
680: , L_LOG_MODULE || 'unexpected_error'
681: , 'Inside WHEN FND_API.G_EXC_UNEXPECTED_ERROR of ' || L_API_NAME_FULL
682: );
683:

Line 698: FND_LOG.String

694: , p_encoded => 'F'
695: , p_data => x_msg_data
696: , p_msg_index_out => x_msg_index_out
697: );
698: FND_LOG.String
699: (
700: FND_LOG.level_unexpected
701: , L_LOG_MODULE || 'unexpected_error'
702: , 'Error encountered is : ' || x_msg_data

Line 700: FND_LOG.level_unexpected

696: , p_msg_index_out => x_msg_index_out
697: );
698: FND_LOG.String
699: (
700: FND_LOG.level_unexpected
701: , L_LOG_MODULE || 'unexpected_error'
702: , 'Error encountered is : ' || x_msg_data
703: || ' [Index:' || x_msg_index_out || ']'
704: );

Line 716: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level

712: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
713: FND_MESSAGE.Set_Token('ERROR', SQLERRM);
714: FND_MSG_PUB.ADD;
715:
716: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
717: THEN
718: FND_LOG.String
719: (
720: FND_LOG.level_unexpected

Line 718: FND_LOG.String

714: FND_MSG_PUB.ADD;
715:
716: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
717: THEN
718: FND_LOG.String
719: (
720: FND_LOG.level_unexpected
721: , L_LOG_MODULE || 'when_others'
722: , 'Inside WHEN OTHERS of ' || L_API_NAME_FULL

Line 720: FND_LOG.level_unexpected

716: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
717: THEN
718: FND_LOG.String
719: (
720: FND_LOG.level_unexpected
721: , L_LOG_MODULE || 'when_others'
722: , 'Inside WHEN OTHERS of ' || L_API_NAME_FULL
723: || '. Oracle Error was:'
724: );

Line 725: FND_LOG.String

721: , L_LOG_MODULE || 'when_others'
722: , 'Inside WHEN OTHERS of ' || L_API_NAME_FULL
723: || '. Oracle Error was:'
724: );
725: FND_LOG.String
726: (
727: FND_LOG.level_unexpected
728: , L_LOG_MODULE || 'when_others'
729: , SQLERRM

Line 727: FND_LOG.level_unexpected

723: || '. Oracle Error was:'
724: );
725: FND_LOG.String
726: (
727: FND_LOG.level_unexpected
728: , L_LOG_MODULE || 'when_others'
729: , SQLERRM
730: );
731: END IF ;