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_K_ENTITY_LOCKS_PKG dependencies on FND_LOG

Line 36: G_DBG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

32: G_AMEND_CODE_DELETED CONSTANT VARCHAR2(30) := 'DELETED';
33: G_AMEND_CODE_ADDED CONSTANT VARCHAR2(30) := 'ADDED';
34: G_AMEND_CODE_UPDATED CONSTANT VARCHAR2(30) := 'UPDATED';
35:
36: G_DBG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
37: G_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;
38: G_EXCP_LEVEL NUMBER := FND_LOG.LEVEL_EXCEPTION;
39: G_STMT_LEVEL NUMBER := FND_LOG.LEVEL_STATEMENT;
40:

Line 37: G_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;

33: G_AMEND_CODE_ADDED CONSTANT VARCHAR2(30) := 'ADDED';
34: G_AMEND_CODE_UPDATED CONSTANT VARCHAR2(30) := 'UPDATED';
35:
36: G_DBG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
37: G_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;
38: G_EXCP_LEVEL NUMBER := FND_LOG.LEVEL_EXCEPTION;
39: G_STMT_LEVEL NUMBER := FND_LOG.LEVEL_STATEMENT;
40:
41:

Line 38: G_EXCP_LEVEL NUMBER := FND_LOG.LEVEL_EXCEPTION;

34: G_AMEND_CODE_UPDATED CONSTANT VARCHAR2(30) := 'UPDATED';
35:
36: G_DBG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
37: G_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;
38: G_EXCP_LEVEL NUMBER := FND_LOG.LEVEL_EXCEPTION;
39: G_STMT_LEVEL NUMBER := FND_LOG.LEVEL_STATEMENT;
40:
41:
42: PROCEDURE insert_row ( p_entity_name IN VARCHAR2,

Line 39: G_STMT_LEVEL NUMBER := FND_LOG.LEVEL_STATEMENT;

35:
36: G_DBG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
37: G_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;
38: G_EXCP_LEVEL NUMBER := FND_LOG.LEVEL_EXCEPTION;
39: G_STMT_LEVEL NUMBER := FND_LOG.LEVEL_STATEMENT;
40:
41:
42: PROCEDURE insert_row ( p_entity_name IN VARCHAR2,
43: p_entity_pk1 IN VARCHAR2,

Line 65: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

61: )
62: IS
63: BEGIN
64:
65: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
66: FND_LOG.STRING(G_STMT_LEVEL,
67: G_PKG_NAME, '1000: Entered Insert_Row Procedure' );
68: END IF;
69:

Line 66: FND_LOG.STRING(G_STMT_LEVEL,

62: IS
63: BEGIN
64:
65: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
66: FND_LOG.STRING(G_STMT_LEVEL,
67: G_PKG_NAME, '1000: Entered Insert_Row Procedure' );
68: END IF;
69:
70:

Line 112: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

108:
109: -- Check uniqueness
110:
111: X_RETURN_STATUS := G_RET_STS_SUCCESS;
112: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
113: FND_LOG.STRING(G_STMT_LEVEL,
114: G_PKG_NAME, '9999: Completed Insert_Row Procedure' );
115: END IF;
116:

Line 113: FND_LOG.STRING(G_STMT_LEVEL,

109: -- Check uniqueness
110:
111: X_RETURN_STATUS := G_RET_STS_SUCCESS;
112: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
113: FND_LOG.STRING(G_STMT_LEVEL,
114: G_PKG_NAME, '9999: Completed Insert_Row Procedure' );
115: END IF;
116:
117: EXCEPTION

Line 119: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

115: END IF;
116:
117: EXCEPTION
118: WHEN OTHERS THEN
119: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
120: FND_LOG.STRING(G_STMT_LEVEL,
121: G_PKG_NAME, '0000: Leaving Insert_Row because of EXCEPTION: '||sqlerrm);
122: END IF;
123: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

Line 120: FND_LOG.STRING(G_STMT_LEVEL,

116:
117: EXCEPTION
118: WHEN OTHERS THEN
119: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
120: FND_LOG.STRING(G_STMT_LEVEL,
121: G_PKG_NAME, '0000: Leaving Insert_Row because of EXCEPTION: '||sqlerrm);
122: END IF;
123: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
124: p_msg_name => G_UNEXPECTED_ERROR,

Line 152: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

148: l_del_Sql VARCHAR2(2000);
149:
150: BEGIN
151:
152: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
153: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: Entered delete_row ');
154: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: P_ENTITY_NAME ' || P_ENTITY_NAME );
155: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: p_entity_pk1 ' ||p_entity_pk1 );
156: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: p_entity_pk2 '||p_entity_pk2);

Line 153: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: Entered delete_row ');

149:
150: BEGIN
151:
152: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
153: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: Entered delete_row ');
154: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: P_ENTITY_NAME ' || P_ENTITY_NAME );
155: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: p_entity_pk1 ' ||p_entity_pk1 );
156: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: p_entity_pk2 '||p_entity_pk2);
157: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: p_entity_pk3 '||p_entity_pk3);

Line 154: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: P_ENTITY_NAME ' || P_ENTITY_NAME );

150: BEGIN
151:
152: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
153: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: Entered delete_row ');
154: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: P_ENTITY_NAME ' || P_ENTITY_NAME );
155: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: p_entity_pk1 ' ||p_entity_pk1 );
156: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: p_entity_pk2 '||p_entity_pk2);
157: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: p_entity_pk3 '||p_entity_pk3);
158: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: p_entity_pk4 '||p_entity_pk4);

Line 155: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: p_entity_pk1 ' ||p_entity_pk1 );

151:
152: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
153: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: Entered delete_row ');
154: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: P_ENTITY_NAME ' || P_ENTITY_NAME );
155: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: p_entity_pk1 ' ||p_entity_pk1 );
156: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: p_entity_pk2 '||p_entity_pk2);
157: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: p_entity_pk3 '||p_entity_pk3);
158: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: p_entity_pk4 '||p_entity_pk4);
159: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: p_entity_pk5 '||p_entity_pk5);

Line 156: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: p_entity_pk2 '||p_entity_pk2);

152: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
153: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: Entered delete_row ');
154: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: P_ENTITY_NAME ' || P_ENTITY_NAME );
155: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: p_entity_pk1 ' ||p_entity_pk1 );
156: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: p_entity_pk2 '||p_entity_pk2);
157: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: p_entity_pk3 '||p_entity_pk3);
158: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: p_entity_pk4 '||p_entity_pk4);
159: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: p_entity_pk5 '||p_entity_pk5);
160: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: P_LOCK_BY_ENTITY_ID '||P_LOCK_BY_ENTITY_ID);

Line 157: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: p_entity_pk3 '||p_entity_pk3);

153: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: Entered delete_row ');
154: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: P_ENTITY_NAME ' || P_ENTITY_NAME );
155: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: p_entity_pk1 ' ||p_entity_pk1 );
156: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: p_entity_pk2 '||p_entity_pk2);
157: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: p_entity_pk3 '||p_entity_pk3);
158: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: p_entity_pk4 '||p_entity_pk4);
159: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: p_entity_pk5 '||p_entity_pk5);
160: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: P_LOCK_BY_ENTITY_ID '||P_LOCK_BY_ENTITY_ID);
161: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: P_LOCK_by_document_type '||P_LOCK_by_document_type);

Line 158: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: p_entity_pk4 '||p_entity_pk4);

154: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: P_ENTITY_NAME ' || P_ENTITY_NAME );
155: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: p_entity_pk1 ' ||p_entity_pk1 );
156: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: p_entity_pk2 '||p_entity_pk2);
157: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: p_entity_pk3 '||p_entity_pk3);
158: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: p_entity_pk4 '||p_entity_pk4);
159: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: p_entity_pk5 '||p_entity_pk5);
160: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: P_LOCK_BY_ENTITY_ID '||P_LOCK_BY_ENTITY_ID);
161: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: P_LOCK_by_document_type '||P_LOCK_by_document_type);
162: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: p_LOCK_by_document_id '||p_LOCK_by_document_id);

Line 159: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: p_entity_pk5 '||p_entity_pk5);

155: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: p_entity_pk1 ' ||p_entity_pk1 );
156: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: p_entity_pk2 '||p_entity_pk2);
157: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: p_entity_pk3 '||p_entity_pk3);
158: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: p_entity_pk4 '||p_entity_pk4);
159: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: p_entity_pk5 '||p_entity_pk5);
160: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: P_LOCK_BY_ENTITY_ID '||P_LOCK_BY_ENTITY_ID);
161: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: P_LOCK_by_document_type '||P_LOCK_by_document_type);
162: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: p_LOCK_by_document_id '||p_LOCK_by_document_id);
163: END IF;

Line 160: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: P_LOCK_BY_ENTITY_ID '||P_LOCK_BY_ENTITY_ID);

156: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: p_entity_pk2 '||p_entity_pk2);
157: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: p_entity_pk3 '||p_entity_pk3);
158: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: p_entity_pk4 '||p_entity_pk4);
159: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: p_entity_pk5 '||p_entity_pk5);
160: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: P_LOCK_BY_ENTITY_ID '||P_LOCK_BY_ENTITY_ID);
161: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: P_LOCK_by_document_type '||P_LOCK_by_document_type);
162: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: p_LOCK_by_document_id '||p_LOCK_by_document_id);
163: END IF;
164:

Line 161: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: P_LOCK_by_document_type '||P_LOCK_by_document_type);

157: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: p_entity_pk3 '||p_entity_pk3);
158: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: p_entity_pk4 '||p_entity_pk4);
159: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: p_entity_pk5 '||p_entity_pk5);
160: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: P_LOCK_BY_ENTITY_ID '||P_LOCK_BY_ENTITY_ID);
161: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: P_LOCK_by_document_type '||P_LOCK_by_document_type);
162: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: p_LOCK_by_document_id '||p_LOCK_by_document_id);
163: END IF;
164:
165:

Line 162: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: p_LOCK_by_document_id '||p_LOCK_by_document_id);

158: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: p_entity_pk4 '||p_entity_pk4);
159: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: p_entity_pk5 '||p_entity_pk5);
160: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: P_LOCK_BY_ENTITY_ID '||P_LOCK_BY_ENTITY_ID);
161: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: P_LOCK_by_document_type '||P_LOCK_by_document_type);
162: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: p_LOCK_by_document_id '||p_LOCK_by_document_id);
163: END IF;
164:
165:
166: l_del_Sql := 'DELETE FROM OKC_K_ENTITY_LOCKS WHERE ENTITY_NAME = P_ENTITY_NAME AND ENTITY_PK1 = '|| ''''||p_entity_pk1 ||'''';

Line 190: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

186: IF p_LOCK_by_document_id IS NOT NULL THEN
187: l_del_Sql := l_del_Sql || ' AND LOCK_BY_DOCUMENT_ID = '||p_LOCK_by_document_id;
188: END IF;
189:
190: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
191: FND_LOG.STRING(G_STMT_LEVEL,
192: G_PKG_NAME, '0500: sql to delete the lock: '||l_del_Sql);
193: END IF;
194:

Line 191: FND_LOG.STRING(G_STMT_LEVEL,

187: l_del_Sql := l_del_Sql || ' AND LOCK_BY_DOCUMENT_ID = '||p_LOCK_by_document_id;
188: END IF;
189:
190: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
191: FND_LOG.STRING(G_STMT_LEVEL,
192: G_PKG_NAME, '0500: sql to delete the lock: '||l_del_Sql);
193: END IF;
194:
195:

Line 206: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

202: X_RETURN_STATUS := G_RET_STS_SUCCESS;
203:
204: EXCEPTION
205: WHEN OTHERS THEN
206: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
207: FND_LOG.STRING(G_STMT_LEVEL,
208: G_PKG_NAME, '0000: Leaving DELETE_row because of EXCEPTION: '||sqlerrm);
209: END IF;
210: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

Line 207: FND_LOG.STRING(G_STMT_LEVEL,

203:
204: EXCEPTION
205: WHEN OTHERS THEN
206: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
207: FND_LOG.STRING(G_STMT_LEVEL,
208: G_PKG_NAME, '0000: Leaving DELETE_row because of EXCEPTION: '||sqlerrm);
209: END IF;
210: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
211: p_msg_name => G_UNEXPECTED_ERROR,