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.OKL_VP_STS_PUB dependencies on FND_API

Line 24: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

20:
21: l_data VARCHAR2(100);
22: l_api_name CONSTANT VARCHAR2(30) := 'get_listof_new_statuses';
23: l_count NUMBER ;
24: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
25: l_contract_id NUMBER;
26: BEGIN
27: x_return_status := FND_API.G_RET_STS_SUCCESS;
28:

Line 27: x_return_status := FND_API.G_RET_STS_SUCCESS;

23: l_count NUMBER ;
24: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
25: l_contract_id NUMBER;
26: BEGIN
27: x_return_status := FND_API.G_RET_STS_SUCCESS;
28:
29:
30:
31:

Line 47: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

43: p_end_date,
44: x_sts_tbl);
45:
46:
47: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
48: RAISE FND_API.G_EXC_ERROR;
49: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
50: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
51: END IF;

Line 48: RAISE FND_API.G_EXC_ERROR;

44: x_sts_tbl);
45:
46:
47: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
48: RAISE FND_API.G_EXC_ERROR;
49: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
50: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
51: END IF;
52:

Line 49: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

45:
46:
47: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
48: RAISE FND_API.G_EXC_ERROR;
49: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
50: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
51: END IF;
52:
53:

Line 50: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

46:
47: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
48: RAISE FND_API.G_EXC_ERROR;
49: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
50: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
51: END IF;
52:
53:
54:

Line 57: WHEN FND_API.G_EXC_ERROR THEN

53:
54:
55:
56: EXCEPTION
57: WHEN FND_API.G_EXC_ERROR THEN
58: -- notify caller of an UNEXPECTED error
59: x_return_status := FND_API.G_RET_STS_ERROR;
60:
61: -- store SQL error message on message stack for caller

Line 59: x_return_status := FND_API.G_RET_STS_ERROR;

55:
56: EXCEPTION
57: WHEN FND_API.G_EXC_ERROR THEN
58: -- notify caller of an UNEXPECTED error
59: x_return_status := FND_API.G_RET_STS_ERROR;
60:
61: -- store SQL error message on message stack for caller
62: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
63: p_count => x_msg_count,

Line 66: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

62: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
63: p_count => x_msg_count,
64: p_data => x_msg_data);
65:
66: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
67: -- notify caller of an UNEXPECTED error
68: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
69:
70: -- store SQL error message on message stack for caller

Line 68: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

64: p_data => x_msg_data);
65:
66: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
67: -- notify caller of an UNEXPECTED error
68: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
69:
70: -- store SQL error message on message stack for caller
71: FND_MSG_PUB.count_and_get(p_encoded => OKC_API.G_FALSE,
72: p_count => x_msg_count,

Line 77: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

73: p_data => x_msg_data);
74:
75: WHEN OTHERS THEN
76: -- notify caller of an UNEXPECTED error
77: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
78: FND_MSG_PUB.ADD_EXC_MSG('OKL_VP_STS_PUB','get_listof_new_statuses');
79:
80: -- store SQL error message on message stack for caller
81: FND_MSG_PUB.count_and_get(p_encoded => OKC_API.G_FALSE,

Line 103: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

99:
100: l_data VARCHAR2(100);
101: l_api_name CONSTANT VARCHAR2(30) := 'change_agreement_status';
102: l_count NUMBER ;
103: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
104: l_contract_id NUMBER;
105: BEGIN
106: x_return_status := FND_API.G_RET_STS_SUCCESS;
107:

Line 106: x_return_status := FND_API.G_RET_STS_SUCCESS;

102: l_count NUMBER ;
103: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
104: l_contract_id NUMBER;
105: BEGIN
106: x_return_status := FND_API.G_RET_STS_SUCCESS;
107:
108:
109:
110: -- call process api to CHANGE Status

Line 123: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

119: p_current_sts_code,
120: p_new_sts_code);
121:
122:
123: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
124: RAISE FND_API.G_EXC_ERROR;
125: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
127: END IF;

Line 124: RAISE FND_API.G_EXC_ERROR;

120: p_new_sts_code);
121:
122:
123: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
124: RAISE FND_API.G_EXC_ERROR;
125: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
127: END IF;
128:

Line 125: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

121:
122:
123: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
124: RAISE FND_API.G_EXC_ERROR;
125: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
127: END IF;
128:
129:

Line 126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

122:
123: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
124: RAISE FND_API.G_EXC_ERROR;
125: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
127: END IF;
128:
129:
130:

Line 134: WHEN FND_API.G_EXC_ERROR THEN

130:
131:
132:
133: EXCEPTION
134: WHEN FND_API.G_EXC_ERROR THEN
135: -- notify caller of an UNEXPECTED error
136: x_return_status := FND_API.G_RET_STS_ERROR;
137:
138: -- store SQL error message on message stack for caller

Line 136: x_return_status := FND_API.G_RET_STS_ERROR;

132:
133: EXCEPTION
134: WHEN FND_API.G_EXC_ERROR THEN
135: -- notify caller of an UNEXPECTED error
136: x_return_status := FND_API.G_RET_STS_ERROR;
137:
138: -- store SQL error message on message stack for caller
139: FND_MSG_PUB.count_and_get(p_encoded => OKC_API.G_FALSE,
140: p_count => x_msg_count,

Line 143: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

139: FND_MSG_PUB.count_and_get(p_encoded => OKC_API.G_FALSE,
140: p_count => x_msg_count,
141: p_data => x_msg_data);
142:
143: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
144: -- notify caller of an UNEXPECTED error
145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
146:
147: -- store SQL error message on message stack for caller

Line 145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

141: p_data => x_msg_data);
142:
143: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
144: -- notify caller of an UNEXPECTED error
145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
146:
147: -- store SQL error message on message stack for caller
148: FND_MSG_PUB.count_and_get(p_encoded => OKC_API.G_FALSE,
149: p_count => x_msg_count,

Line 154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

150: p_data => x_msg_data);
151:
152: WHEN OTHERS THEN
153: -- notify caller of an UNEXPECTED error
154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
155: FND_MSG_PUB.ADD_EXC_MSG('OKL_VP_STS_PUB','get_listof_new_statuses');
156:
157: -- store SQL error message on message stack for caller
158: FND_MSG_PUB.count_and_get(p_encoded => OKC_API.G_FALSE,