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

Line 16: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

12: ------------------------------------------------------------------------------
13: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_XPRT_IMPORT_CLAUSES_PVT';
14: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
15:
16: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
17: G_MODULE CONSTANT VARCHAR2(250) := 'okc.plsql.'||g_pkg_name||'.';
18: G_APPLICATION_ID CONSTANT NUMBER :=510; -- OKC Application
19:
20: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;

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

74:
75: BEGIN
76:
77: -- start debug log
78: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
79: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
80: G_MODULE||l_api_name,
81: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
82: END IF;

Line 79: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

75: BEGIN
76:
77: -- start debug log
78: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
79: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
80: G_MODULE||l_api_name,
81: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
82: END IF;
83:

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

208: -- Standard call to get message count and if count is 1, get message info.
209: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
210:
211: -- end debug log
212: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
213: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
214: G_MODULE||l_api_name,
215: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
216: END IF;

Line 213: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

209: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
210:
211: -- end debug log
212: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
213: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
214: G_MODULE||l_api_name,
215: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
216: END IF;
217:

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

216: END IF;
217:
218: EXCEPTION
219: WHEN OTHERS THEN
220: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
221: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
222: G_MODULE||l_api_name,
223: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
224: END IF;

Line 221: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

217:
218: EXCEPTION
219: WHEN OTHERS THEN
220: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
221: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
222: G_MODULE||l_api_name,
223: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
224: END IF;
225:

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

265:
266: BEGIN
267:
268: -- start debug log
269: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
270: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
271: G_MODULE||l_api_name,
272: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
273: END IF;

Line 270: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

266: BEGIN
267:
268: -- start debug log
269: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
270: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
271: G_MODULE||l_api_name,
272: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
273: END IF;
274:

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

637:
638:
639:
640: -- end debug log
641: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
642: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
643: G_MODULE||l_api_name,
644: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
645: END IF;

Line 642: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

638:
639:
640: -- end debug log
641: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
642: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
643: G_MODULE||l_api_name,
644: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
645: END IF;
646:

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

645: END IF;
646:
647: EXCEPTION
648: WHEN OTHERS THEN
649: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
650: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
651: G_MODULE||l_api_name,
652: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
653: END IF;

Line 650: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

646:
647: EXCEPTION
648: WHEN OTHERS THEN
649: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
650: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
651: G_MODULE||l_api_name,
652: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
653: END IF;
654:

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

694:
695: BEGIN
696:
697: -- start debug log
698: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
699: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
700: G_MODULE||l_api_name,
701: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
702: END IF;

Line 699: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

695: BEGIN
696:
697: -- start debug log
698: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
699: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
700: G_MODULE||l_api_name,
701: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
702: END IF;
703:

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

1064: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1065:
1066:
1067: -- end debug log
1068: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1069: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1070: G_MODULE||l_api_name,
1071: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1072: END IF;

Line 1069: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1065:
1066:
1067: -- end debug log
1068: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1069: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1070: G_MODULE||l_api_name,
1071: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1072: END IF;
1073:

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

1072: END IF;
1073:
1074: EXCEPTION
1075: WHEN OTHERS THEN
1076: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1077: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1078: G_MODULE||l_api_name,
1079: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1080: END IF;

Line 1077: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1073:
1074: EXCEPTION
1075: WHEN OTHERS THEN
1076: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1077: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1078: G_MODULE||l_api_name,
1079: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1080: END IF;
1081:

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

1173:
1174: BEGIN
1175:
1176: -- start debug log
1177: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1178: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1179: G_MODULE||l_api_name,
1180: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
1181: END IF;

Line 1178: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1174: BEGIN
1175:
1176: -- start debug log
1177: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1178: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1179: G_MODULE||l_api_name,
1180: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
1181: END IF;
1182:

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

1457: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1458:
1459:
1460: -- end debug log
1461: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1462: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1463: G_MODULE||l_api_name,
1464: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1465: END IF;

Line 1462: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1458:
1459:
1460: -- end debug log
1461: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1462: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1463: G_MODULE||l_api_name,
1464: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1465: END IF;
1466:

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

1465: END IF;
1466:
1467: EXCEPTION
1468: WHEN OTHERS THEN
1469: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1470: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1471: G_MODULE||l_api_name,
1472: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1473: END IF;

Line 1470: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1466:
1467: EXCEPTION
1468: WHEN OTHERS THEN
1469: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1470: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1471: G_MODULE||l_api_name,
1472: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1473: END IF;
1474:

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

1515:
1516: BEGIN
1517:
1518: -- start debug log
1519: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1520: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1521: G_MODULE||l_api_name,
1522: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
1523: END IF;

Line 1520: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1516: BEGIN
1517:
1518: -- start debug log
1519: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1520: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1521: G_MODULE||l_api_name,
1522: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
1523: END IF;
1524:

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

1884: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1885:
1886:
1887: -- end debug log
1888: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1889: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1890: G_MODULE||l_api_name,
1891: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1892: END IF;

Line 1889: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1885:
1886:
1887: -- end debug log
1888: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1889: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1890: G_MODULE||l_api_name,
1891: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1892: END IF;
1893:

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

1892: END IF;
1893:
1894: EXCEPTION
1895: WHEN OTHERS THEN
1896: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1897: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1898: G_MODULE||l_api_name,
1899: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1900: END IF;

Line 1897: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1893:
1894: EXCEPTION
1895: WHEN OTHERS THEN
1896: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1897: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1898: G_MODULE||l_api_name,
1899: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1900: END IF;
1901:

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

1984:
1985: BEGIN
1986:
1987: -- start debug log
1988: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1989: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1990: G_MODULE||l_api_name,
1991: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
1992: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 1989: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1985: BEGIN
1986:
1987: -- start debug log
1988: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1989: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1990: G_MODULE||l_api_name,
1991: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
1992: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1993: G_MODULE||l_api_name,

Line 1992: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1988: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1989: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1990: G_MODULE||l_api_name,
1991: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
1992: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1993: G_MODULE||l_api_name,
1994: '100: Parameters ');
1995: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1996: G_MODULE||l_api_name,

Line 1995: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1991: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
1992: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1993: G_MODULE||l_api_name,
1994: '100: Parameters ');
1995: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1996: G_MODULE||l_api_name,
1997: '100: p_org_id '||p_org_id);
1998: END IF;
1999:

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

2041: x_msg_count => x_msg_count,
2042: x_msg_data => x_msg_data);
2043:
2044: -- debug log
2045: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2046: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2047: G_MODULE||l_api_name,
2048: '111: After Calling OKC_XPRT_CZ_INT_PVT.create_rp_folder x_return_status : '||x_return_status);
2049: END IF;

Line 2046: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2042: x_msg_data => x_msg_data);
2043:
2044: -- debug log
2045: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2046: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2047: G_MODULE||l_api_name,
2048: '111: After Calling OKC_XPRT_CZ_INT_PVT.create_rp_folder x_return_status : '||x_return_status);
2049: END IF;
2050:

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

2058:
2059: END IF; -- folder does not exists
2060: CLOSE csr_clause_folder;
2061:
2062: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2063: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2064: G_MODULE||l_api_name,
2065: '120: Clause Folder Id: '||l_clause_folder_id);
2066: END IF;

Line 2063: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2059: END IF; -- folder does not exists
2060: CLOSE csr_clause_folder;
2061:
2062: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2063: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2064: G_MODULE||l_api_name,
2065: '120: Clause Folder Id: '||l_clause_folder_id);
2066: END IF;
2067:

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

2097: FETCH csr_cz_run_id INTO G_RUN_ID;
2098: CLOSE csr_cz_run_id;
2099:
2100: -- debug log
2101: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2102: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2103: G_MODULE||l_api_name,
2104: '150: Run Id :'||G_RUN_ID);
2105: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 2102: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2098: CLOSE csr_cz_run_id;
2099:
2100: -- debug log
2101: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2102: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2103: G_MODULE||l_api_name,
2104: '150: Run Id :'||G_RUN_ID);
2105: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2106: G_MODULE||l_api_name,

Line 2105: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2101: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2102: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2103: G_MODULE||l_api_name,
2104: '150: Run Id :'||G_RUN_ID);
2105: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2106: G_MODULE||l_api_name,
2107: '150: Clause Model Id :'||l_clause_model_id);
2108: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2109: G_MODULE||l_api_name,

Line 2108: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2104: '150: Run Id :'||G_RUN_ID);
2105: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2106: G_MODULE||l_api_name,
2107: '150: Clause Model Id :'||l_clause_model_id);
2108: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2109: G_MODULE||l_api_name,
2110: '150: Intent :'||l_intent);
2111: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2112: G_MODULE||l_api_name,

Line 2111: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2107: '150: Clause Model Id :'||l_clause_model_id);
2108: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2109: G_MODULE||l_api_name,
2110: '150: Intent :'||l_intent);
2111: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2112: G_MODULE||l_api_name,
2113: '150: Organization Name :'||G_ORGANIZATION_NAME);
2114: END IF;
2115:

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

2124: x_msg_count => x_msg_count
2125: );
2126:
2127: -- debug log
2128: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2129: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2130: G_MODULE||l_api_name,
2131: '200: After Calling create_clause_model x_return_status : '||x_return_status);
2132: END IF;

Line 2129: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2125: );
2126:
2127: -- debug log
2128: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2129: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2130: G_MODULE||l_api_name,
2131: '200: After Calling create_clause_model x_return_status : '||x_return_status);
2132: END IF;
2133:

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

2148: x_msg_count => x_msg_count
2149: );
2150:
2151: -- debug log
2152: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2153: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2154: G_MODULE||l_api_name,
2155: '300: After Calling create_clause_component x_return_status : '||x_return_status);
2156: END IF;

Line 2153: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2149: );
2150:
2151: -- debug log
2152: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2153: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2154: G_MODULE||l_api_name,
2155: '300: After Calling create_clause_component x_return_status : '||x_return_status);
2156: END IF;
2157:

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

2171: x_msg_count => x_msg_count
2172: );
2173:
2174: -- debug log
2175: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2176: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2177: G_MODULE||l_api_name,
2178: '400: After Calling create_clause_feature x_return_status : '||x_return_status);
2179: END IF;

Line 2176: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2172: );
2173:
2174: -- debug log
2175: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2176: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2177: G_MODULE||l_api_name,
2178: '400: After Calling create_clause_feature x_return_status : '||x_return_status);
2179: END IF;
2180:

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

2194: x_msg_count => x_msg_count
2195: );
2196:
2197: -- debug log
2198: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2199: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2200: G_MODULE||l_api_name,
2201: '500: After Calling create_clause_options x_return_status : '||x_return_status);
2202: END IF;

Line 2199: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2195: );
2196:
2197: -- debug log
2198: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2199: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2200: G_MODULE||l_api_name,
2201: '500: After Calling create_clause_options x_return_status : '||x_return_status);
2202: END IF;
2203:

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

2217: x_msg_count => x_msg_count
2218: );
2219:
2220: -- debug log
2221: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2222: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2223: G_MODULE||l_api_name,
2224: '600: After Calling create_variable_model_ref x_return_status : '||x_return_status);
2225: END IF;

Line 2222: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2218: );
2219:
2220: -- debug log
2221: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2222: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2223: G_MODULE||l_api_name,
2224: '600: After Calling create_variable_model_ref x_return_status : '||x_return_status);
2225: END IF;
2226:

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

2245: x_msg_data => x_msg_data,
2246: x_msg_count => x_msg_count
2247: );
2248: -- debug log
2249: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2250: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2251: G_MODULE||l_api_name,
2252: '700: After Calling OKC_XPRT_CZ_INT_PVT.import_generic x_return_status : '||
2253: l_import_status);

Line 2250: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2246: x_msg_count => x_msg_count
2247: );
2248: -- debug log
2249: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2250: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2251: G_MODULE||l_api_name,
2252: '700: After Calling OKC_XPRT_CZ_INT_PVT.import_generic x_return_status : '||
2253: l_import_status);
2254: END IF;

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

2264: x_msg_count => x_msg_count
2265: );
2266:
2267: -- debug log
2268: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2269: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2270: G_MODULE||l_api_name,
2271: '750: After Calling OKC_XPRT_UTIL_PVT.check_import_status x_return_status : '||
2272: x_return_status);

Line 2269: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2265: );
2266:
2267: -- debug log
2268: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2269: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2270: G_MODULE||l_api_name,
2271: '750: After Calling OKC_XPRT_UTIL_PVT.check_import_status x_return_status : '||
2272: x_return_status);
2273: END IF;

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

2289: -- Standard call to get message count and if count is 1, get message info.
2290: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2291:
2292: -- end debug log
2293: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2294: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2295: G_MODULE||l_api_name,
2296: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2297: END IF;

Line 2294: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2290: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2291:
2292: -- end debug log
2293: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2294: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2295: G_MODULE||l_api_name,
2296: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2297: END IF;
2298:

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

2297: END IF;
2298:
2299: EXCEPTION
2300: WHEN FND_API.G_EXC_ERROR THEN
2301: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2302: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2303: G_MODULE||l_api_name,
2304: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2305: END IF;

Line 2302: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2298:
2299: EXCEPTION
2300: WHEN FND_API.G_EXC_ERROR THEN
2301: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2302: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2303: G_MODULE||l_api_name,
2304: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2305: END IF;
2306:

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

2307: x_return_status := G_RET_STS_ERROR ;
2308: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2309:
2310: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2311: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2312: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2313: G_MODULE||l_api_name,
2314: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2315: END IF;

Line 2312: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2308: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2309:
2310: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2311: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2312: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2313: G_MODULE||l_api_name,
2314: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2315: END IF;
2316:

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

2317: x_return_status := G_RET_STS_UNEXP_ERROR ;
2318: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2319:
2320: WHEN OTHERS THEN
2321: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2322: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2323: G_MODULE||l_api_name,
2324: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2325: END IF;

Line 2322: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2318: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2319:
2320: WHEN OTHERS THEN
2321: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2322: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2323: G_MODULE||l_api_name,
2324: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2325: END IF;
2326: