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_DELETE_CONTRACT_PUB dependencies on OKC_API

Line 13: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

9: x_msg_count OUT NOCOPY NUMBER,
10: x_msg_data OUT NOCOPY VARCHAR2,
11: p_chrv_rec IN OKC_CONTRACT_PUB.chrv_rec_type ) IS
12:
13: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
14: l_api_name VARCHAR2(30) := 'Delete_Contract';
15:
16: BEGIN
17: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 17: x_return_status := OKC_API.G_RET_STS_SUCCESS;

13: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
14: l_api_name VARCHAR2(30) := 'Delete_Contract';
15:
16: BEGIN
17: x_return_status := OKC_API.G_RET_STS_SUCCESS;
18:
19: --Start activity;
20: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
21: p_init_msg_list,

Line 20: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

16: BEGIN
17: x_return_status := OKC_API.G_RET_STS_SUCCESS;
18:
19: --Start activity;
20: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
21: p_init_msg_list,
22: '_PUB',
23: x_return_status);
24:

Line 25: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

21: p_init_msg_list,
22: '_PUB',
23: x_return_status);
24:
25: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
26: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
27: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
28: RAISE OKC_API.G_EXCEPTION_ERROR;
29: END IF;

Line 26: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

22: '_PUB',
23: x_return_status);
24:
25: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
26: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
27: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
28: RAISE OKC_API.G_EXCEPTION_ERROR;
29: END IF;
30:

Line 27: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

23: x_return_status);
24:
25: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
26: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
27: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
28: RAISE OKC_API.G_EXCEPTION_ERROR;
29: END IF;
30:
31:

Line 28: RAISE OKC_API.G_EXCEPTION_ERROR;

24:
25: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
26: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
27: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
28: RAISE OKC_API.G_EXCEPTION_ERROR;
29: END IF;
30:
31:
32: OKC_DELETE_CONTRACT_PVT.delete_contract(

Line 41: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

37: x_msg_data => x_msg_data,
38: p_chrv_rec => p_chrv_rec);
39:
40:
41: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
42:
43: EXCEPTION
44: WHEN OKC_API.G_EXCEPTION_ERROR THEN
45: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 44: WHEN OKC_API.G_EXCEPTION_ERROR THEN

40:
41: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
42:
43: EXCEPTION
44: WHEN OKC_API.G_EXCEPTION_ERROR THEN
45: x_return_status := OKC_API.HANDLE_EXCEPTIONS
46: (
47: l_api_name,
48: G_PKG_NAME,

Line 45: x_return_status := OKC_API.HANDLE_EXCEPTIONS

41: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
42:
43: EXCEPTION
44: WHEN OKC_API.G_EXCEPTION_ERROR THEN
45: x_return_status := OKC_API.HANDLE_EXCEPTIONS
46: (
47: l_api_name,
48: G_PKG_NAME,
49: 'OKC_API.G_RET_STS_ERROR',

Line 49: 'OKC_API.G_RET_STS_ERROR',

45: x_return_status := OKC_API.HANDLE_EXCEPTIONS
46: (
47: l_api_name,
48: G_PKG_NAME,
49: 'OKC_API.G_RET_STS_ERROR',
50: x_msg_count,
51: x_msg_data,
52: '_PUB'
53: );

Line 54: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

50: x_msg_count,
51: x_msg_data,
52: '_PUB'
53: );
54: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
55: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
56: (
57: l_api_name,
58: G_PKG_NAME,

Line 55: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

51: x_msg_data,
52: '_PUB'
53: );
54: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
55: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
56: (
57: l_api_name,
58: G_PKG_NAME,
59: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 59: 'OKC_API.G_RET_STS_UNEXP_ERROR',

55: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
56: (
57: l_api_name,
58: G_PKG_NAME,
59: 'OKC_API.G_RET_STS_UNEXP_ERROR',
60: x_msg_count,
61: x_msg_data,
62: '_PUB'
63: );

Line 76: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

72: x_msg_data OUT NOCOPY VARCHAR2,
73: p_chrv_tbl IN OKC_CONTRACT_PUB.chrv_tbl_type) IS
74:
75: i NUMBER := 0;
76: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
77: l_api_name VARCHAR2(30) := 'Delete_Contract';
78:
79: BEGIN
80:

Line 81: x_return_status := OKC_API.G_RET_STS_SUCCESS;

77: l_api_name VARCHAR2(30) := 'Delete_Contract';
78:
79: BEGIN
80:
81: x_return_status := OKC_API.G_RET_STS_SUCCESS;
82:
83: --Start activity;
84: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
85: p_init_msg_list,

Line 84: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

80:
81: x_return_status := OKC_API.G_RET_STS_SUCCESS;
82:
83: --Start activity;
84: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
85: p_init_msg_list,
86: '_PUB',
87: x_return_status);
88: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 88: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

84: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
85: p_init_msg_list,
86: '_PUB',
87: x_return_status);
88: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
89: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
90: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
91: RAISE OKC_API.G_EXCEPTION_ERROR;
92: END IF;

Line 89: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

85: p_init_msg_list,
86: '_PUB',
87: x_return_status);
88: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
89: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
90: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
91: RAISE OKC_API.G_EXCEPTION_ERROR;
92: END IF;
93:

Line 90: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

86: '_PUB',
87: x_return_status);
88: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
89: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
90: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
91: RAISE OKC_API.G_EXCEPTION_ERROR;
92: END IF;
93:
94: IF p_chrv_tbl.COUNT > 0 THEN

Line 91: RAISE OKC_API.G_EXCEPTION_ERROR;

87: x_return_status);
88: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
89: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
90: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
91: RAISE OKC_API.G_EXCEPTION_ERROR;
92: END IF;
93:
94: IF p_chrv_tbl.COUNT > 0 THEN
95: i := p_chrv_tbl.FIRST;

Line 105: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

101: x_msg_count => x_msg_count,
102: x_msg_data => x_msg_data,
103: p_chrv_rec => p_chrv_tbl(i));
104:
105: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
106: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
107: x_return_status := l_return_status;
108: raise G_EXCEPTION_HALT_PROCESSING;
109: ELSE

Line 106: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

102: x_msg_data => x_msg_data,
103: p_chrv_rec => p_chrv_tbl(i));
104:
105: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
106: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
107: x_return_status := l_return_status;
108: raise G_EXCEPTION_HALT_PROCESSING;
109: ELSE
110: x_return_status := l_return_status;

Line 118: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

114: i := p_chrv_tbl.NEXT(i);
115: END LOOP;
116: END IF;
117:
118: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
119:
120: EXCEPTION
121: WHEN OKC_API.G_EXCEPTION_ERROR THEN
122: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 121: WHEN OKC_API.G_EXCEPTION_ERROR THEN

117:
118: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
119:
120: EXCEPTION
121: WHEN OKC_API.G_EXCEPTION_ERROR THEN
122: x_return_status := OKC_API.HANDLE_EXCEPTIONS
123: (
124: l_api_name,
125: G_PKG_NAME,

Line 122: x_return_status := OKC_API.HANDLE_EXCEPTIONS

118: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
119:
120: EXCEPTION
121: WHEN OKC_API.G_EXCEPTION_ERROR THEN
122: x_return_status := OKC_API.HANDLE_EXCEPTIONS
123: (
124: l_api_name,
125: G_PKG_NAME,
126: 'OKC_API.G_RET_STS_ERROR',

Line 126: 'OKC_API.G_RET_STS_ERROR',

122: x_return_status := OKC_API.HANDLE_EXCEPTIONS
123: (
124: l_api_name,
125: G_PKG_NAME,
126: 'OKC_API.G_RET_STS_ERROR',
127: x_msg_count,
128: x_msg_data,
129: '_PUB'
130: );

Line 131: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

127: x_msg_count,
128: x_msg_data,
129: '_PUB'
130: );
131: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
132: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
133: (
134: l_api_name,
135: G_PKG_NAME,

Line 132: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

128: x_msg_data,
129: '_PUB'
130: );
131: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
132: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
133: (
134: l_api_name,
135: G_PKG_NAME,
136: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 136: 'OKC_API.G_RET_STS_UNEXP_ERROR',

132: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
133: (
134: l_api_name,
135: G_PKG_NAME,
136: 'OKC_API.G_RET_STS_UNEXP_ERROR',
137: x_msg_count,
138: x_msg_data,
139: '_PUB'
140: );

Line 144: OKC_API.set_message(p_app_name => g_app_name,

140: );
141: WHEN G_EXCEPTION_HALT_PROCESSING THEN
142: NULL;
143: WHEN OTHERS THEN
144: OKC_API.set_message(p_app_name => g_app_name,
145: p_msg_name => g_unexpected_error,
146: p_token1 => g_sqlcode_token,
147: p_token1_value => sqlcode,
148: p_token2 => g_sqlerrm_token,

Line 150: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

146: p_token1 => g_sqlcode_token,
147: p_token1_value => sqlcode,
148: p_token2 => g_sqlerrm_token,
149: p_token2_value => sqlerrm);
150: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
151: END Delete_Contract;
152:
153: END OKC_DELETE_CONTRACT_PUB;