[Home] [Help]
PACKAGE: APPS.OKS_RENEW_PVT
Source
1 Package OKS_RENEW_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKSRENWS.pls 120.1 2005/08/29 14:46:47 anjkumar noship $*/
3
4 --------------------------------------------------------------------------
5 -- GLOBAL MESSAGE CONSTANTS
6 ---------------------------------------------------------------------------
7 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
8 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
9 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
10 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
11 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
12 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
13 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
14 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_RENEW_UNEXPECTED_ERROR';
15 G_EXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_RENEW_ERROR';
16 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
17 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
18
19
20 ---------------------------------------------------------------------------
21 -- GLOBAL EXCEPTIONS
22 ---------------------------------------------------------------------------
23 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
24 G_EXCEPTION_ROLLBACK EXCEPTION;
25 G_ERROR EXCEPTION;
26
27 ---------------------------------------------------------------------------
28 -- GLOBAL VARIABLES
29 ---------------------------------------------------------------------------
30 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_RENEW_PVT';
31 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
32 G_NUM_ONE CONSTANT NUMBER := 1;
33
34
35 PROCEDURE Debug_Log(p_program_name IN VARCHAR2,
36 p_perf_msg IN VARCHAR2 DEFAULT NULL,
37 p_error_msg IN VARCHAR2 DEFAULT NULL,
38 p_path IN VARCHAR2 DEFAULT NULL);
39
40 PROCEDURE Debug_Log(p_program_name IN VARCHAR2,
41 p_perf_msg IN VARCHAR2 DEFAULT NULL,
42 p_error_msg IN VARCHAR2 DEFAULT NULL,
43 p_path IN VARCHAR2 DEFAULT NULL,
44 x_msg_data OUT NOCOPY VARCHAR2,
45 x_msg_count OUT NOCOPY NUMBER,
46 x_return_status OUT NOCOPY VARCHAR2);
47
48
49 END OKS_RENEW_PVT;