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_VENDOR_PROGRAM_PUB dependencies on FND_API

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

21: l_hdr_rec program_header_rec_type;
22: l_data VARCHAR2(100);
23: l_api_name CONSTANT VARCHAR2(30) := 'create_program';
24: l_count NUMBER ;
25: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
26: BEGIN
27: x_return_status := FND_API.G_RET_STS_SUCCESS;
28:
29: l_hdr_rec := p_hdr_rec;

Line 27: x_return_status := FND_API.G_RET_STS_SUCCESS;

23: l_api_name CONSTANT VARCHAR2(30) := 'create_program';
24: l_count NUMBER ;
25: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
26: BEGIN
27: x_return_status := FND_API.G_RET_STS_SUCCESS;
28:
29: l_hdr_rec := p_hdr_rec;
30:
31:

Line 46: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

42: x_header_rec => x_header_rec,
43: x_k_header_rec => x_k_header_rec);
44:
45:
46: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
47: RAISE FND_API.G_EXC_ERROR;
48: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
49: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
50: END IF;

Line 47: RAISE FND_API.G_EXC_ERROR;

43: x_k_header_rec => x_k_header_rec);
44:
45:
46: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
47: RAISE FND_API.G_EXC_ERROR;
48: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
49: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
50: END IF;
51:

Line 48: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 49: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 56: WHEN FND_API.G_EXC_ERROR THEN

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

Line 58: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 65: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 67: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 76: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

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

97: l_hdr_rec program_header_rec_type;
98: l_data VARCHAR2(100);
99: l_api_name CONSTANT VARCHAR2(30) := 'update_program';
100: l_count NUMBER ;
101: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
102: BEGIN
103: x_return_status := FND_API.G_RET_STS_SUCCESS;
104:
105: l_hdr_rec := p_hdr_rec;

Line 103: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 122: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

118: p_parent_agreement_id => p_parent_agreement_id
119: );
120:
121:
122: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
123: RAISE FND_API.G_EXC_ERROR;
124: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
126: END IF;

Line 123: RAISE FND_API.G_EXC_ERROR;

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

Line 124: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 132: WHEN FND_API.G_EXC_ERROR THEN

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

Line 134: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 141: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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