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

Line 27: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

23: -- passed but the workorder and operation is passed, then the login is at operation level.
24: -- If resource details are passed, then login is at the operation and resource level.
25: --
26: PROCEDURE Workorder_Login(p_api_version IN NUMBER,
27: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
28: p_commit IN VARCHAR2 := FND_API.G_FALSE,
29: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
30: p_module_type IN VARCHAR2 := NULL,
31: x_return_status OUT NOCOPY VARCHAR2,

Line 28: p_commit IN VARCHAR2 := FND_API.G_FALSE,

24: -- If resource details are passed, then login is at the operation and resource level.
25: --
26: PROCEDURE Workorder_Login(p_api_version IN NUMBER,
27: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
28: p_commit IN VARCHAR2 := FND_API.G_FALSE,
29: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
30: p_module_type IN VARCHAR2 := NULL,
31: x_return_status OUT NOCOPY VARCHAR2,
32: x_msg_count OUT NOCOPY NUMBER,

Line 29: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

25: --
26: PROCEDURE Workorder_Login(p_api_version IN NUMBER,
27: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
28: p_commit IN VARCHAR2 := FND_API.G_FALSE,
29: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
30: p_module_type IN VARCHAR2 := NULL,
31: x_return_status OUT NOCOPY VARCHAR2,
32: x_msg_count OUT NOCOPY NUMBER,
33: x_msg_data OUT NOCOPY VARCHAR2,

Line 57: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,

53: 'At the start of PLSQL procedure' );
54: END IF;
55:
56: -- Standard call to check for api compatibility
57: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
58: G_PKG_NAME) THEN
59: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
60: END IF;
61:

Line 59: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

55:
56: -- Standard call to check for api compatibility
57: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
58: G_PKG_NAME) THEN
59: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
60: END IF;
61:
62: -- Standard start of API savepoint
63: SAVEPOINT Workorder_Login_Pub;

Line 66: IF FND_API.To_Boolean(p_init_msg_list) THEN

62: -- Standard start of API savepoint
63: SAVEPOINT Workorder_Login_Pub;
64:
65: -- Initialize message list if p_init_msg_list is set to TRUE
66: IF FND_API.To_Boolean(p_init_msg_list) THEN
67: FND_MSG_PUB.Initialize;
68: END IF;
69:
70: -- Initialize Procedure return status to success

Line 71: x_return_status := FND_API.G_RET_STS_SUCCESS;

67: FND_MSG_PUB.Initialize;
68: END IF;
69:
70: -- Initialize Procedure return status to success
71: x_return_status := FND_API.G_RET_STS_SUCCESS;
72:
73: -- Call private api.
74: AHL_PRD_WO_LOGIN_PVT.Workorder_Login(
75: p_api_version => 1.0,

Line 76: p_init_msg_list => FND_API.G_FALSE,

72:
73: -- Call private api.
74: AHL_PRD_WO_LOGIN_PVT.Workorder_Login(
75: p_api_version => 1.0,
76: p_init_msg_list => FND_API.G_FALSE,
77: p_commit => FND_API.G_FALSE,
78: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
79: p_module_type => NULL,
80: x_return_status => x_return_status,

Line 77: p_commit => FND_API.G_FALSE,

73: -- Call private api.
74: AHL_PRD_WO_LOGIN_PVT.Workorder_Login(
75: p_api_version => 1.0,
76: p_init_msg_list => FND_API.G_FALSE,
77: p_commit => FND_API.G_FALSE,
78: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
79: p_module_type => NULL,
80: x_return_status => x_return_status,
81: x_msg_count => x_msg_count,

Line 78: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

74: AHL_PRD_WO_LOGIN_PVT.Workorder_Login(
75: p_api_version => 1.0,
76: p_init_msg_list => FND_API.G_FALSE,
77: p_commit => FND_API.G_FALSE,
78: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
79: p_module_type => NULL,
80: x_return_status => x_return_status,
81: x_msg_count => x_msg_count,
82: x_msg_data => x_msg_data,

Line 94: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

90: p_resource_id => p_resource_id);
91:
92:
93: -- Raise errors if exceptions occur
94: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
95: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
96: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
97: RAISE FND_API.G_EXC_ERROR;
98: END IF;

Line 95: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

91:
92:
93: -- Raise errors if exceptions occur
94: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
95: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
96: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
97: RAISE FND_API.G_EXC_ERROR;
98: END IF;
99:

Line 96: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

92:
93: -- Raise errors if exceptions occur
94: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
95: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
96: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
97: RAISE FND_API.G_EXC_ERROR;
98: END IF;
99:
100: -- Standard check of p_commit

Line 97: RAISE FND_API.G_EXC_ERROR;

93: -- Raise errors if exceptions occur
94: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
95: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
96: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
97: RAISE FND_API.G_EXC_ERROR;
98: END IF;
99:
100: -- Standard check of p_commit
101: IF FND_API.TO_BOOLEAN(p_commit) THEN

Line 101: IF FND_API.TO_BOOLEAN(p_commit) THEN

97: RAISE FND_API.G_EXC_ERROR;
98: END IF;
99:
100: -- Standard check of p_commit
101: IF FND_API.TO_BOOLEAN(p_commit) THEN
102: COMMIT WORK;
103: END IF;
104:
105: -- Standard call to get message count and if count is 1, get message info

Line 109: p_encoded => fnd_api.g_false

105: -- Standard call to get message count and if count is 1, get message info
106: FND_MSG_PUB.Count_And_Get
107: ( p_count => x_msg_count,
108: p_data => x_msg_data,
109: p_encoded => fnd_api.g_false
110: );
111:
112: -- log debug message.
113: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL) THEN

Line 121: WHEN FND_API.G_EXC_ERROR THEN

117:
118: --
119: EXCEPTION
120:
121: WHEN FND_API.G_EXC_ERROR THEN
122: x_return_status := FND_API.G_RET_STS_ERROR;
123: Rollback to Workorder_Login_Pub;
124: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
125: p_data => x_msg_data,

Line 122: x_return_status := FND_API.G_RET_STS_ERROR;

118: --
119: EXCEPTION
120:
121: WHEN FND_API.G_EXC_ERROR THEN
122: x_return_status := FND_API.G_RET_STS_ERROR;
123: Rollback to Workorder_Login_Pub;
124: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
125: p_data => x_msg_data,
126: p_encoded => fnd_api.g_false);

Line 126: p_encoded => fnd_api.g_false);

122: x_return_status := FND_API.G_RET_STS_ERROR;
123: Rollback to Workorder_Login_Pub;
124: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
125: p_data => x_msg_data,
126: p_encoded => fnd_api.g_false);
127:
128: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
130: Rollback to Workorder_Login_Pub;

Line 128: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

124: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
125: p_data => x_msg_data,
126: p_encoded => fnd_api.g_false);
127:
128: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
130: Rollback to Workorder_Login_Pub;
131: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
132: p_data => x_msg_data,

Line 129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

125: p_data => x_msg_data,
126: p_encoded => fnd_api.g_false);
127:
128: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
130: Rollback to Workorder_Login_Pub;
131: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
132: p_data => x_msg_data,
133: p_encoded => fnd_api.g_false);

Line 133: p_encoded => fnd_api.g_false);

129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
130: Rollback to Workorder_Login_Pub;
131: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
132: p_data => x_msg_data,
133: p_encoded => fnd_api.g_false);
134:
135: WHEN OTHERS THEN
136:
137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

133: p_encoded => fnd_api.g_false);
134:
135: WHEN OTHERS THEN
136:
137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
138: Rollback to Workorder_Login_Pub;
139: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
140: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
141: p_procedure_name => 'Workorder_Login',

Line 146: p_encoded => fnd_api.g_false);

142: p_error_text => SUBSTR(SQLERRM,1,240));
143: END IF;
144: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
145: p_data => x_msg_data,
146: p_encoded => fnd_api.g_false);
147:
148:
149: END Workorder_Login;
150:

Line 166: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

162: -- If resource details are passed, then logout is at the operation and resource level.
163: --
164:
165: PROCEDURE Workorder_Logout(p_api_version IN NUMBER,
166: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
167: p_commit IN VARCHAR2 := FND_API.G_FALSE,
168: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
169: p_module_type IN VARCHAR2 := NULL,
170: x_return_status OUT NOCOPY VARCHAR2,

Line 167: p_commit IN VARCHAR2 := FND_API.G_FALSE,

163: --
164:
165: PROCEDURE Workorder_Logout(p_api_version IN NUMBER,
166: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
167: p_commit IN VARCHAR2 := FND_API.G_FALSE,
168: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
169: p_module_type IN VARCHAR2 := NULL,
170: x_return_status OUT NOCOPY VARCHAR2,
171: x_msg_count OUT NOCOPY NUMBER,

Line 168: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

164:
165: PROCEDURE Workorder_Logout(p_api_version IN NUMBER,
166: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
167: p_commit IN VARCHAR2 := FND_API.G_FALSE,
168: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
169: p_module_type IN VARCHAR2 := NULL,
170: x_return_status OUT NOCOPY VARCHAR2,
171: x_msg_count OUT NOCOPY NUMBER,
172: x_msg_data OUT NOCOPY VARCHAR2,

Line 197: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,

193: END IF;
194:
195:
196: -- Standard call to check for call compatibility
197: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
198: G_PKG_NAME) THEN
199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
200: END IF;
201:

Line 199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

195:
196: -- Standard call to check for call compatibility
197: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
198: G_PKG_NAME) THEN
199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
200: END IF;
201:
202: -- Standard start of API savepoint
203: SAVEPOINT Workorder_Logout_Pub;

Line 206: IF FND_API.To_Boolean(p_init_msg_list) THEN

202: -- Standard start of API savepoint
203: SAVEPOINT Workorder_Logout_Pub;
204:
205: -- Initialize message list if p_init_msg_list is set to TRUE
206: IF FND_API.To_Boolean(p_init_msg_list) THEN
207: FND_MSG_PUB.Initialize;
208: END IF;
209:
210: -- Initialize Procedure return status to success

Line 211: x_return_status := FND_API.G_RET_STS_SUCCESS;

207: FND_MSG_PUB.Initialize;
208: END IF;
209:
210: -- Initialize Procedure return status to success
211: x_return_status := FND_API.G_RET_STS_SUCCESS;
212:
213: -- Call private api.
214: AHL_PRD_WO_LOGIN_PVT.Workorder_Logout(
215: p_api_version => 1.0,

Line 216: p_init_msg_list => FND_API.G_FALSE,

212:
213: -- Call private api.
214: AHL_PRD_WO_LOGIN_PVT.Workorder_Logout(
215: p_api_version => 1.0,
216: p_init_msg_list => FND_API.G_FALSE,
217: p_commit => FND_API.G_FALSE,
218: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
219: p_module_type => NULL,
220: x_return_status => x_return_status,

Line 217: p_commit => FND_API.G_FALSE,

213: -- Call private api.
214: AHL_PRD_WO_LOGIN_PVT.Workorder_Logout(
215: p_api_version => 1.0,
216: p_init_msg_list => FND_API.G_FALSE,
217: p_commit => FND_API.G_FALSE,
218: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
219: p_module_type => NULL,
220: x_return_status => x_return_status,
221: x_msg_count => x_msg_count,

Line 218: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

214: AHL_PRD_WO_LOGIN_PVT.Workorder_Logout(
215: p_api_version => 1.0,
216: p_init_msg_list => FND_API.G_FALSE,
217: p_commit => FND_API.G_FALSE,
218: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
219: p_module_type => NULL,
220: x_return_status => x_return_status,
221: x_msg_count => x_msg_count,
222: x_msg_data => x_msg_data,

Line 233: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

229: p_resource_seq_num => p_resource_seq_num,
230: p_resource_id => p_resource_id);
231:
232: -- Raise errors if exceptions occur
233: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
234: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
235: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
236: RAISE FND_API.G_EXC_ERROR;
237: END IF;

Line 234: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

230: p_resource_id => p_resource_id);
231:
232: -- Raise errors if exceptions occur
233: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
234: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
235: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
236: RAISE FND_API.G_EXC_ERROR;
237: END IF;
238:

Line 235: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

231:
232: -- Raise errors if exceptions occur
233: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
234: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
235: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
236: RAISE FND_API.G_EXC_ERROR;
237: END IF;
238:
239: -- Standard check of p_commit

Line 236: RAISE FND_API.G_EXC_ERROR;

232: -- Raise errors if exceptions occur
233: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
234: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
235: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
236: RAISE FND_API.G_EXC_ERROR;
237: END IF;
238:
239: -- Standard check of p_commit
240: IF FND_API.TO_BOOLEAN(p_commit) THEN

Line 240: IF FND_API.TO_BOOLEAN(p_commit) THEN

236: RAISE FND_API.G_EXC_ERROR;
237: END IF;
238:
239: -- Standard check of p_commit
240: IF FND_API.TO_BOOLEAN(p_commit) THEN
241: COMMIT WORK;
242: END IF;
243:
244: -- Standard call to get message count and if count is 1, get message info

Line 248: p_encoded => fnd_api.g_false

244: -- Standard call to get message count and if count is 1, get message info
245: FND_MSG_PUB.Count_And_Get
246: ( p_count => x_msg_count,
247: p_data => x_msg_data,
248: p_encoded => fnd_api.g_false
249: );
250:
251: -- log debug message.
252: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL) THEN

Line 259: WHEN FND_API.G_EXC_ERROR THEN

255: END IF;
256:
257: --
258: EXCEPTION
259: WHEN FND_API.G_EXC_ERROR THEN
260: x_return_status := FND_API.G_RET_STS_ERROR;
261: Rollback to Workorder_Logout_Pub;
262: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
263: p_data => x_msg_data,

Line 260: x_return_status := FND_API.G_RET_STS_ERROR;

256:
257: --
258: EXCEPTION
259: WHEN FND_API.G_EXC_ERROR THEN
260: x_return_status := FND_API.G_RET_STS_ERROR;
261: Rollback to Workorder_Logout_Pub;
262: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
263: p_data => x_msg_data,
264: p_encoded => fnd_api.g_false);

Line 264: p_encoded => fnd_api.g_false);

260: x_return_status := FND_API.G_RET_STS_ERROR;
261: Rollback to Workorder_Logout_Pub;
262: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
263: p_data => x_msg_data,
264: p_encoded => fnd_api.g_false);
265:
266:
267: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 267: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

263: p_data => x_msg_data,
264: p_encoded => fnd_api.g_false);
265:
266:
267: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
269: Rollback to Workorder_Logout_Pub;
270: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
271: p_data => x_msg_data,

Line 268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

264: p_encoded => fnd_api.g_false);
265:
266:
267: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
269: Rollback to Workorder_Logout_Pub;
270: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
271: p_data => x_msg_data,
272: p_encoded => fnd_api.g_false);

Line 272: p_encoded => fnd_api.g_false);

268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
269: Rollback to Workorder_Logout_Pub;
270: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
271: p_data => x_msg_data,
272: p_encoded => fnd_api.g_false);
273:
274: WHEN OTHERS THEN
275:
276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

272: p_encoded => fnd_api.g_false);
273:
274: WHEN OTHERS THEN
275:
276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
277: Rollback to Workorder_Logout_Pub;
278: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
279: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
280: p_procedure_name => 'Workorder_Logout',

Line 285: p_encoded => fnd_api.g_false);

281: p_error_text => SUBSTR(SQLERRM,1,240));
282: END IF;
283: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
284: p_data => x_msg_data,
285: p_encoded => fnd_api.g_false);
286:
287:
288: END Workorder_Logout ;
289: