DBA Data[Home] [Help]

APPS.JTS_RESPONSIBILITY_PUB dependencies on FND_MESSAGE

Line 73: FND_MESSAGE.Set_Name('JTS', 'JTS_MISSING_DATA');

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;
77: End if;

Line 74: FND_MESSAGE.Set_Token('COLUMN', 'Menu_Id');

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;
77: End if;
78:

Line 81: FND_MESSAGE.Set_Name('JTS', 'JTS_MISSING_DATA');

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;
85: End if;

Line 82: FND_MESSAGE.Set_Token('COLUMN', 'Application_Id');

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;
85: End if;
86:

Line 89: FND_MESSAGE.Set_Name('JTS', 'JTS_MISSING_DATA');

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;
93: End if;

Line 90: FND_MESSAGE.Set_Token('COLUMN', 'Responsibility_Key');

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;
93: End if;
94:

Line 99: FND_MESSAGE.Set_Name('JTS', 'JTS_DUPLICATE_RESP_KEY');

95: OPEN C_Dup_Key;
96: FETCH C_Dup_Key INTO l_found_dup;
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:

Line 106: FND_MESSAGE.Set_Name('JTS', 'JTS_MISSING_DATA');

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;
110: End if;

Line 107: FND_MESSAGE.Set_Token('COLUMN', 'Responsibility_Name');

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;
110: End if;
111:

Line 114: FND_MESSAGE.Set_Name('JTS', 'JTS_MISSING_DATA');

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;
118: End if;

Line 115: FND_MESSAGE.Set_Token('COLUMN', 'Start_Date');

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;
118: End if;
119:

Line 172: FND_MESSAGE.Set_Name('JTS', 'Error number ' || to_char(SQLCODE));

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(
175: p_count => x_msg_count,
176: p_data => x_msg_data

Line 241: FND_MESSAGE.Set_Name('JTS', 'JTS_NO_RESP_FOUND');

237: OPEN c_resp;
238: FETCH c_resp INTO l_resp;
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;

Line 250: FND_MESSAGE.Set_Name('JTS', 'JTS_MISSING_DATA');

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;
254: End if;

Line 251: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date');

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;
254: End if;
255:

Line 258: FND_MESSAGE.Set_Name('JTS', 'JTS_RECORD_CHANGED');

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
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:

Line 266: FND_MESSAGE.Set_Name('JTS', 'JTS_MISSING_DATA');

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;
270: End if;

Line 267: FND_MESSAGE.Set_Token('COLUMN', 'Menu_Id');

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;
270: End if;
271:

Line 274: FND_MESSAGE.Set_Name('JTS', 'JTS_MISSING_DATA');

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;
278: End if;

Line 275: FND_MESSAGE.Set_Token('COLUMN', 'Responsibility_Name');

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;
278: End if;
279:

Line 282: FND_MESSAGE.Set_Name('JTS', 'JTS_MISSING_DATA');

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;
286: End if;

Line 283: FND_MESSAGE.Set_Token('COLUMN', 'Start_Date');

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;
286: End if;
287:

Line 332: FND_MESSAGE.Set_Name('JTS', 'Error number ' || to_char(SQLCODE));

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(
335: p_count => x_msg_count,
336: p_data => x_msg_data

Line 395: FND_MESSAGE.Set_Name('JTS', 'JTS_MISSING_DATA');

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;
399: End if;

Line 396: FND_MESSAGE.Set_Token('COLUMN', 'Action_Id');

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;
399: End if;
400:

Line 403: FND_MESSAGE.Set_Name('JTS', 'JTS_MISSING_DATA');

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;
407: End if;

Line 404: FND_MESSAGE.Set_Token('COLUMN', 'Application_Id');

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;
407: End if;
408:

Line 411: FND_MESSAGE.Set_Name('JTS', 'JTS_MISSING_DATA');

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;
415: End if;

Line 412: FND_MESSAGE.Set_Token('COLUMN', 'Responsibility_Id');

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;
415: End if;
416:

Line 419: FND_MESSAGE.Set_Name('JTS', 'JTS_MISSING_DATA');

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;
423: End if;

Line 420: FND_MESSAGE.Set_Token('COLUMN', 'Rule_Type');

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;
423: End if;
424:

Line 429: FND_MESSAGE.Set_Name('JTS', 'JTS_DUPLICATE_APP_RESP_ACTUION_RULETYPE');

425: OPEN C_Dup_Key;
426: FETCH C_Dup_Key INTO l_found_dup;
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:

Line 469: FND_MESSAGE.Set_Name('JTS', 'Error number ' || to_char(SQLCODE));

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(
472: p_count => x_msg_count,
473: p_data => x_msg_data

Line 530: FND_MESSAGE.Set_Name('JTS', 'JTS_MISSING_DATA');

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;
534: End if;

Line 531: FND_MESSAGE.Set_Token('COLUMN', 'Action_Id');

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;
534: End if;
535:

Line 538: FND_MESSAGE.Set_Name('JTS', 'JTS_MISSING_DATA');

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;
542: End if;

Line 539: FND_MESSAGE.Set_Token('COLUMN', 'Application_Id');

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;
542: End if;
543:

Line 546: FND_MESSAGE.Set_Name('JTS', 'JTS_MISSING_DATA');

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;
550: End if;

Line 547: FND_MESSAGE.Set_Token('COLUMN', 'Responsibility_Id');

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;
550: End if;
551:

Line 554: FND_MESSAGE.Set_Name('JTS', 'JTS_MISSING_DATA');

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;
558: End if;

Line 555: FND_MESSAGE.Set_Token('COLUMN', 'Rule_Type');

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;
558: End if;
559:

Line 564: FND_MESSAGE.Set_Name('JTS', 'JTS_NOTFOUND');

560: OPEN C_Found;
561: FETCH C_Found INTO l_found;
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:

Line 598: FND_MESSAGE.Set_Name('JTS', 'Error number ' || to_char(SQLCODE));

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(
601: p_count => x_msg_count,
602: p_data => x_msg_data