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

Line 5: g_level_procedure CONSTANT NUMBER := fnd_log.level_procedure;

1: PACKAGE BODY oks_auto_reminder AS
2: /* $Header: OKSARNWB.pls 120.26.12010000.2 2008/10/22 12:48:37 ssreekum ship $ */
3: g_pkg_name CONSTANT VARCHAR2 (200)
4: := 'OKS_AUTO_REMINDER';
5: g_level_procedure CONSTANT NUMBER := fnd_log.level_procedure;
6: g_module CONSTANT VARCHAR2 (250)
7: := 'oks.plsql.' ||
8: g_pkg_name ||
9: '.';

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

414: l_row_notfound BOOLEAN := TRUE;
415: --
416: BEGIN
417: -- start debug log
418: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
419: THEN
420: fnd_log.STRING (fnd_log.level_procedure,
421: g_module ||
422: l_api_name,

Line 420: fnd_log.STRING (fnd_log.level_procedure,

416: BEGIN
417: -- start debug log
418: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
419: THEN
420: fnd_log.STRING (fnd_log.level_procedure,
421: g_module ||
422: l_api_name,
423: '100: Entered ' ||
424: g_pkg_name ||

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

586: END IF; -- person_party_id check
587: END IF; -- IF l_row_notfound
588:
589: -- end debug log
590: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
591: THEN
592: fnd_log.STRING (fnd_log.level_procedure,
593: g_module ||
594: l_api_name,

Line 592: fnd_log.STRING (fnd_log.level_procedure,

588:
589: -- end debug log
590: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
591: THEN
592: fnd_log.STRING (fnd_log.level_procedure,
593: g_module ||
594: l_api_name,
595: '1000: Leaving ' ||
596: g_pkg_name ||

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

600: END IF;
601: EXCEPTION
602: WHEN fnd_api.g_exc_error
603: THEN
604: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
605: THEN
606: fnd_log.STRING (fnd_log.level_procedure,
607: g_module ||
608: l_api_name,

Line 606: fnd_log.STRING (fnd_log.level_procedure,

602: WHEN fnd_api.g_exc_error
603: THEN
604: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
605: THEN
606: fnd_log.STRING (fnd_log.level_procedure,
607: g_module ||
608: l_api_name,
609: '2000: Leaving ' ||
610: g_pkg_name ||

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

615:
616: x_return_status := g_ret_sts_error;
617: WHEN fnd_api.g_exc_unexpected_error
618: THEN
619: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
620: THEN
621: fnd_log.STRING (fnd_log.level_procedure,
622: g_module ||
623: l_api_name,

Line 621: fnd_log.STRING (fnd_log.level_procedure,

617: WHEN fnd_api.g_exc_unexpected_error
618: THEN
619: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
620: THEN
621: fnd_log.STRING (fnd_log.level_procedure,
622: g_module ||
623: l_api_name,
624: '3000: Leaving ' ||
625: g_pkg_name ||

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

630:
631: x_return_status := g_ret_sts_unexp_error;
632: WHEN OTHERS
633: THEN
634: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
635: THEN
636: fnd_log.STRING (fnd_log.level_procedure,
637: g_module ||
638: l_api_name,

Line 636: fnd_log.STRING (fnd_log.level_procedure,

632: WHEN OTHERS
633: THEN
634: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
635: THEN
636: fnd_log.STRING (fnd_log.level_procedure,
637: g_module ||
638: l_api_name,
639: '4000: Leaving ' ||
640: g_pkg_name ||

Line 675: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

671: OPEN csr_k_ste_code;
672: FETCH csr_k_ste_code INTO l_ste_code;
673: CLOSE csr_k_ste_code;
674:
675: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
676: fnd_log.STRING (fnd_log.level_procedure,
677: g_module ||l_api_name,
678: 'l_ste_code : ' ||l_ste_code||
679: ' (p_chr_id=> ' ||p_chr_id ||

Line 676: fnd_log.STRING (fnd_log.level_procedure,

672: FETCH csr_k_ste_code INTO l_ste_code;
673: CLOSE csr_k_ste_code;
674:
675: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
676: fnd_log.STRING (fnd_log.level_procedure,
677: g_module ||l_api_name,
678: 'l_ste_code : ' ||l_ste_code||
679: ' (p_chr_id=> ' ||p_chr_id ||
680: ' p_status=>' ||p_status ||')'

Line 746: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level

742: RETURN pcode;
743: END;
744:
745: BEGIN
746: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
747: THEN
748: fnd_log.STRING (fnd_log.level_procedure,
749: g_module ||
750: l_api_name,

Line 748: fnd_log.STRING (fnd_log.level_procedure,

744:
745: BEGIN
746: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
747: THEN
748: fnd_log.STRING (fnd_log.level_procedure,
749: g_module ||
750: l_api_name,
751: 'Entered ' ||
752: g_pkg_name ||

Line 769: IF fnd_log.level_event >= fnd_log.g_current_runtime_level

765: mo_global.init (p_appl_short_name => 'OKC');
766: l_chrv_rec.ID := p_chr_id;
767: l_chrv_rec.sts_code := p_status;
768:
769: IF fnd_log.level_event >= fnd_log.g_current_runtime_level
770: THEN
771: fnd_log.STRING
772: (fnd_log.level_event,
773: g_module ||

Line 771: fnd_log.STRING

767: l_chrv_rec.sts_code := p_status;
768:
769: IF fnd_log.level_event >= fnd_log.g_current_runtime_level
770: THEN
771: fnd_log.STRING
772: (fnd_log.level_event,
773: g_module ||
774: l_api_name ||
775: '.external_call.before',

Line 772: (fnd_log.level_event,

768:
769: IF fnd_log.level_event >= fnd_log.g_current_runtime_level
770: THEN
771: fnd_log.STRING
772: (fnd_log.level_event,
773: g_module ||
774: l_api_name ||
775: '.external_call.before',
776: 'OKC_CONTRACT_PUB.update_contract_header(p_chr_id=' ||

Line 793: IF fnd_log.level_event >= fnd_log.g_current_runtime_level

789: p_chrv_rec => l_chrv_rec,
790: x_chrv_rec => x_chrv_rec
791: );
792:
793: IF fnd_log.level_event >= fnd_log.g_current_runtime_level
794: THEN
795: fnd_log.STRING
796: (fnd_log.level_event,
797: g_module ||

Line 795: fnd_log.STRING

791: );
792:
793: IF fnd_log.level_event >= fnd_log.g_current_runtime_level
794: THEN
795: fnd_log.STRING
796: (fnd_log.level_event,
797: g_module ||
798: l_api_name ||
799: '.external_call.after',

Line 796: (fnd_log.level_event,

792:
793: IF fnd_log.level_event >= fnd_log.g_current_runtime_level
794: THEN
795: fnd_log.STRING
796: (fnd_log.level_event,
797: g_module ||
798: l_api_name ||
799: '.external_call.after',
800: 'OKC_CONTRACT_PUB.update_contract_header(x_return_status= ' ||

Line 816: IF fnd_log.level_event >= fnd_log.g_current_runtime_level

812: THEN
813: RAISE fnd_api.g_exc_error;
814: END IF;
815:
816: IF fnd_log.level_event >= fnd_log.g_current_runtime_level
817: THEN
818: fnd_log.STRING (fnd_log.level_event,
819: g_module ||
820: l_api_name ||

Line 818: fnd_log.STRING (fnd_log.level_event,

814: END IF;
815:
816: IF fnd_log.level_event >= fnd_log.g_current_runtime_level
817: THEN
818: fnd_log.STRING (fnd_log.level_event,
819: g_module ||
820: l_api_name ||
821: '.external_call.before',
822: 'OKC_CONTRACT_PUB.update_contract_line - Loop begin'

Line 836: IF fnd_log.level_event >= fnd_log.g_current_runtime_level

832: FOR l_lines_rec IN l_lines_entered_csr
833: LOOP
834: l_clev_rec.ID := l_lines_rec.ID;
835:
836: IF fnd_log.level_event >= fnd_log.g_current_runtime_level
837: THEN
838: fnd_log.STRING (fnd_log.level_event,
839: g_module ||
840: l_api_name,

Line 838: fnd_log.STRING (fnd_log.level_event,

834: l_clev_rec.ID := l_lines_rec.ID;
835:
836: IF fnd_log.level_event >= fnd_log.g_current_runtime_level
837: THEN
838: fnd_log.STRING (fnd_log.level_event,
839: g_module ||
840: l_api_name,
841: 'Updating line: ' ||
842: l_lines_rec.ID

Line 857: IF fnd_log.level_event >= fnd_log.g_current_runtime_level

853: p_clev_rec => l_clev_rec,
854: x_clev_rec => x_clev_rec
855: );
856:
857: IF fnd_log.level_event >= fnd_log.g_current_runtime_level
858: THEN
859: fnd_log.STRING (fnd_log.level_event,
860: g_module ||
861: l_api_name,

Line 859: fnd_log.STRING (fnd_log.level_event,

855: );
856:
857: IF fnd_log.level_event >= fnd_log.g_current_runtime_level
858: THEN
859: fnd_log.STRING (fnd_log.level_event,
860: g_module ||
861: l_api_name,
862: 'Result: ' ||
863: l_return_status

Line 880: IF fnd_log.level_event >= fnd_log.g_current_runtime_level

876: FOR l_lines_rec IN l_lines_csr
877: LOOP
878: l_clev_rec.ID := l_lines_rec.ID;
879:
880: IF fnd_log.level_event >= fnd_log.g_current_runtime_level
881: THEN
882: fnd_log.STRING (fnd_log.level_event,
883: g_module ||
884: l_api_name,

Line 882: fnd_log.STRING (fnd_log.level_event,

878: l_clev_rec.ID := l_lines_rec.ID;
879:
880: IF fnd_log.level_event >= fnd_log.g_current_runtime_level
881: THEN
882: fnd_log.STRING (fnd_log.level_event,
883: g_module ||
884: l_api_name,
885: 'Updating line: ' ||
886: l_lines_rec.ID

Line 901: IF fnd_log.level_event >= fnd_log.g_current_runtime_level

897: p_clev_rec => l_clev_rec,
898: x_clev_rec => x_clev_rec
899: );
900:
901: IF fnd_log.level_event >= fnd_log.g_current_runtime_level
902: THEN
903: fnd_log.STRING (fnd_log.level_event,
904: g_module ||
905: l_api_name,

Line 903: fnd_log.STRING (fnd_log.level_event,

899: );
900:
901: IF fnd_log.level_event >= fnd_log.g_current_runtime_level
902: THEN
903: fnd_log.STRING (fnd_log.level_event,
904: g_module ||
905: l_api_name,
906: 'Result: ' ||
907: l_return_status

Line 921: IF fnd_log.level_event >= fnd_log.g_current_runtime_level

917: END IF;
918: END LOOP;
919: END IF; /*IF NVL(l_status_code,'X') = 'ENTERED' THEN*/
920:
921: IF fnd_log.level_event >= fnd_log.g_current_runtime_level
922: THEN
923: fnd_log.STRING (fnd_log.level_event,
924: g_module ||
925: l_api_name ||

Line 923: fnd_log.STRING (fnd_log.level_event,

919: END IF; /*IF NVL(l_status_code,'X') = 'ENTERED' THEN*/
920:
921: IF fnd_log.level_event >= fnd_log.g_current_runtime_level
922: THEN
923: fnd_log.STRING (fnd_log.level_event,
924: g_module ||
925: l_api_name ||
926: '.external_call.after',
927: 'OKC_CONTRACT_PUB.update_contract_line - loop end'

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

934: p_count => l_msg_count,
935: p_data => l_msg_data
936: );
937:
938: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
939: THEN
940: fnd_log.STRING (fnd_log.level_procedure,
941: g_module ||
942: l_api_name,

Line 940: fnd_log.STRING (fnd_log.level_procedure,

936: );
937:
938: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
939: THEN
940: fnd_log.STRING (fnd_log.level_procedure,
941: g_module ||
942: l_api_name,
943: 'Leaving ' ||
944: g_pkg_name ||

Line 949: fnd_log.STRING (fnd_log.level_procedure,

945: '.' ||
946: l_api_name ||
947: ' from G_EXC_ERROR'
948: );
949: fnd_log.STRING (fnd_log.level_procedure,
950: g_module ||
951: l_api_name,
952: l_msg_data
953: );

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

960: p_count => l_msg_count,
961: p_data => l_msg_data
962: );
963:
964: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
965: THEN
966: fnd_log.STRING (fnd_log.level_procedure,
967: g_module ||
968: l_api_name,

Line 966: fnd_log.STRING (fnd_log.level_procedure,

962: );
963:
964: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
965: THEN
966: fnd_log.STRING (fnd_log.level_procedure,
967: g_module ||
968: l_api_name,
969: 'Leaving ' ||
970: g_pkg_name ||

Line 975: fnd_log.STRING (fnd_log.level_procedure,

971: '.' ||
972: l_api_name ||
973: ' from G_EXC_UNEXPECTED_ERROR'
974: );
975: fnd_log.STRING (fnd_log.level_procedure,
976: g_module ||
977: l_api_name,
978: l_msg_data
979: );

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

981:
982: x_return_status := g_ret_sts_unexp_error;
983: WHEN OTHERS
984: THEN
985: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
986: THEN
987: fnd_log.STRING (fnd_log.level_procedure,
988: g_module ||
989: l_api_name,

Line 987: fnd_log.STRING (fnd_log.level_procedure,

983: WHEN OTHERS
984: THEN
985: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
986: THEN
987: fnd_log.STRING (fnd_log.level_procedure,
988: g_module ||
989: l_api_name,
990: 'Leaving ' ||
991: g_pkg_name ||

Line 1625: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level

1621: l_interaction_body VARCHAR2 (2000);
1622: l_interaction_id NUMBER;
1623: l_kdetails_rec l_kdetails_csr%ROWTYPE;
1624: BEGIN
1625: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
1626: THEN
1627: fnd_log.STRING (fnd_log.level_procedure,
1628: g_module ||
1629: l_api_name,

Line 1627: fnd_log.STRING (fnd_log.level_procedure,

1623: l_kdetails_rec l_kdetails_csr%ROWTYPE;
1624: BEGIN
1625: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
1626: THEN
1627: fnd_log.STRING (fnd_log.level_procedure,
1628: g_module ||
1629: l_api_name,
1630: 'Entered ' ||
1631: g_pkg_name ||

Line 1682: IF fnd_log.level_event >= fnd_log.g_current_runtime_level

1678: fnd_msg_pub.ADD;
1679: RAISE fnd_api.g_exc_error;
1680: END IF;
1681:
1682: IF fnd_log.level_event >= fnd_log.g_current_runtime_level
1683: THEN
1684: fnd_log.STRING (fnd_log.level_event,
1685: g_module ||
1686: l_api_name ||

Line 1684: fnd_log.STRING (fnd_log.level_event,

1680: END IF;
1681:
1682: IF fnd_log.level_event >= fnd_log.g_current_runtime_level
1683: THEN
1684: fnd_log.STRING (fnd_log.level_event,
1685: g_module ||
1686: l_api_name ||
1687: '.external_call.before',
1688: 'OKS_AUTO_REMINDER.get_qtoparty_id(p_chr_id= ' ||

Line 1698: IF fnd_log.level_event >= fnd_log.g_current_runtime_level

1694: -- Get the party ID for logging interaction history
1695: oks_auto_reminder.get_qtoparty_id (p_chr_id => p_chr_id,
1696: x_party_id => l_party_id);
1697:
1698: IF fnd_log.level_event >= fnd_log.g_current_runtime_level
1699: THEN
1700: fnd_log.STRING (fnd_log.level_event,
1701: g_module ||
1702: l_api_name ||

Line 1700: fnd_log.STRING (fnd_log.level_event,

1696: x_party_id => l_party_id);
1697:
1698: IF fnd_log.level_event >= fnd_log.g_current_runtime_level
1699: THEN
1700: fnd_log.STRING (fnd_log.level_event,
1701: g_module ||
1702: l_api_name ||
1703: '.external_call.after',
1704: 'OKS_AUTO_REMINDER.get_qtoparty_id(x_party_id= ' ||

Line 1718: IF fnd_log.level_event >= fnd_log.g_current_runtime_level

1714: RAISE fnd_api.g_exc_error;
1715: END IF;
1716:
1717: -- Get Salesrep user name which will be used as performer
1718: IF fnd_log.level_event >= fnd_log.g_current_runtime_level
1719: THEN
1720: fnd_log.STRING (fnd_log.level_event,
1721: g_module ||
1722: l_api_name ||

Line 1720: fnd_log.STRING (fnd_log.level_event,

1716:
1717: -- Get Salesrep user name which will be used as performer
1718: IF fnd_log.level_event >= fnd_log.g_current_runtime_level
1719: THEN
1720: fnd_log.STRING (fnd_log.level_event,
1721: g_module ||
1722: l_api_name ||
1723: '.external_call.before',
1724: 'OKS_RENEW_CONTRACT_PVT.GET_USER_NAME(p_chr_id=' ||

Line 1742: IF fnd_log.level_event >= fnd_log.g_current_runtime_level

1738: x_user_id => l_salesrep_id,
1739: x_user_name => l_salesrep_name
1740: );
1741:
1742: IF fnd_log.level_event >= fnd_log.g_current_runtime_level
1743: THEN
1744: fnd_log.STRING
1745: (fnd_log.level_event,
1746: g_module ||

Line 1744: fnd_log.STRING

1740: );
1741:
1742: IF fnd_log.level_event >= fnd_log.g_current_runtime_level
1743: THEN
1744: fnd_log.STRING
1745: (fnd_log.level_event,
1746: g_module ||
1747: l_api_name ||
1748: '.external_call.after',

Line 1745: (fnd_log.level_event,

1741:
1742: IF fnd_log.level_event >= fnd_log.g_current_runtime_level
1743: THEN
1744: fnd_log.STRING
1745: (fnd_log.level_event,
1746: g_module ||
1747: l_api_name ||
1748: '.external_call.after',
1749: 'OKS_RENEW_CONTRACT_PVT.GET_USER_NAME(x_return_status= ' ||

Line 1755: fnd_log.STRING (fnd_log.level_event,

1751: ' x_msg_count =' ||
1752: x_msg_count ||
1753: ')'
1754: );
1755: fnd_log.STRING (fnd_log.level_event,
1756: g_module ||
1757: l_api_name ||
1758: '.external_call.after',
1759: ' x_user_id =' ||

Line 1829: IF fnd_log.level_event >= fnd_log.g_current_runtime_level

1825: ELSE
1826: l_interaction_body := p_msg_body;
1827: END IF;
1828:
1829: IF fnd_log.level_event >= fnd_log.g_current_runtime_level
1830: THEN
1831: fnd_log.STRING
1832: (fnd_log.level_event,
1833: g_module ||

Line 1831: fnd_log.STRING

1827: END IF;
1828:
1829: IF fnd_log.level_event >= fnd_log.g_current_runtime_level
1830: THEN
1831: fnd_log.STRING
1832: (fnd_log.level_event,
1833: g_module ||
1834: l_api_name ||
1835: '.external_call.before',

Line 1832: (fnd_log.level_event,

1828:
1829: IF fnd_log.level_event >= fnd_log.g_current_runtime_level
1830: THEN
1831: fnd_log.STRING
1832: (fnd_log.level_event,
1833: g_module ||
1834: l_api_name ||
1835: '.external_call.before',
1836: 'OKC_INTERACT_HISTORY_PUB.CREATE_INTERACT_HISTORY(p_chr_id=' ||

Line 1877: IF fnd_log.level_event >= fnd_log.g_current_runtime_level

1873: p_notes => l_subject,
1874: p_notes_detail => l_interaction_body
1875: );
1876:
1877: IF fnd_log.level_event >= fnd_log.g_current_runtime_level
1878: THEN
1879: fnd_log.STRING
1880: (fnd_log.level_event,
1881: g_module ||

Line 1879: fnd_log.STRING

1875: );
1876:
1877: IF fnd_log.level_event >= fnd_log.g_current_runtime_level
1878: THEN
1879: fnd_log.STRING
1880: (fnd_log.level_event,
1881: g_module ||
1882: l_api_name ||
1883: '.external_call.after',

Line 1880: (fnd_log.level_event,

1876:
1877: IF fnd_log.level_event >= fnd_log.g_current_runtime_level
1878: THEN
1879: fnd_log.STRING
1880: (fnd_log.level_event,
1881: g_module ||
1882: l_api_name ||
1883: '.external_call.after',
1884: 'OKC_INTERACT_HISTORY_PUB.CREATE_INTERACT_HISTORY(x_return_status= ' ||

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

1905: p_count => x_msg_count,
1906: p_data => x_msg_data
1907: );
1908:
1909: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1910: THEN
1911: fnd_log.STRING (fnd_log.level_procedure,
1912: g_module ||
1913: l_api_name,

Line 1911: fnd_log.STRING (fnd_log.level_procedure,

1907: );
1908:
1909: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1910: THEN
1911: fnd_log.STRING (fnd_log.level_procedure,
1912: g_module ||
1913: l_api_name,
1914: 'Leaving ' ||
1915: g_pkg_name ||

Line 1920: fnd_log.STRING (fnd_log.level_procedure,

1916: '.' ||
1917: l_api_name ||
1918: ' from G_EXC_ERROR'
1919: );
1920: fnd_log.STRING (fnd_log.level_procedure,
1921: g_module ||
1922: l_api_name,
1923: x_msg_data
1924: );

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

1931: p_count => x_msg_count,
1932: p_data => x_msg_data
1933: );
1934:
1935: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1936: THEN
1937: fnd_log.STRING (fnd_log.level_procedure,
1938: g_module ||
1939: l_api_name,

Line 1937: fnd_log.STRING (fnd_log.level_procedure,

1933: );
1934:
1935: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1936: THEN
1937: fnd_log.STRING (fnd_log.level_procedure,
1938: g_module ||
1939: l_api_name,
1940: 'Leaving ' ||
1941: g_pkg_name ||

Line 1946: fnd_log.STRING (fnd_log.level_procedure,

1942: '.' ||
1943: l_api_name ||
1944: ' from G_EXC_UNEXPECTED_ERROR'
1945: );
1946: fnd_log.STRING (fnd_log.level_procedure,
1947: g_module ||
1948: l_api_name,
1949: x_msg_data
1950: );

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

1952:
1953: x_return_status := g_ret_sts_unexp_error;
1954: WHEN OTHERS
1955: THEN
1956: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1957: THEN
1958: fnd_log.STRING (fnd_log.level_procedure,
1959: g_module ||
1960: l_api_name,

Line 1958: fnd_log.STRING (fnd_log.level_procedure,

1954: WHEN OTHERS
1955: THEN
1956: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1957: THEN
1958: fnd_log.STRING (fnd_log.level_procedure,
1959: g_module ||
1960: l_api_name,
1961: 'Leaving ' ||
1962: g_pkg_name ||

Line 2183: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2179: -- Contract is eligibile for a reminder or cancellation notice
2180: x_is_eligible := 'Y';
2181: x_return_status := g_ret_sts_success;
2182:
2183: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2184: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE , G_MODULE||l_api_name,
2185: 'Entered with p_chr_id '||p_chr_id);
2186: END IF;
2187: -- Initialize message stack

Line 2184: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE , G_MODULE||l_api_name,

2180: x_is_eligible := 'Y';
2181: x_return_status := g_ret_sts_success;
2182:
2183: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2184: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE , G_MODULE||l_api_name,
2185: 'Entered with p_chr_id '||p_chr_id);
2186: END IF;
2187: -- Initialize message stack
2188: FND_MSG_PUB.initialize;

Line 2210: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2206: END IF;
2207:
2208: -- STEP 1: Check for active workflow processes
2209: IF x_is_eligible = 'Y' THEN
2210: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2211: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
2212: 'okc_contract_pub.get_active_process(p_contract_number= '||
2213: l_k_details_rec.contract_number||
2214: ' p_contract_number_modifier ='||l_k_details_rec.contract_number_modifier||')');

Line 2211: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',

2207:
2208: -- STEP 1: Check for active workflow processes
2209: IF x_is_eligible = 'Y' THEN
2210: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2211: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
2212: 'okc_contract_pub.get_active_process(p_contract_number= '||
2213: l_k_details_rec.contract_number||
2214: ' p_contract_number_modifier ='||l_k_details_rec.contract_number_modifier||')');
2215: END IF;

Line 2231: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2227: x_package_name => l_package_name,
2228: x_procedure_name => l_procedure_name,
2229: x_usage => l_usage
2230: );
2231: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2232: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
2233: 'okc_contract_pub.get_active_process(x_return_status= '||x_return_status||
2234: ' x_msg_count ='||x_msg_count||')');
2235: END IF;

Line 2232: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',

2228: x_procedure_name => l_procedure_name,
2229: x_usage => l_usage
2230: );
2231: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2232: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
2233: 'okc_contract_pub.get_active_process(x_return_status= '||x_return_status||
2234: ' x_msg_count ='||x_msg_count||')');
2235: END IF;
2236:

Line 2253: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2249: OPEN csr_k_hdr_details;
2250: FETCH csr_k_hdr_details INTO l_applies_to, l_item_key;
2251: CLOSE csr_k_hdr_details;
2252:
2253: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2254: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
2255: 'OKS_WF_K_PROCESS_PVT.is_online_k_yn(p_contract_id= '||p_chr_id||
2256: ' p_item_key ='||l_item_key||')');
2257: END IF;

Line 2254: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',

2250: FETCH csr_k_hdr_details INTO l_applies_to, l_item_key;
2251: CLOSE csr_k_hdr_details;
2252:
2253: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2254: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
2255: 'OKS_WF_K_PROCESS_PVT.is_online_k_yn(p_contract_id= '||p_chr_id||
2256: ' p_item_key ='||l_item_key||')');
2257: END IF;
2258: -- check if the current contract is ONLINE or MANUAL

Line 2270: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2266: x_return_status => x_return_status,
2267: x_msg_count => x_msg_count,
2268: x_msg_data => x_msg_data
2269: );
2270: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2271: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
2272: 'OKS_WF_K_PROCESS_PVT.is_online_k_yn(x_return_status= '||x_return_status||
2273: ' x_msg_count ='||x_msg_count||'l_online_yn '||l_online_yn||')');
2274: END IF;

Line 2271: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',

2267: x_msg_count => x_msg_count,
2268: x_msg_data => x_msg_data
2269: );
2270: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2271: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
2272: 'OKS_WF_K_PROCESS_PVT.is_online_k_yn(x_return_status= '||x_return_status||
2273: ' x_msg_count ='||x_msg_count||'l_online_yn '||l_online_yn||')');
2274: END IF;
2275: --- If any errors happen treat it as online K

Line 2288: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2284: l_process_code := 'M';
2285: END IF;
2286:
2287: BEGIN
2288: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2289: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
2290: 'oks_renew_util_pub.get_template_set_id(p_contract_id= '||
2291: l_k_details_rec.ID||')');
2292: END IF;

Line 2289: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',

2285: END IF;
2286:
2287: BEGIN
2288: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2289: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
2290: 'oks_renew_util_pub.get_template_set_id(p_contract_id= '||
2291: l_k_details_rec.ID||')');
2292: END IF;
2293:

Line 2296: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2292: END IF;
2293:
2294: l_template_set_id := oks_renew_util_pub.get_template_set_id(l_k_details_rec.ID);
2295:
2296: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2297: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
2298: 'oks_renew_util_pub.get_template_set_id(x_template_set_id= '||
2299: l_template_set_id||')');
2300: END IF;

Line 2297: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',

2293:
2294: l_template_set_id := oks_renew_util_pub.get_template_set_id(l_k_details_rec.ID);
2295:
2296: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2297: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
2298: 'oks_renew_util_pub.get_template_set_id(x_template_set_id= '||
2299: l_template_set_id||')');
2300: END IF;
2301: IF l_template_set_id IS NULL THEN

Line 2320: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2316: IF l_template_set_id IS NOT NULL AND x_is_eligible = 'Y' THEN
2317: l_duration := TRUNC (SYSDATE) - TRUNC (l_k_details_rec.start_date);
2318: l_period := oks_time_measures_pub.get_uom_code ('DAY', 1);
2319:
2320: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2321: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2322: 'l_duration: ' ||l_duration||' l_period: '||l_period );
2323: END IF;
2324:

Line 2321: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

2317: l_duration := TRUNC (SYSDATE) - TRUNC (l_k_details_rec.start_date);
2318: l_period := oks_time_measures_pub.get_uom_code ('DAY', 1);
2319:
2320: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2321: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2322: 'l_duration: ' ||l_duration||' l_period: '||l_period );
2323: END IF;
2324:
2325: -- If there is an error getting the duration skip this contract

Line 2348: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2344: CLOSE l_reportmatch_csr;
2345: ELSE -- Straight match not found
2346: CLOSE l_reportmatch_csr;
2347:
2348: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2349: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2350: 'Exact match not found; continue search by converting ');
2351: END IF;
2352: -- Now trying to convert and look for match

Line 2349: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

2345: ELSE -- Straight match not found
2346: CLOSE l_reportmatch_csr;
2347:
2348: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2349: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2350: 'Exact match not found; continue search by converting ');
2351: END IF;
2352: -- Now trying to convert and look for match
2353: FOR l_reports_rec IN l_reports_csr (l_template_set_id,

Line 2408: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2404: x_status := l_duration_rec.sts_code;
2405: END IF;
2406: CLOSE l_duration_csr;
2407: END IF; -- Get Duration Status check
2408: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2409: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2410: 'x_cover_id: ' ||x_cover_id);
2411: END IF;
2412:

Line 2409: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

2405: END IF;
2406: CLOSE l_duration_csr;
2407: END IF; -- Get Duration Status check
2408: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2409: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2410: 'x_cover_id: ' ||x_cover_id);
2411: END IF;
2412:
2413: IF NVL(x_quote_id, x_cover_id) IS NULL THEN

Line 2424: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2420:
2421: -- STEP 4: Get Quote to contact email address
2422: IF NVL(x_quote_id, x_cover_id) IS NOT NULL AND x_is_eligible = 'Y' THEN
2423: BEGIN
2424: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2425: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
2426: 'oks_auto_reminder.get_qto_email(p_chr_id= '||
2427: l_k_details_rec.ID||')');
2428: END IF;

Line 2425: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',

2421: -- STEP 4: Get Quote to contact email address
2422: IF NVL(x_quote_id, x_cover_id) IS NOT NULL AND x_is_eligible = 'Y' THEN
2423: BEGIN
2424: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2425: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
2426: 'oks_auto_reminder.get_qto_email(p_chr_id= '||
2427: l_k_details_rec.ID||')');
2428: END IF;
2429: oks_auto_reminder.get_qto_email

Line 2434: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2430: (
2431: p_chr_id => l_k_details_rec.ID,
2432: x_qto_email => x_qto_email
2433: );
2434: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2435: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
2436: 'oks_auto_reminder.get_qto_email(x_qto_email= '||
2437: x_qto_email||')');
2438: END IF;

Line 2435: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',

2431: p_chr_id => l_k_details_rec.ID,
2432: x_qto_email => x_qto_email
2433: );
2434: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2435: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
2436: 'oks_auto_reminder.get_qto_email(x_qto_email= '||
2437: x_qto_email||')');
2438: END IF;
2439: IF x_qto_email IS NULL OR x_qto_email = okc_api.g_miss_char THEN

Line 2454: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

2450: END IF;
2451:
2452: -- STEP 5: Get Sender email address
2453: IF x_is_eligible = 'Y' THEN
2454: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
2455: fnd_log.STRING(fnd_log.level_event,g_module ||l_api_name ||
2456: '.external_call.before',
2457: 'OKS_RENEW_CONTRACT_PVT.GET_USER_NAME(p_chr_id=' ||
2458: l_k_details_rec.ID ||')');

Line 2455: fnd_log.STRING(fnd_log.level_event,g_module ||l_api_name ||

2451:
2452: -- STEP 5: Get Sender email address
2453: IF x_is_eligible = 'Y' THEN
2454: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
2455: fnd_log.STRING(fnd_log.level_event,g_module ||l_api_name ||
2456: '.external_call.before',
2457: 'OKS_RENEW_CONTRACT_PVT.GET_USER_NAME(p_chr_id=' ||
2458: l_k_details_rec.ID ||')');
2459: END IF;

Line 2472: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

2468: p_hdesk_user_id => NULL,
2469: x_user_id => l_salesrep_id,
2470: x_user_name => l_salesrep_name
2471: );
2472: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
2473: fnd_log.STRING(fnd_log.level_event,g_module ||l_api_name ||
2474: '.external_call.after',
2475: 'OKS_RENEW_CONTRACT_PVT.GET_USER_NAME(x_return_status= ' ||
2476: x_return_status ||' x_msg_count ='||x_msg_count||')');

Line 2473: fnd_log.STRING(fnd_log.level_event,g_module ||l_api_name ||

2469: x_user_id => l_salesrep_id,
2470: x_user_name => l_salesrep_name
2471: );
2472: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
2473: fnd_log.STRING(fnd_log.level_event,g_module ||l_api_name ||
2474: '.external_call.after',
2475: 'OKS_RENEW_CONTRACT_PVT.GET_USER_NAME(x_return_status= ' ||
2476: x_return_status ||' x_msg_count ='||x_msg_count||')');
2477: fnd_log.STRING (fnd_log.level_event,g_module ||l_api_name ||

Line 2477: fnd_log.STRING (fnd_log.level_event,g_module ||l_api_name ||

2473: fnd_log.STRING(fnd_log.level_event,g_module ||l_api_name ||
2474: '.external_call.after',
2475: 'OKS_RENEW_CONTRACT_PVT.GET_USER_NAME(x_return_status= ' ||
2476: x_return_status ||' x_msg_count ='||x_msg_count||')');
2477: fnd_log.STRING (fnd_log.level_event,g_module ||l_api_name ||
2478: '.external_call.after',' x_user_id =' ||l_salesrep_id ||
2479: ' x_user_name =' ||l_salesrep_name);
2480: END IF;
2481:

Line 2488: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2484: OPEN l_user_email_csr (l_salesrep_id);
2485: FETCH l_user_email_csr INTO x_sender;
2486: CLOSE l_user_email_csr;
2487: END IF;
2488: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2489: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2490: 'x_sender: ' ||x_sender);
2491: END IF;
2492: IF x_sender IS NULL THEN

Line 2489: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

2485: FETCH l_user_email_csr INTO x_sender;
2486: CLOSE l_user_email_csr;
2487: END IF;
2488: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2489: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2490: 'x_sender: ' ||x_sender);
2491: END IF;
2492: IF x_sender IS NULL THEN
2493: x_is_eligible := 'N';

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

2701: l_fnd_party_id hz_parties.party_id%TYPE;
2702:
2703: BEGIN
2704: -- start debug log
2705: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2706: THEN
2707: fnd_log.STRING (fnd_log.level_procedure,
2708: g_module ||
2709: l_api_name,

Line 2707: fnd_log.STRING (fnd_log.level_procedure,

2703: BEGIN
2704: -- start debug log
2705: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2706: THEN
2707: fnd_log.STRING (fnd_log.level_procedure,
2708: g_module ||
2709: l_api_name,
2710: '100: Entered ' ||
2711: g_pkg_name ||

Line 2715: fnd_log.STRING (fnd_log.level_procedure,

2711: g_pkg_name ||
2712: '.' ||
2713: l_api_name
2714: );
2715: fnd_log.STRING (fnd_log.level_procedure,
2716: g_module ||
2717: l_api_name,
2718: '100: Parameter p_user_name : ' ||
2719: p_user_name

Line 2721: fnd_log.STRING (fnd_log.level_procedure,

2717: l_api_name,
2718: '100: Parameter p_user_name : ' ||
2719: p_user_name
2720: );
2721: fnd_log.STRING (fnd_log.level_procedure,
2722: g_module ||
2723: l_api_name,
2724: '100: p_contract_id : ' ||
2725: p_contract_id

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

2753:
2754: CLOSE csr_person_party_id;
2755:
2756: -- debug log
2757: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2758: THEN
2759: fnd_log.STRING (fnd_log.level_procedure,
2760: g_module ||
2761: l_api_name,

Line 2759: fnd_log.STRING (fnd_log.level_procedure,

2755:
2756: -- debug log
2757: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2758: THEN
2759: fnd_log.STRING (fnd_log.level_procedure,
2760: g_module ||
2761: l_api_name,
2762: '110: l_person_party_id : ' ||
2763: l_person_party_id

Line 2765: fnd_log.STRING (fnd_log.level_procedure,

2761: l_api_name,
2762: '110: l_person_party_id : ' ||
2763: l_person_party_id
2764: );
2765: fnd_log.STRING (fnd_log.level_procedure,
2766: g_module ||
2767: l_api_name,
2768: '110: l_quote_to_contact_id : ' ||
2769: l_quote_to_contact_id

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

2789:
2790: CLOSE csr_qtc_person_party_id;
2791:
2792: -- debug log
2793: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2794: THEN
2795: fnd_log.STRING
2796: (fnd_log.level_procedure,
2797: g_module ||

Line 2795: fnd_log.STRING

2791:
2792: -- debug log
2793: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2794: THEN
2795: fnd_log.STRING
2796: (fnd_log.level_procedure,
2797: g_module ||
2798: l_api_name,
2799: '120: l_person_party_id for quote to contact: ' ||

Line 2796: (fnd_log.level_procedure,

2792: -- debug log
2793: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2794: THEN
2795: fnd_log.STRING
2796: (fnd_log.level_procedure,
2797: g_module ||
2798: l_api_name,
2799: '120: l_person_party_id for quote to contact: ' ||
2800: l_person_party_id

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

2838:
2839: CLOSE csr_check_fnd_user_exists;
2840:
2841: -- debug log
2842: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2843: THEN
2844: fnd_log.STRING (fnd_log.level_procedure,
2845: g_module ||
2846: l_api_name,

Line 2844: fnd_log.STRING (fnd_log.level_procedure,

2840:
2841: -- debug log
2842: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2843: THEN
2844: fnd_log.STRING (fnd_log.level_procedure,
2845: g_module ||
2846: l_api_name,
2847: '130: l_user_id : ' ||
2848: l_user_id

Line 2850: fnd_log.STRING (fnd_log.level_procedure,

2846: l_api_name,
2847: '130: l_user_id : ' ||
2848: l_user_id
2849: );
2850: fnd_log.STRING (fnd_log.level_procedure,
2851: g_module ||
2852: l_api_name,
2853: '130: x_user_name : ' ||
2854: x_user_name

Line 2856: fnd_log.STRING (fnd_log.level_procedure,

2852: l_api_name,
2853: '130: x_user_name : ' ||
2854: x_user_name
2855: );
2856: fnd_log.STRING (fnd_log.level_procedure,
2857: g_module ||
2858: l_api_name,
2859: '130: x_password : ' ||
2860: x_password

Line 2950: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level

2946: RETURN;
2947: ELSE
2948: -- error in fnd_profile.save
2949: -- debug log
2950: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level
2951: )
2952: THEN
2953: fnd_log.STRING (fnd_log.level_procedure,
2954: g_module ||

Line 2953: fnd_log.STRING (fnd_log.level_procedure,

2949: -- debug log
2950: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level
2951: )
2952: THEN
2953: fnd_log.STRING (fnd_log.level_procedure,
2954: g_module ||
2955: l_api_name,
2956: '135: error in fnd_profile.save : '
2957: );

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

2976: l_end_date,
2977: x_password;
2978:
2979: -- debug log
2980: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2981: THEN
2982: fnd_log.STRING (fnd_log.level_procedure,
2983: g_module ||
2984: l_api_name,

Line 2982: fnd_log.STRING (fnd_log.level_procedure,

2978:
2979: -- debug log
2980: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2981: THEN
2982: fnd_log.STRING (fnd_log.level_procedure,
2983: g_module ||
2984: l_api_name,
2985: '140: l_fnd_person_party_id : ' ||
2986: l_fnd_person_party_id

Line 2988: fnd_log.STRING (fnd_log.level_procedure,

2984: l_api_name,
2985: '140: l_fnd_person_party_id : ' ||
2986: l_fnd_person_party_id
2987: );
2988: fnd_log.STRING (fnd_log.level_procedure,
2989: g_module ||
2990: l_api_name,
2991: '140: l_start_date : ' ||
2992: l_start_date

Line 2994: fnd_log.STRING (fnd_log.level_procedure,

2990: l_api_name,
2991: '140: l_start_date : ' ||
2992: l_start_date
2993: );
2994: fnd_log.STRING (fnd_log.level_procedure,
2995: g_module ||
2996: l_api_name,
2997: '140: l_end_date : ' ||
2998: l_end_date

Line 3000: fnd_log.STRING (fnd_log.level_procedure,

2996: l_api_name,
2997: '140: l_end_date : ' ||
2998: l_end_date
2999: );
3000: fnd_log.STRING (fnd_log.level_procedure,
3001: g_module ||
3002: l_api_name,
3003: '140: x_password : ' ||
3004: x_password

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

3042: (fnd_file.LOG,
3043: 'Suggested username : '||l_suggested_user_name);
3044:
3045: -- debug log
3046: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
3047: THEN
3048: fnd_log.STRING (fnd_log.level_procedure,
3049: g_module ||
3050: l_api_name,

Line 3048: fnd_log.STRING (fnd_log.level_procedure,

3044:
3045: -- debug log
3046: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
3047: THEN
3048: fnd_log.STRING (fnd_log.level_procedure,
3049: g_module ||
3050: l_api_name,
3051: '145: l_suggested_user_name from UMX_PUB.get_suggested_username : ' ||
3052: l_suggested_user_name

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

3058: l_suggested_user_name := UPPER(TRIM(p_user_name));
3059: END IF;
3060:
3061: -- debug log
3062: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
3063: THEN
3064: fnd_log.STRING (fnd_log.level_procedure,
3065: g_module ||
3066: l_api_name,

Line 3064: fnd_log.STRING (fnd_log.level_procedure,

3060:
3061: -- debug log
3062: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
3063: THEN
3064: fnd_log.STRING (fnd_log.level_procedure,
3065: g_module ||
3066: l_api_name,
3067: '146: l_suggested_user_name : ' ||
3068: l_suggested_user_name

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

3077: fnd_user_pkg.testusername
3078: (x_user_name => l_suggested_user_name);
3079:
3080: -- debug log
3081: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
3082: THEN
3083: fnd_log.STRING (fnd_log.level_procedure,
3084: g_module ||
3085: l_api_name,

Line 3083: fnd_log.STRING (fnd_log.level_procedure,

3079:
3080: -- debug log
3081: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
3082: THEN
3083: fnd_log.STRING (fnd_log.level_procedure,
3084: g_module ||
3085: l_api_name,
3086: '150: l_test_user : ' ||
3087: l_test_user

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

3157: l_user_id);
3158: END IF; -- l_test_user = 0 or 3
3159:
3160: -- debug log
3161: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
3162: THEN
3163: fnd_log.STRING (fnd_log.level_procedure,
3164: g_module ||
3165: l_api_name,

Line 3163: fnd_log.STRING (fnd_log.level_procedure,

3159:
3160: -- debug log
3161: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
3162: THEN
3163: fnd_log.STRING (fnd_log.level_procedure,
3164: g_module ||
3165: l_api_name,
3166: '160: l_user_id : ' ||
3167: l_user_id

Line 3169: fnd_log.STRING (fnd_log.level_procedure,

3165: l_api_name,
3166: '160: l_user_id : ' ||
3167: l_user_id
3168: );
3169: fnd_log.STRING (fnd_log.level_procedure,
3170: g_module ||
3171: l_api_name,
3172: '160: x_user_name : ' ||
3173: x_user_name

Line 3175: fnd_log.STRING (fnd_log.level_procedure,

3171: l_api_name,
3172: '160: x_user_name : ' ||
3173: x_user_name
3174: );
3175: fnd_log.STRING (fnd_log.level_procedure,
3176: g_module ||
3177: l_api_name,
3178: '160: x_password : ' ||
3179: x_password

Line 3207: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level

3203:
3204: CLOSE l_security_grp_csr;
3205:
3206: -- debug log
3207: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level
3208: )
3209: THEN
3210: fnd_log.STRING (fnd_log.level_procedure,
3211: g_module ||

Line 3210: fnd_log.STRING (fnd_log.level_procedure,

3206: -- debug log
3207: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level
3208: )
3209: THEN
3210: fnd_log.STRING (fnd_log.level_procedure,
3211: g_module ||
3212: l_api_name,
3213: '170: l_responsibility_id : ' ||
3214: l_responsibility_id

Line 3216: fnd_log.STRING (fnd_log.level_procedure,

3212: l_api_name,
3213: '170: l_responsibility_id : ' ||
3214: l_responsibility_id
3215: );
3216: fnd_log.STRING (fnd_log.level_procedure,
3217: g_module ||
3218: l_api_name,
3219: '170: l_security_grp_id : ' ||
3220: l_security_grp_id

Line 3256: IF (fnd_log.level_procedure >=

3252: RETURN;
3253: ELSE
3254: -- error in fnd_profile.save
3255: -- debug log
3256: IF (fnd_log.level_procedure >=
3257: fnd_log.g_current_runtime_level
3258: )
3259: THEN
3260: fnd_log.STRING (fnd_log.level_procedure,

Line 3257: fnd_log.g_current_runtime_level

3253: ELSE
3254: -- error in fnd_profile.save
3255: -- debug log
3256: IF (fnd_log.level_procedure >=
3257: fnd_log.g_current_runtime_level
3258: )
3259: THEN
3260: fnd_log.STRING (fnd_log.level_procedure,
3261: g_module ||

Line 3260: fnd_log.STRING (fnd_log.level_procedure,

3256: IF (fnd_log.level_procedure >=
3257: fnd_log.g_current_runtime_level
3258: )
3259: THEN
3260: fnd_log.STRING (fnd_log.level_procedure,
3261: g_module ||
3262: l_api_name,
3263: '180: error in fnd_profile.save : '
3264: );

Line 3276: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level

3272: END IF;
3273: ELSE
3274: -- l_user_id is null, raise exception
3275: -- debug log
3276: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level
3277: )
3278: THEN
3279: fnd_log.STRING (fnd_log.level_procedure,
3280: g_module ||

Line 3279: fnd_log.STRING (fnd_log.level_procedure,

3275: -- debug log
3276: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level
3277: )
3278: THEN
3279: fnd_log.STRING (fnd_log.level_procedure,
3280: g_module ||
3281: l_api_name,
3282: '190: l_user_id is null, raise exception '
3283: );

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

3413: );
3414:
3415:
3416: -- end debug log
3417: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
3418: THEN
3419: fnd_log.STRING (fnd_log.level_procedure,
3420: g_module ||
3421: l_api_name,

Line 3419: fnd_log.STRING (fnd_log.level_procedure,

3415:
3416: -- end debug log
3417: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
3418: THEN
3419: fnd_log.STRING (fnd_log.level_procedure,
3420: g_module ||
3421: l_api_name,
3422: '1000: Leaving ' ||
3423: g_pkg_name ||

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

3427: END IF;
3428: EXCEPTION
3429: WHEN fnd_api.g_exc_error
3430: THEN
3431: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
3432: THEN
3433: fnd_log.STRING (fnd_log.level_procedure,
3434: g_module ||
3435: l_api_name,

Line 3433: fnd_log.STRING (fnd_log.level_procedure,

3429: WHEN fnd_api.g_exc_error
3430: THEN
3431: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
3432: THEN
3433: fnd_log.STRING (fnd_log.level_procedure,
3434: g_module ||
3435: l_api_name,
3436: '2000: Leaving ' ||
3437: g_pkg_name ||

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

3448: p_data => x_msg_data
3449: );
3450: WHEN fnd_api.g_exc_unexpected_error
3451: THEN
3452: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
3453: THEN
3454: fnd_log.STRING (fnd_log.level_procedure,
3455: g_module ||
3456: l_api_name,

Line 3454: fnd_log.STRING (fnd_log.level_procedure,

3450: WHEN fnd_api.g_exc_unexpected_error
3451: THEN
3452: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
3453: THEN
3454: fnd_log.STRING (fnd_log.level_procedure,
3455: g_module ||
3456: l_api_name,
3457: '3000: Leaving ' ||
3458: g_pkg_name ||

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

3470: p_data => x_msg_data
3471: );
3472: WHEN OTHERS
3473: THEN
3474: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
3475: THEN
3476: fnd_log.STRING (fnd_log.level_procedure,
3477: g_module ||
3478: l_api_name,

Line 3476: fnd_log.STRING (fnd_log.level_procedure,

3472: WHEN OTHERS
3473: THEN
3474: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
3475: THEN
3476: fnd_log.STRING (fnd_log.level_procedure,
3477: g_module ||
3478: l_api_name,
3479: '4000: Leaving ' ||
3480: g_pkg_name ||