34: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
35: ---------------------------------------------------------------------------
36:
37: -- Constants used for Message Logging
38: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
39: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
40: -- G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
41: G_LEVEL_EXCEPTION CONSTANT NUMBER := 17;
42: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
35: ---------------------------------------------------------------------------
36:
37: -- Constants used for Message Logging
38: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
39: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
40: -- G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
41: G_LEVEL_EXCEPTION CONSTANT NUMBER := 17;
42: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
43: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
36:
37: -- Constants used for Message Logging
38: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
39: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
40: -- G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
41: G_LEVEL_EXCEPTION CONSTANT NUMBER := 17;
42: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
43: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
44: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
38: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
39: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
40: -- G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
41: G_LEVEL_EXCEPTION CONSTANT NUMBER := 17;
42: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
43: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
44: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
45: G_LEVEL_CURRENT CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
46: G_MODULE_CURRENT CONSTANT VARCHAR2(255) := 'oks.plsql.oks_extwar_util_pub';
39: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
40: -- G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
41: G_LEVEL_EXCEPTION CONSTANT NUMBER := 17;
42: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
43: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
44: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
45: G_LEVEL_CURRENT CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
46: G_MODULE_CURRENT CONSTANT VARCHAR2(255) := 'oks.plsql.oks_extwar_util_pub';
47:
40: -- G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
41: G_LEVEL_EXCEPTION CONSTANT NUMBER := 17;
42: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
43: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
44: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
45: G_LEVEL_CURRENT CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
46: G_MODULE_CURRENT CONSTANT VARCHAR2(255) := 'oks.plsql.oks_extwar_util_pub';
47:
48:
41: G_LEVEL_EXCEPTION CONSTANT NUMBER := 17;
42: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
43: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
44: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
45: G_LEVEL_CURRENT CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
46: G_MODULE_CURRENT CONSTANT VARCHAR2(255) := 'oks.plsql.oks_extwar_util_pub';
47:
48:
49: TYPE contact_dtl_rec IS RECORD