13: ) AS
14: l_len NUMBER;
15: BEGIN
16: IF (l_Debug_Level <= 2) THEN
17: itg_debug_pub.Add('--- Entering validate VARCHAR2 ---' ,2);
18: END IF;
19:
20: IF NOT p_nullok AND p_value IS NULL THEN
21: IF (l_Debug_Level <= 1) THEN
38: RAISE FND_API.G_EXC_ERROR;
39: END IF;
40:
41: IF (l_Debug_Level <= 2) THEN
42: itg_debug_pub.Add('--- Exiting validate VARCHAR2 ---' ,2);
43: END IF;
44: END validate;
45:
46:
54: ) AS
55: l_len NUMBER;
56: BEGIN
57: IF (l_Debug_Level <= 2) THEN
58: itg_debug_pub.Add('--- Entering validate NUMBER ---' ,2);
59: END IF;
60:
61: IF NOT p_nullok AND p_value IS NULL THEN
62: IF (l_Debug_Level <= 1) THEN
77: RAISE FND_API.G_EXC_ERROR;
78: END IF;
79:
80: IF (l_Debug_Level <= 2) THEN
81: itg_debug_pub.Add('--- Exiting validate NUMBER ---' ,2);
82: END IF;
83:
84: END validate;
85: