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

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

15:
16:
17: PROCEDURE Create_Responsibility
18: ( p_api_version_number IN NUMBER,
19: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
20: p_commit IN VARCHAR2 := FND_API.G_FALSE,
21: p_appl_id IN NUMBER,
22: p_menu_id IN NUMBER,
23: p_start_date IN DATE,

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

16:
17: PROCEDURE Create_Responsibility
18: ( p_api_version_number IN NUMBER,
19: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
20: p_commit IN VARCHAR2 := FND_API.G_FALSE,
21: p_appl_id IN NUMBER,
22: p_menu_id IN NUMBER,
23: p_start_date IN DATE,
24: p_end_date IN DATE,

Line 50: IF NOT FND_API.Compatible_API_Call(l_api_version_number,

46: -- Standard Start of API savepoint
47: SAVEPOINT CREATE_RESPONSIBILITY_PUB;
48:
49: -- Standard call to check for call compatibility.
50: IF NOT FND_API.Compatible_API_Call(l_api_version_number,
51: p_api_version_number,
52: l_api_name,
53: G_PKG_NAME)
54: THEN

Line 55: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

51: p_api_version_number,
52: l_api_name,
53: G_PKG_NAME)
54: THEN
55: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
56: END IF;
57:
58:
59: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 60: IF FND_API.to_Boolean( p_init_msg_list )

56: END IF;
57:
58:
59: -- Initialize message list if p_init_msg_list is set to TRUE.
60: IF FND_API.to_Boolean( p_init_msg_list )
61: THEN
62: FND_MSG_PUB.initialize;
63: END IF;
64:

Line 65: x_return_status := FND_API.G_RET_STS_SUCCESS;

61: THEN
62: FND_MSG_PUB.initialize;
63: END IF;
64:
65: x_return_status := FND_API.G_RET_STS_SUCCESS;
66:
67: --
68: -- API body
69: --

Line 72: p_menu_id = FND_API.G_MISS_NUM ) Then

68: -- API body
69: --
70:
71: If (p_menu_id is NULL or
72: p_menu_id = FND_API.G_MISS_NUM ) Then
73: FND_MESSAGE.Set_Name('JTS', 'JTS_MISSING_DATA');
74: FND_MESSAGE.Set_Token('COLUMN', 'Menu_Id');
75: FND_MSG_PUB.Add;
76: raise FND_API.G_EXC_ERROR;

Line 76: raise FND_API.G_EXC_ERROR;

72: p_menu_id = FND_API.G_MISS_NUM ) Then
73: FND_MESSAGE.Set_Name('JTS', 'JTS_MISSING_DATA');
74: FND_MESSAGE.Set_Token('COLUMN', 'Menu_Id');
75: FND_MSG_PUB.Add;
76: raise FND_API.G_EXC_ERROR;
77: End if;
78:
79: If (p_appl_id is NULL or
80: p_appl_id = FND_API.G_MISS_NUM ) Then

Line 80: p_appl_id = FND_API.G_MISS_NUM ) Then

76: raise FND_API.G_EXC_ERROR;
77: End if;
78:
79: If (p_appl_id is NULL or
80: p_appl_id = FND_API.G_MISS_NUM ) Then
81: FND_MESSAGE.Set_Name('JTS', 'JTS_MISSING_DATA');
82: FND_MESSAGE.Set_Token('COLUMN', 'Application_Id');
83: FND_MSG_PUB.Add;
84: raise FND_API.G_EXC_ERROR;

Line 84: raise FND_API.G_EXC_ERROR;

80: p_appl_id = FND_API.G_MISS_NUM ) Then
81: FND_MESSAGE.Set_Name('JTS', 'JTS_MISSING_DATA');
82: FND_MESSAGE.Set_Token('COLUMN', 'Application_Id');
83: FND_MSG_PUB.Add;
84: raise FND_API.G_EXC_ERROR;
85: End if;
86:
87: If (p_resp_key is NULL or
88: p_resp_key = FND_API.G_MISS_CHAR ) Then

Line 88: p_resp_key = FND_API.G_MISS_CHAR ) Then

84: raise FND_API.G_EXC_ERROR;
85: End if;
86:
87: If (p_resp_key is NULL or
88: p_resp_key = FND_API.G_MISS_CHAR ) Then
89: FND_MESSAGE.Set_Name('JTS', 'JTS_MISSING_DATA');
90: FND_MESSAGE.Set_Token('COLUMN', 'Responsibility_Key');
91: FND_MSG_PUB.Add;
92: raise FND_API.G_EXC_ERROR;

Line 92: raise FND_API.G_EXC_ERROR;

88: p_resp_key = FND_API.G_MISS_CHAR ) Then
89: FND_MESSAGE.Set_Name('JTS', 'JTS_MISSING_DATA');
90: FND_MESSAGE.Set_Token('COLUMN', 'Responsibility_Key');
91: FND_MSG_PUB.Add;
92: raise FND_API.G_EXC_ERROR;
93: End if;
94:
95: OPEN C_Dup_Key;
96: FETCH C_Dup_Key INTO l_found_dup;

Line 101: raise FND_API.G_EXC_ERROR;

97: CLOSE C_Dup_Key;
98: IF (l_found_dup = 'Y') THEN
99: FND_MESSAGE.Set_Name('JTS', 'JTS_DUPLICATE_RESP_KEY');
100: FND_MSG_PUB.Add;
101: raise FND_API.G_EXC_ERROR;
102: END IF;
103:
104: If (p_resp_name is NULL or
105: p_resp_name = FND_API.G_MISS_CHAR ) Then

Line 105: p_resp_name = FND_API.G_MISS_CHAR ) Then

101: raise FND_API.G_EXC_ERROR;
102: END IF;
103:
104: If (p_resp_name is NULL or
105: p_resp_name = FND_API.G_MISS_CHAR ) Then
106: FND_MESSAGE.Set_Name('JTS', 'JTS_MISSING_DATA');
107: FND_MESSAGE.Set_Token('COLUMN', 'Responsibility_Name');
108: FND_MSG_PUB.Add;
109: raise FND_API.G_EXC_ERROR;

Line 109: raise FND_API.G_EXC_ERROR;

105: p_resp_name = FND_API.G_MISS_CHAR ) Then
106: FND_MESSAGE.Set_Name('JTS', 'JTS_MISSING_DATA');
107: FND_MESSAGE.Set_Token('COLUMN', 'Responsibility_Name');
108: FND_MSG_PUB.Add;
109: raise FND_API.G_EXC_ERROR;
110: End if;
111:
112: If (p_start_date is NULL or
113: p_start_date = FND_API.G_MISS_Date ) Then

Line 113: p_start_date = FND_API.G_MISS_Date ) Then

109: raise FND_API.G_EXC_ERROR;
110: End if;
111:
112: If (p_start_date is NULL or
113: p_start_date = FND_API.G_MISS_Date ) Then
114: FND_MESSAGE.Set_Name('JTS', 'JTS_MISSING_DATA');
115: FND_MESSAGE.Set_Token('COLUMN', 'Start_Date');
116: FND_MSG_PUB.Add;
117: raise FND_API.G_EXC_ERROR;

Line 117: raise FND_API.G_EXC_ERROR;

113: p_start_date = FND_API.G_MISS_Date ) Then
114: FND_MESSAGE.Set_Name('JTS', 'JTS_MISSING_DATA');
115: FND_MESSAGE.Set_Token('COLUMN', 'Start_Date');
116: FND_MSG_PUB.Add;
117: raise FND_API.G_EXC_ERROR;
118: End if;
119:
120:
121: SELECT fnd_responsibility_s.nextval

Line 154: IF FND_API.to_Boolean( p_commit )

150: -- End of API body.
151: --
152:
153: -- Standard check for p_commit
154: IF FND_API.to_Boolean( p_commit )
155: THEN
156: COMMIT WORK;
157: END IF;
158:

Line 165: WHEN FND_API.G_EXC_ERROR THEN

161: p_data => x_msg_data
162: );
163:
164: EXCEPTION
165: WHEN FND_API.G_EXC_ERROR THEN
166: FND_MSG_PUB.Count_And_Get(
167: p_count => x_msg_count,
168: p_data => x_msg_data
169: );

Line 170: x_return_status := FND_API.G_RET_STS_ERROR;

166: FND_MSG_PUB.Count_And_Get(
167: p_count => x_msg_count,
168: p_data => x_msg_data
169: );
170: x_return_status := FND_API.G_RET_STS_ERROR;
171: WHEN OTHERS THEN
172: FND_MESSAGE.Set_Name('JTS', 'Error number ' || to_char(SQLCODE));
173: FND_MSG_PUB.Add;
174: FND_MSG_PUB.Count_And_Get(

Line 178: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

174: FND_MSG_PUB.Count_And_Get(
175: p_count => x_msg_count,
176: p_data => x_msg_data
177: );
178: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
179: END Create_Responsibility;
180:
181:
182: PROCEDURE Update_Responsibility

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

180:
181:
182: PROCEDURE Update_Responsibility
183: ( p_api_version_number IN NUMBER,
184: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
185: p_commit IN VARCHAR2 := FND_API.G_FALSE,
186: p_resp_id IN NUMBER,
187: p_appl_id IN NUMBER,
188: p_last_update_date IN DATE,

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

181:
182: PROCEDURE Update_Responsibility
183: ( p_api_version_number IN NUMBER,
184: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
185: p_commit IN VARCHAR2 := FND_API.G_FALSE,
186: p_resp_id IN NUMBER,
187: p_appl_id IN NUMBER,
188: p_last_update_date IN DATE,
189: p_menu_id IN NUMBER,

Line 216: IF NOT FND_API.Compatible_API_Call(l_api_version_number,

212: -- Standard Start of API savepoint
213: SAVEPOINT UPDATE_RESPONSIBILITY_PUB;
214:
215: -- Standard call to check for call compatibility.
216: IF NOT FND_API.Compatible_API_Call(l_api_version_number,
217: p_api_version_number,
218: l_api_name,
219: G_PKG_NAME)
220: THEN

Line 221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

217: p_api_version_number,
218: l_api_name,
219: G_PKG_NAME)
220: THEN
221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
222: END IF;
223:
224:
225: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 226: IF FND_API.to_Boolean( p_init_msg_list )

222: END IF;
223:
224:
225: -- Initialize message list if p_init_msg_list is set to TRUE.
226: IF FND_API.to_Boolean( p_init_msg_list )
227: THEN
228: FND_MSG_PUB.initialize;
229: END IF;
230:

Line 231: x_return_status := FND_API.G_RET_STS_SUCCESS;

227: THEN
228: FND_MSG_PUB.initialize;
229: END IF;
230:
231: x_return_status := FND_API.G_RET_STS_SUCCESS;
232:
233: --
234: -- API body
235: --

Line 243: raise FND_API.G_EXC_ERROR;

239: IF c_resp%NOTFOUND THEN
240: CLOSE c_resp;
241: FND_MESSAGE.Set_Name('JTS', 'JTS_NO_RESP_FOUND');
242: FND_MSG_PUB.Add;
243: raise FND_API.G_EXC_ERROR;
244: END IF;
245: CLOSE c_resp;
246:
247:

Line 249: p_last_update_date = FND_API.G_MISS_Date ) Then

245: CLOSE c_resp;
246:
247:
248: If (p_last_update_date is NULL or
249: p_last_update_date = FND_API.G_MISS_Date ) Then
250: FND_MESSAGE.Set_Name('JTS', 'JTS_MISSING_DATA');
251: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date');
252: FND_MSG_PUB.Add;
253: raise FND_API.G_EXC_ERROR;

Line 253: raise FND_API.G_EXC_ERROR;

249: p_last_update_date = FND_API.G_MISS_Date ) Then
250: FND_MESSAGE.Set_Name('JTS', 'JTS_MISSING_DATA');
251: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date');
252: FND_MSG_PUB.Add;
253: raise FND_API.G_EXC_ERROR;
254: End if;
255:
256: -- Check Whether record has been changed by someone else
257: If (p_last_update_date <> l_resp.last_update_date) Then

Line 260: raise FND_API.G_EXC_ERROR;

256: -- Check Whether record has been changed by someone else
257: If (p_last_update_date <> l_resp.last_update_date) Then
258: FND_MESSAGE.Set_Name('JTS', 'JTS_RECORD_CHANGED');
259: FND_MSG_PUB.ADD;
260: raise FND_API.G_EXC_ERROR;
261: End if;
262:
263:
264: If (p_menu_id is NULL or

Line 265: p_menu_id = FND_API.G_MISS_NUM ) Then

261: End if;
262:
263:
264: If (p_menu_id is NULL or
265: p_menu_id = FND_API.G_MISS_NUM ) Then
266: FND_MESSAGE.Set_Name('JTS', 'JTS_MISSING_DATA');
267: FND_MESSAGE.Set_Token('COLUMN', 'Menu_Id');
268: FND_MSG_PUB.Add;
269: raise FND_API.G_EXC_ERROR;

Line 269: raise FND_API.G_EXC_ERROR;

265: p_menu_id = FND_API.G_MISS_NUM ) Then
266: FND_MESSAGE.Set_Name('JTS', 'JTS_MISSING_DATA');
267: FND_MESSAGE.Set_Token('COLUMN', 'Menu_Id');
268: FND_MSG_PUB.Add;
269: raise FND_API.G_EXC_ERROR;
270: End if;
271:
272: If (p_resp_name is NULL or
273: p_resp_name = FND_API.G_MISS_CHAR ) Then

Line 273: p_resp_name = FND_API.G_MISS_CHAR ) Then

269: raise FND_API.G_EXC_ERROR;
270: End if;
271:
272: If (p_resp_name is NULL or
273: p_resp_name = FND_API.G_MISS_CHAR ) Then
274: FND_MESSAGE.Set_Name('JTS', 'JTS_MISSING_DATA');
275: FND_MESSAGE.Set_Token('COLUMN', 'Responsibility_Name');
276: FND_MSG_PUB.Add;
277: raise FND_API.G_EXC_ERROR;

Line 277: raise FND_API.G_EXC_ERROR;

273: p_resp_name = FND_API.G_MISS_CHAR ) Then
274: FND_MESSAGE.Set_Name('JTS', 'JTS_MISSING_DATA');
275: FND_MESSAGE.Set_Token('COLUMN', 'Responsibility_Name');
276: FND_MSG_PUB.Add;
277: raise FND_API.G_EXC_ERROR;
278: End if;
279:
280: If (p_start_date is NULL or
281: p_start_date = FND_API.G_MISS_Date ) Then

Line 281: p_start_date = FND_API.G_MISS_Date ) Then

277: raise FND_API.G_EXC_ERROR;
278: End if;
279:
280: If (p_start_date is NULL or
281: p_start_date = FND_API.G_MISS_Date ) Then
282: FND_MESSAGE.Set_Name('JTS', 'JTS_MISSING_DATA');
283: FND_MESSAGE.Set_Token('COLUMN', 'Start_Date');
284: FND_MSG_PUB.Add;
285: raise FND_API.G_EXC_ERROR;

Line 285: raise FND_API.G_EXC_ERROR;

281: p_start_date = FND_API.G_MISS_Date ) Then
282: FND_MESSAGE.Set_Name('JTS', 'JTS_MISSING_DATA');
283: FND_MESSAGE.Set_Token('COLUMN', 'Start_Date');
284: FND_MSG_PUB.Add;
285: raise FND_API.G_EXC_ERROR;
286: End if;
287:
288:
289: FND_RESPONSIBILITY_PKG.UPDATE_ROW(

Line 313: IF FND_API.to_Boolean( p_commit )

309: -- End of API body.
310: --
311:
312: -- Standard check for p_commit
313: IF FND_API.to_Boolean( p_commit )
314: THEN
315: COMMIT WORK;
316: END IF;
317:

Line 325: WHEN FND_API.G_EXC_ERROR THEN

321: );
322:
323:
324: EXCEPTION
325: WHEN FND_API.G_EXC_ERROR THEN
326: FND_MSG_PUB.Count_And_Get(
327: p_count => x_msg_count,
328: p_data => x_msg_data
329: );

Line 330: x_return_status := FND_API.G_RET_STS_ERROR;

326: FND_MSG_PUB.Count_And_Get(
327: p_count => x_msg_count,
328: p_data => x_msg_data
329: );
330: x_return_status := FND_API.G_RET_STS_ERROR;
331: WHEN OTHERS THEN
332: FND_MESSAGE.Set_Name('JTS', 'Error number ' || to_char(SQLCODE));
333: FND_MSG_PUB.Add;
334: FND_MSG_PUB.Count_And_Get(

Line 338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

334: FND_MSG_PUB.Count_And_Get(
335: p_count => x_msg_count,
336: p_data => x_msg_data
337: );
338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
339: END Update_Responsibility;
340:
341: PROCEDURE Create_Resp_Functions
342: ( p_api_version_number IN NUMBER,

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

339: END Update_Responsibility;
340:
341: PROCEDURE Create_Resp_Functions
342: ( p_api_version_number IN NUMBER,
343: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
344: p_commit IN VARCHAR2 := FND_API.G_FALSE,
345: p_app_id IN NUMBER,
346: p_resp_id IN NUMBER,
347: p_action_id IN NUMBER,

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

340:
341: PROCEDURE Create_Resp_Functions
342: ( p_api_version_number IN NUMBER,
343: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
344: p_commit IN VARCHAR2 := FND_API.G_FALSE,
345: p_app_id IN NUMBER,
346: p_resp_id IN NUMBER,
347: p_action_id IN NUMBER,
348: p_rule_type IN VARCHAR2,

Line 372: IF NOT FND_API.Compatible_API_Call(l_api_version_number,

368: -- Standard Start of API savepoint
369: SAVEPOINT CREATE_RESP_FUNCTIONS_PUB;
370:
371: -- Standard call to check for call compatibility.
372: IF NOT FND_API.Compatible_API_Call(l_api_version_number,
373: p_api_version_number,
374: l_api_name,
375: G_PKG_NAME)
376: THEN

Line 377: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

373: p_api_version_number,
374: l_api_name,
375: G_PKG_NAME)
376: THEN
377: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
378: END IF;
379:
380:
381: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 382: IF FND_API.to_Boolean( p_init_msg_list )

378: END IF;
379:
380:
381: -- Initialize message list if p_init_msg_list is set to TRUE.
382: IF FND_API.to_Boolean( p_init_msg_list )
383: THEN
384: FND_MSG_PUB.initialize;
385: END IF;
386:

Line 387: x_return_status := FND_API.G_RET_STS_SUCCESS;

383: THEN
384: FND_MSG_PUB.initialize;
385: END IF;
386:
387: x_return_status := FND_API.G_RET_STS_SUCCESS;
388:
389: --
390: -- API body
391: --

Line 394: p_action_id = FND_API.G_MISS_NUM ) Then

390: -- API body
391: --
392:
393: If (p_action_id is NULL or
394: p_action_id = FND_API.G_MISS_NUM ) Then
395: FND_MESSAGE.Set_Name('JTS', 'JTS_MISSING_DATA');
396: FND_MESSAGE.Set_Token('COLUMN', 'Action_Id');
397: FND_MSG_PUB.Add;
398: raise FND_API.G_EXC_ERROR;

Line 398: raise FND_API.G_EXC_ERROR;

394: p_action_id = FND_API.G_MISS_NUM ) Then
395: FND_MESSAGE.Set_Name('JTS', 'JTS_MISSING_DATA');
396: FND_MESSAGE.Set_Token('COLUMN', 'Action_Id');
397: FND_MSG_PUB.Add;
398: raise FND_API.G_EXC_ERROR;
399: End if;
400:
401: If (p_app_id is NULL or
402: p_app_id = FND_API.G_MISS_NUM ) Then

Line 402: p_app_id = FND_API.G_MISS_NUM ) Then

398: raise FND_API.G_EXC_ERROR;
399: End if;
400:
401: If (p_app_id is NULL or
402: p_app_id = FND_API.G_MISS_NUM ) Then
403: FND_MESSAGE.Set_Name('JTS', 'JTS_MISSING_DATA');
404: FND_MESSAGE.Set_Token('COLUMN', 'Application_Id');
405: FND_MSG_PUB.Add;
406: raise FND_API.G_EXC_ERROR;

Line 406: raise FND_API.G_EXC_ERROR;

402: p_app_id = FND_API.G_MISS_NUM ) Then
403: FND_MESSAGE.Set_Name('JTS', 'JTS_MISSING_DATA');
404: FND_MESSAGE.Set_Token('COLUMN', 'Application_Id');
405: FND_MSG_PUB.Add;
406: raise FND_API.G_EXC_ERROR;
407: End if;
408:
409: If (p_resp_id is NULL or
410: p_resp_id = FND_API.G_MISS_NUM ) Then

Line 410: p_resp_id = FND_API.G_MISS_NUM ) Then

406: raise FND_API.G_EXC_ERROR;
407: End if;
408:
409: If (p_resp_id is NULL or
410: p_resp_id = FND_API.G_MISS_NUM ) Then
411: FND_MESSAGE.Set_Name('JTS', 'JTS_MISSING_DATA');
412: FND_MESSAGE.Set_Token('COLUMN', 'Responsibility_Id');
413: FND_MSG_PUB.Add;
414: raise FND_API.G_EXC_ERROR;

Line 414: raise FND_API.G_EXC_ERROR;

410: p_resp_id = FND_API.G_MISS_NUM ) Then
411: FND_MESSAGE.Set_Name('JTS', 'JTS_MISSING_DATA');
412: FND_MESSAGE.Set_Token('COLUMN', 'Responsibility_Id');
413: FND_MSG_PUB.Add;
414: raise FND_API.G_EXC_ERROR;
415: End if;
416:
417: If (p_rule_type is NULL or
418: p_rule_type = FND_API.G_MISS_CHAR ) Then

Line 418: p_rule_type = FND_API.G_MISS_CHAR ) Then

414: raise FND_API.G_EXC_ERROR;
415: End if;
416:
417: If (p_rule_type is NULL or
418: p_rule_type = FND_API.G_MISS_CHAR ) Then
419: FND_MESSAGE.Set_Name('JTS', 'JTS_MISSING_DATA');
420: FND_MESSAGE.Set_Token('COLUMN', 'Rule_Type');
421: FND_MSG_PUB.Add;
422: raise FND_API.G_EXC_ERROR;

Line 422: raise FND_API.G_EXC_ERROR;

418: p_rule_type = FND_API.G_MISS_CHAR ) Then
419: FND_MESSAGE.Set_Name('JTS', 'JTS_MISSING_DATA');
420: FND_MESSAGE.Set_Token('COLUMN', 'Rule_Type');
421: FND_MSG_PUB.Add;
422: raise FND_API.G_EXC_ERROR;
423: End if;
424:
425: OPEN C_Dup_Key;
426: FETCH C_Dup_Key INTO l_found_dup;

Line 431: raise FND_API.G_EXC_ERROR;

427: CLOSE C_Dup_Key;
428: IF (l_found_dup = 'Y') THEN
429: FND_MESSAGE.Set_Name('JTS', 'JTS_DUPLICATE_APP_RESP_ACTUION_RULETYPE');
430: FND_MSG_PUB.Add;
431: raise FND_API.G_EXC_ERROR;
432: END IF;
433:
434: FND_RESP_FUNCTIONS_PKG.INSERT_ROW(
435: X_ROWID => x_rowid,

Line 451: IF FND_API.to_Boolean( p_commit )

447: -- End of API body.
448: --
449:
450: -- Standard check for p_commit
451: IF FND_API.to_Boolean( p_commit )
452: THEN
453: COMMIT WORK;
454: END IF;
455:

Line 462: WHEN FND_API.G_EXC_ERROR THEN

458: p_data => x_msg_data
459: );
460:
461: EXCEPTION
462: WHEN FND_API.G_EXC_ERROR THEN
463: FND_MSG_PUB.Count_And_Get(
464: p_count => x_msg_count,
465: p_data => x_msg_data
466: );

Line 467: x_return_status := FND_API.G_RET_STS_ERROR;

463: FND_MSG_PUB.Count_And_Get(
464: p_count => x_msg_count,
465: p_data => x_msg_data
466: );
467: x_return_status := FND_API.G_RET_STS_ERROR;
468: WHEN OTHERS THEN
469: FND_MESSAGE.Set_Name('JTS', 'Error number ' || to_char(SQLCODE));
470: FND_MSG_PUB.Add;
471: FND_MSG_PUB.Count_And_Get(

Line 475: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

471: FND_MSG_PUB.Count_And_Get(
472: p_count => x_msg_count,
473: p_data => x_msg_data
474: );
475: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
476: END Create_Resp_functions;
477:
478: PROCEDURE Delete_Resp_Functions
479: ( p_api_version_number IN NUMBER,

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

476: END Create_Resp_functions;
477:
478: PROCEDURE Delete_Resp_Functions
479: ( p_api_version_number IN NUMBER,
480: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
481: p_commit IN VARCHAR2 := FND_API.G_FALSE,
482: p_app_id IN NUMBER,
483: p_resp_id IN NUMBER,
484: p_rule_type IN VARCHAR2,

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

477:
478: PROCEDURE Delete_Resp_Functions
479: ( p_api_version_number IN NUMBER,
480: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
481: p_commit IN VARCHAR2 := FND_API.G_FALSE,
482: p_app_id IN NUMBER,
483: p_resp_id IN NUMBER,
484: p_rule_type IN VARCHAR2,
485: p_action_id IN NUMBER,

Line 507: IF NOT FND_API.Compatible_API_Call(l_api_version_number,

503: -- Standard Start of API savepoint
504: SAVEPOINT DELETE_RESP_FUNCTIONS_PUB;
505:
506: -- Standard call to check for call compatibility.
507: IF NOT FND_API.Compatible_API_Call(l_api_version_number,
508: p_api_version_number,
509: l_api_name,
510: G_PKG_NAME)
511: THEN

Line 512: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

508: p_api_version_number,
509: l_api_name,
510: G_PKG_NAME)
511: THEN
512: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
513: END IF;
514:
515:
516: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 517: IF FND_API.to_Boolean( p_init_msg_list )

513: END IF;
514:
515:
516: -- Initialize message list if p_init_msg_list is set to TRUE.
517: IF FND_API.to_Boolean( p_init_msg_list )
518: THEN
519: FND_MSG_PUB.initialize;
520: END IF;
521:

Line 522: x_return_status := FND_API.G_RET_STS_SUCCESS;

518: THEN
519: FND_MSG_PUB.initialize;
520: END IF;
521:
522: x_return_status := FND_API.G_RET_STS_SUCCESS;
523:
524: --
525: -- API body
526: --

Line 529: p_action_id = FND_API.G_MISS_NUM ) Then

525: -- API body
526: --
527:
528: If (p_action_id is NULL or
529: p_action_id = FND_API.G_MISS_NUM ) Then
530: FND_MESSAGE.Set_Name('JTS', 'JTS_MISSING_DATA');
531: FND_MESSAGE.Set_Token('COLUMN', 'Action_Id');
532: FND_MSG_PUB.Add;
533: raise FND_API.G_EXC_ERROR;

Line 533: raise FND_API.G_EXC_ERROR;

529: p_action_id = FND_API.G_MISS_NUM ) Then
530: FND_MESSAGE.Set_Name('JTS', 'JTS_MISSING_DATA');
531: FND_MESSAGE.Set_Token('COLUMN', 'Action_Id');
532: FND_MSG_PUB.Add;
533: raise FND_API.G_EXC_ERROR;
534: End if;
535:
536: If (p_app_id is NULL or
537: p_app_id = FND_API.G_MISS_NUM ) Then

Line 537: p_app_id = FND_API.G_MISS_NUM ) Then

533: raise FND_API.G_EXC_ERROR;
534: End if;
535:
536: If (p_app_id is NULL or
537: p_app_id = FND_API.G_MISS_NUM ) Then
538: FND_MESSAGE.Set_Name('JTS', 'JTS_MISSING_DATA');
539: FND_MESSAGE.Set_Token('COLUMN', 'Application_Id');
540: FND_MSG_PUB.Add;
541: raise FND_API.G_EXC_ERROR;

Line 541: raise FND_API.G_EXC_ERROR;

537: p_app_id = FND_API.G_MISS_NUM ) Then
538: FND_MESSAGE.Set_Name('JTS', 'JTS_MISSING_DATA');
539: FND_MESSAGE.Set_Token('COLUMN', 'Application_Id');
540: FND_MSG_PUB.Add;
541: raise FND_API.G_EXC_ERROR;
542: End if;
543:
544: If (p_resp_id is NULL or
545: p_resp_id = FND_API.G_MISS_NUM ) Then

Line 545: p_resp_id = FND_API.G_MISS_NUM ) Then

541: raise FND_API.G_EXC_ERROR;
542: End if;
543:
544: If (p_resp_id is NULL or
545: p_resp_id = FND_API.G_MISS_NUM ) Then
546: FND_MESSAGE.Set_Name('JTS', 'JTS_MISSING_DATA');
547: FND_MESSAGE.Set_Token('COLUMN', 'Responsibility_Id');
548: FND_MSG_PUB.Add;
549: raise FND_API.G_EXC_ERROR;

Line 549: raise FND_API.G_EXC_ERROR;

545: p_resp_id = FND_API.G_MISS_NUM ) Then
546: FND_MESSAGE.Set_Name('JTS', 'JTS_MISSING_DATA');
547: FND_MESSAGE.Set_Token('COLUMN', 'Responsibility_Id');
548: FND_MSG_PUB.Add;
549: raise FND_API.G_EXC_ERROR;
550: End if;
551:
552: If (p_rule_type is NULL or
553: p_rule_type = FND_API.G_MISS_CHAR ) Then

Line 553: p_rule_type = FND_API.G_MISS_CHAR ) Then

549: raise FND_API.G_EXC_ERROR;
550: End if;
551:
552: If (p_rule_type is NULL or
553: p_rule_type = FND_API.G_MISS_CHAR ) Then
554: FND_MESSAGE.Set_Name('JTS', 'JTS_MISSING_DATA');
555: FND_MESSAGE.Set_Token('COLUMN', 'Rule_Type');
556: FND_MSG_PUB.Add;
557: raise FND_API.G_EXC_ERROR;

Line 557: raise FND_API.G_EXC_ERROR;

553: p_rule_type = FND_API.G_MISS_CHAR ) Then
554: FND_MESSAGE.Set_Name('JTS', 'JTS_MISSING_DATA');
555: FND_MESSAGE.Set_Token('COLUMN', 'Rule_Type');
556: FND_MSG_PUB.Add;
557: raise FND_API.G_EXC_ERROR;
558: End if;
559:
560: OPEN C_Found;
561: FETCH C_Found INTO l_found;

Line 566: raise FND_API.G_EXC_ERROR;

562: CLOSE C_Found;
563: IF (l_found <> 'Y') THEN
564: FND_MESSAGE.Set_Name('JTS', 'JTS_NOTFOUND');
565: FND_MSG_PUB.Add;
566: raise FND_API.G_EXC_ERROR;
567: END IF;
568:
569: FND_RESP_FUNCTIONS_PKG.DELETE_ROW(
570: X_APPLICATION_ID => p_app_id,

Line 580: IF FND_API.to_Boolean( p_commit )

576: -- End of API body.
577: --
578:
579: -- Standard check for p_commit
580: IF FND_API.to_Boolean( p_commit )
581: THEN
582: COMMIT WORK;
583: END IF;
584:

Line 591: WHEN FND_API.G_EXC_ERROR THEN

587: p_data => x_msg_data
588: );
589:
590: EXCEPTION
591: WHEN FND_API.G_EXC_ERROR THEN
592: FND_MSG_PUB.Count_And_Get(
593: p_count => x_msg_count,
594: p_data => x_msg_data
595: );

Line 596: x_return_status := FND_API.G_RET_STS_ERROR;

592: FND_MSG_PUB.Count_And_Get(
593: p_count => x_msg_count,
594: p_data => x_msg_data
595: );
596: x_return_status := FND_API.G_RET_STS_ERROR;
597: WHEN OTHERS THEN
598: FND_MESSAGE.Set_Name('JTS', 'Error number ' || to_char(SQLCODE));
599: FND_MSG_PUB.Add;
600: FND_MSG_PUB.Count_And_Get(

Line 604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

600: FND_MSG_PUB.Count_And_Get(
601: p_count => x_msg_count,
602: p_data => x_msg_data
603: );
604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
605: END Delete_Resp_functions;
606:
607: END JTS_RESPONSIBILITY_PUB;