APPS.CSF_DEBRIEF_PVT dependencies on FND_MSG_PUB

Line 52: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

48: and p_labor_start_time <> FND_API.g_miss_date
49: and p_labor_end_time <> FND_API.g_miss_date
50: AND p_labor_start_time > p_labor_end_time) THEN
51: X_Return_Status := FND_API.G_RET_STS_ERROR;
52: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
53: FND_MESSAGE.Set_Name('CSF','CSF_LABOR_START_DATE_ERR');
54: FND_MSG_PUB.ADD;
55: END IF;
56: END IF;

Line 54: FND_MSG_PUB.ADD;

50: AND p_labor_start_time > p_labor_end_time) THEN
51: X_Return_Status := FND_API.G_RET_STS_ERROR;
52: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
53: FND_MESSAGE.Set_Name('CSF','CSF_LABOR_START_DATE_ERR');
54: FND_MSG_PUB.ADD;
55: END IF;
56: END IF;
57: If p_labor_start_time IS NOT NULL
58: and p_labor_start_time <> FND_API.g_miss_date

Line 66: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

62: > trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
63: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
64: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')))) THEN
65: X_Return_Status := FND_API.G_RET_STS_ERROR;
66: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
67: FND_MESSAGE.Set_Name('CSF','CSFW_SERVICE_DATE');
68: fnd_message.set_token('P_SR_DATE',to_char(fnd_timezones_pvt.adjust_datetime(l_service_request_date,
69: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
70: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID'))),'DD-Mon-RRRR HH24:MI'));

Line 74: FND_MSG_PUB.ADD;

70: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID'))),'DD-Mon-RRRR HH24:MI'));
71: fnd_message.set_token('P_SYSTEM_DATE',to_char(trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
72: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
73: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')))),'DD-Mon-RRRR')||' 23:59');
74: FND_MSG_PUB.ADD;
75: END IF;
76: END IF;
77: If p_labor_end_time IS NOT NULL
78: and p_labor_end_time <> FND_API.g_miss_date

Line 86: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

82: > trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
83: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
84: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')))) THEN
85: X_Return_Status := FND_API.G_RET_STS_ERROR;
86: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
87: FND_MESSAGE.Set_Name('CSF','CSFW_SERVICE_DATE_END');
88: fnd_message.set_token('P_SR_DATE',to_char(fnd_timezones_pvt.adjust_datetime(l_service_request_date,
89: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
90: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID'))),'DD-Mon-RRRR HH24:MI'));

Line 94: FND_MSG_PUB.ADD;

90: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID'))),'DD-Mon-RRRR HH24:MI'));
91: fnd_message.set_token('P_SYSTEM_DATE',to_char(trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
92: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
93: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')))),'DD-Mon-RRRR')||' 23:59');
94: FND_MSG_PUB.ADD;
95: END IF;
96: END IF;
97:
98: If (p_labor_start_time IS NOT NULL

Line 102: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

98: If (p_labor_start_time IS NOT NULL
99: and p_labor_start_time <> FND_API.g_miss_date
100: and p_labor_start_time < l_service_request_date) THEN
101: X_Return_Status := FND_API.G_RET_STS_ERROR;
102: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
103: FND_MESSAGE.Set_Name('CSF','CSFW_SERVICE_DATE');
104: fnd_message.set_token('P_SR_DATE',to_char(fnd_timezones_pvt.adjust_datetime(l_service_request_date,
105: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
106: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID'))),'DD-Mon-RRRR HH24:MI'));

Line 110: FND_MSG_PUB.ADD;

106: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID'))),'DD-Mon-RRRR HH24:MI'));
107: fnd_message.set_token('P_SYSTEM_DATE',to_char(trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
108: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
109: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')))),'DD-Mon-RRRR')||' 23:59');
110: FND_MSG_PUB.ADD;
111: END IF;
112: END IF;
113: If (p_labor_end_time IS NOT NULL
114: and p_labor_end_time <> FND_API.g_miss_date

Line 117: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

113: If (p_labor_end_time IS NOT NULL
114: and p_labor_end_time <> FND_API.g_miss_date
115: and p_labor_end_time < l_service_request_date) THEN
116: X_Return_Status := FND_API.G_RET_STS_ERROR;
117: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
118: FND_MESSAGE.Set_Name('CSF','CSFW_SERVICE_DATE_END');
119: fnd_message.set_token('P_SR_DATE',to_char(fnd_timezones_pvt.adjust_datetime(l_service_request_date,
120: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
121: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID'))),'DD-Mon-RRRR HH24:MI'));

Line 125: FND_MSG_PUB.ADD;

121: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID'))),'DD-Mon-RRRR HH24:MI'));
122: fnd_message.set_token('P_SYSTEM_DATE',to_char(trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
123: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
124: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')))),'DD-Mon-RRRR')||' 23:59');
125: FND_MSG_PUB.ADD;
126: END IF;
127: END IF;
128: END;
129:

Line 209: FND_MSG_PUB.initialize;

205:
206: -- Initialize message list if p_init_msg_list is set to TRUE.
207: IF FND_API.to_Boolean( p_init_msg_list )
208: THEN
209: FND_MSG_PUB.initialize;
210: END IF;
211:
212:
213: -- Debug Message

Line 214: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

210: END IF;
211:
212:
213: -- Debug Message
214: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
215: THEN
216: FND_MESSAGE.Set_Name('CSF', l_api_name);
217: FND_MESSAGE.Set_Token ('INFO', G_PKG_NAME, FALSE);
218: FND_MSG_PUB.Add;

Line 218: FND_MSG_PUB.Add;

214: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
215: THEN
216: FND_MESSAGE.Set_Name('CSF', l_api_name);
217: FND_MESSAGE.Set_Token ('INFO', G_PKG_NAME, FALSE);
218: FND_MSG_PUB.Add;
219:
220: END IF;
221:
222: -- Initialize API return status to SUCCESS

Line 235: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

231:
232: -- Virendra Singh 03/24/2000 check whether Header record is missing
233: if IS_DEBRIEF_HEADER_REC_MISSING(P_DEBRIEF_REC) then
234:
235: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
236: THEN
237: fnd_message.set_name('CSF', 'CSF_DEBRIEF_MISSING_HEADER');
238: fnd_msg_pub.add;
239: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 238: fnd_msg_pub.add;

234:
235: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
236: THEN
237: fnd_message.set_name('CSF', 'CSF_DEBRIEF_MISSING_HEADER');
238: fnd_msg_pub.add;
239: x_return_status := fnd_api.g_ret_sts_unexp_error;
240: RAISE fnd_api.g_exc_unexpected_error;
241: END IF;
242: end if;

Line 272: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

268: RAISE fnd_api.g_exc_unexpected_error;
269: END IF;
270: END IF;
271: -- Debug Message
272: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
273: THEN
274: FND_MESSAGE.Set_Name('CSF', l_api_name);
275: FND_MESSAGE.Set_Token ('INFO', G_PKG_NAME, FALSE);
276: FND_MSG_PUB.Add;

Line 276: FND_MSG_PUB.Add;

272: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
273: THEN
274: FND_MESSAGE.Set_Name('CSF', l_api_name);
275: FND_MESSAGE.Set_Token ('INFO', G_PKG_NAME, FALSE);
276: FND_MSG_PUB.Add;
277: END IF;
278:
279: -- Invoke table handler(debrief_Insert_Row)
280:

Line 292: fnd_msg_pub.add;

288: from CSF_DEBRIEF_HEADERS
289: where DEBRIEF_HEADER_ID = l_DEBRIEF_HEADER_ID ;
290:
291: fnd_message.set_name('CSF', 'CSF_DEBRIEF_INVALID_HEADER');
292: fnd_msg_pub.add;
293: x_return_status := fnd_api.g_ret_sts_unexp_error;
294: RAISE fnd_api.g_exc_unexpected_error;
295: exception
296: when no_data_found then

Line 300: fnd_msg_pub.add;

296: when no_data_found then
297: null ;
298: when too_many_rows then
299: fnd_message.set_name('CSF', 'CSF_DEBRIEF_INVALID_HEADER');
300: fnd_msg_pub.add;
301: x_return_status := fnd_api.g_ret_sts_unexp_error;
302: RAISE fnd_api.g_exc_unexpected_error;
303: end ;
304:

Line 453: FND_MSG_PUB.Count_And_Get

449: END IF;
450:
451:
452: -- Standard call to get message count and if count is 1, get message info.
453: FND_MSG_PUB.Count_And_Get
454: ( p_count => x_msg_count,
455: p_data => x_msg_data
456: );
457:

Line 463: FND_MSG_PUB.Count_And_Get (

459: EXCEPTION
460: WHEN FND_API.G_EXC_ERROR THEN
461: ROLLBACK TO CREATE_DEBRIEF_HEADER_PVT;
462: 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: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 471: FND_MSG_PUB.Count_And_Get (

467: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
468: ROLLBACK TO CREATE_DEBRIEF_HEADER_PVT;
469:
470: 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: WHEN OTHERS THEN

Line 478: IF FND_MSG_PUB.Check_Msg_Level

474:
475: WHEN OTHERS THEN
476: ROLLBACK TO CREATE_DEBRIEF_HEADER_PVT;
477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
478: IF FND_MSG_PUB.Check_Msg_Level
479: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
480: THEN
481: FND_MSG_PUB.Add_Exc_Msg (
482: G_PKG_NAME

Line 479: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

475: WHEN OTHERS THEN
476: ROLLBACK TO CREATE_DEBRIEF_HEADER_PVT;
477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
478: IF FND_MSG_PUB.Check_Msg_Level
479: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
480: THEN
481: FND_MSG_PUB.Add_Exc_Msg (
482: G_PKG_NAME
483: ,L_API_NAME );

Line 481: FND_MSG_PUB.Add_Exc_Msg (

477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
478: IF FND_MSG_PUB.Check_Msg_Level
479: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
480: THEN
481: FND_MSG_PUB.Add_Exc_Msg (
482: G_PKG_NAME
483: ,L_API_NAME );
484: END IF;
485:

Line 486: FND_MSG_PUB.Count_And_Get (

482: G_PKG_NAME
483: ,L_API_NAME );
484: END IF;
485:
486: FND_MSG_PUB.Count_And_Get (
487: P_COUNT => X_MSG_COUNT
488: ,P_DATA => X_MSG_DATA);
489:
490: End Create_debrief;

Line 557: FND_MSG_PUB.initialize;

553:
554: -- Initialize message list if p_init_msg_list is set to TRUE.
555: IF FND_API.to_Boolean( p_init_msg_list )
556: THEN
557: FND_MSG_PUB.initialize;
558: END IF;
559:
560: -- Initialize API return status to SUCCESS
561: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 566: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

562:
563: l_debrief_header_id:=l_tar_DEBRIEF_rec.Debrief_header_id;
564: -- Virendra Singh 03/27/2000 check whether Debrief_Header_ID is not null or missging
565: if (l_debrief_header_id =FND_API.G_MISS_NUM) or (l_debrief_header_id is NULL ) then
566: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
567: THEN
568: fnd_message.set_name('CSF', 'CSF_DEBRIEF_MISSING_HEADER');
569: fnd_msg_pub.add;
570: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 569: fnd_msg_pub.add;

565: if (l_debrief_header_id =FND_API.G_MISS_NUM) or (l_debrief_header_id is NULL ) then
566: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
567: THEN
568: fnd_message.set_name('CSF', 'CSF_DEBRIEF_MISSING_HEADER');
569: fnd_msg_pub.add;
570: x_return_status := fnd_api.g_ret_sts_unexp_error;
571: RAISE fnd_api.g_exc_unexpected_error;
572: END IF;
573: end if;

Line 701: FND_MSG_PUB.Count_And_Get

697: COMMIT WORK;
698: END IF;
699:
700: -- Standard call to get message count and if count is 1, get message info.
701: FND_MSG_PUB.Count_And_Get
702: ( p_count => x_msg_count,
703: p_data => x_msg_data
704: );
705:

Line 710: FND_MSG_PUB.Count_And_Get (

706: EXCEPTION
707: WHEN FND_API.G_EXC_ERROR THEN
708: ROLLBACK TO UPDATE_DEBRIEF_PVT;
709: x_return_status := FND_API.G_RET_STS_ERROR;
710: FND_MSG_PUB.Count_And_Get (
711: P_COUNT => X_MSG_COUNT
712: ,P_DATA => X_MSG_DATA);
713:
714: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 717: FND_MSG_PUB.Count_And_Get (

713:
714: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
715: ROLLBACK TO UPDATE_DEBRIEF_PVT;
716: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
717: FND_MSG_PUB.Count_And_Get (
718: P_COUNT => X_MSG_COUNT
719: ,P_DATA => X_MSG_DATA);
720:
721: WHEN OTHERS THEN

Line 724: IF FND_MSG_PUB.Check_Msg_Level

720:
721: WHEN OTHERS THEN
722: ROLLBACK TO UPDATE_DEBRIEF_PVT;
723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
724: IF FND_MSG_PUB.Check_Msg_Level
725: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
726: THEN
727: FND_MSG_PUB.Add_Exc_Msg (
728: G_PKG_NAME

Line 725: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

721: WHEN OTHERS THEN
722: ROLLBACK TO UPDATE_DEBRIEF_PVT;
723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
724: IF FND_MSG_PUB.Check_Msg_Level
725: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
726: THEN
727: FND_MSG_PUB.Add_Exc_Msg (
728: G_PKG_NAME
729: ,L_API_NAME );

Line 727: FND_MSG_PUB.Add_Exc_Msg (

723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
724: IF FND_MSG_PUB.Check_Msg_Level
725: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
726: THEN
727: FND_MSG_PUB.Add_Exc_Msg (
728: G_PKG_NAME
729: ,L_API_NAME );
730: END IF;
731:

Line 732: FND_MSG_PUB.Count_And_Get (

728: G_PKG_NAME
729: ,L_API_NAME );
730: END IF;
731:
732: FND_MSG_PUB.Count_And_Get (
733: P_COUNT => X_MSG_COUNT
734: ,P_DATA => X_MSG_DATA);
735:
736: End Update_debrief;

Line 763: FND_MSG_PUB.initialize;

759: BEGIN
760: -- Initialize message list if p_init_msg_list is set to TRUE.
761: IF FND_API.to_Boolean( p_init_msg_list )
762: THEN
763: FND_MSG_PUB.initialize;
764: END IF;
765: -- Initialize API return status to SUCCESS
766: x_return_status := FND_API.G_RET_STS_SUCCESS;
767:

Line 770: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

766: x_return_status := FND_API.G_RET_STS_SUCCESS;
767:
768: IF (p_task_assignment_id is NULL OR p_task_assignment_id = FND_API.G_MISS_NUM) THEN
769: x_return_status := FND_API.G_RET_STS_ERROR;
770: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
771: THEN
772: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_INVALID_TA_ID');
773: FND_MSG_PUB.ADD;
774: END IF;

Line 773: FND_MSG_PUB.ADD;

769: x_return_status := FND_API.G_RET_STS_ERROR;
770: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
771: THEN
772: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_INVALID_TA_ID');
773: FND_MSG_PUB.ADD;
774: END IF;
775: ELSE
776: open c;
777: fetch c into l_dummy;

Line 781: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

777: fetch c into l_dummy;
778: if c%notfound then
779: close c;
780: x_return_status := FND_API.G_RET_STS_ERROR;
781: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
782: THEN
783: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_INVALID_TA_ID');
784: FND_MSG_PUB.ADD;
785: END IF;

Line 784: FND_MSG_PUB.ADD;

780: x_return_status := FND_API.G_RET_STS_ERROR;
781: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
782: THEN
783: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_INVALID_TA_ID');
784: FND_MSG_PUB.ADD;
785: END IF;
786: else
787: close c;
788: end if;

Line 792: FND_MSG_PUB.Count_And_Get

788: end if;
789: END IF;
790:
791: -- Standard call to get message count and if count is 1, get message info.
792: FND_MSG_PUB.Count_And_Get
793: ( p_count => x_msg_count,
794: p_data => x_msg_data
795: );
796:

Line 814: FND_MSG_PUB.initialize;

810: BEGIN
811: -- Initialize message list if p_init_msg_list is set to TRUE.
812: IF FND_API.to_Boolean( p_init_msg_list )
813: THEN
814: FND_MSG_PUB.initialize;
815: END IF;
816:
817: -- Initialize API return status to SUCCESS
818: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 821: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

817: -- Initialize API return status to SUCCESS
818: x_return_status := FND_API.G_RET_STS_SUCCESS;
819: IF (p_debrief_date is NULL OR p_debrief_date = FND_API.G_MISS_DATE) THEN
820: x_return_status := FND_API.G_RET_STS_ERROR;
821: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
822: THEN
823: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_DEBRIEF_DATE');
824: FND_MSG_PUB.ADD;
825: END IF;

Line 824: FND_MSG_PUB.ADD;

820: x_return_status := FND_API.G_RET_STS_ERROR;
821: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
822: THEN
823: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_DEBRIEF_DATE');
824: FND_MSG_PUB.ADD;
825: END IF;
826: END IF;
827:
828: -- Standard call to get message count and if count is 1, get message info.

Line 829: FND_MSG_PUB.Count_And_Get

825: END IF;
826: END IF;
827:
828: -- Standard call to get message count and if count is 1, get message info.
829: FND_MSG_PUB.Count_And_Get
830: ( p_count => x_msg_count,
831: p_data => x_msg_data
832: );
833: END Validate_Debrief_Date;

Line 1069: FND_MSG_PUB.initialize;

1065: -- Initialize message list if p_init_msg_list is set to TRUE.
1066:
1067: IF FND_API.to_Boolean( p_init_msg_list )
1068: THEN
1069: FND_MSG_PUB.initialize;
1070: END IF;
1071:
1072: -- Initialize API return status to SUCCESS
1073: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1354: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1350: fnd_api.g_miss_num and l_debrief_type = 'L' then
1351: if nvl(p_debrief_line_rec.labor_start_date,fnd_api.g_miss_date) = fnd_api.g_miss_date and
1352: nvl(p_debrief_line_rec.labor_end_date,fnd_api.g_miss_date) = fnd_api.g_miss_date then
1353: x_return_status := FND_API.G_RET_STS_ERROR;
1354: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1355: FND_MESSAGE.Set_Name('CSF', 'CSF_DEBRIEF_LABOR_DATES_ITEM');
1356: FND_MSG_PUB.ADD;
1357: END IF;
1358: RAISE fnd_api.g_exc_error;

Line 1356: FND_MSG_PUB.ADD;

1352: nvl(p_debrief_line_rec.labor_end_date,fnd_api.g_miss_date) = fnd_api.g_miss_date then
1353: x_return_status := FND_API.G_RET_STS_ERROR;
1354: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1355: FND_MESSAGE.Set_Name('CSF', 'CSF_DEBRIEF_LABOR_DATES_ITEM');
1356: FND_MSG_PUB.ADD;
1357: END IF;
1358: RAISE fnd_api.g_exc_error;
1359: end if;
1360: else

Line 1428: fnd_msg_pub.add;

1424: from CSF_DEBRIEF_LINES
1425: where DEBRIEF_LINE_ID = l_DEBRIEF_LINE_ID ;
1426:
1427: fnd_message.set_name('CSF', 'CSF_DEBRIEF_INVALID_LINE_ID');
1428: fnd_msg_pub.add;
1429: x_return_status := fnd_api.g_ret_sts_unexp_error;
1430: RAISE fnd_api.g_exc_unexpected_error;
1431: exception
1432: when no_data_found then

Line 1436: fnd_msg_pub.add;

1432: when no_data_found then
1433: null ;
1434: when too_many_rows then
1435: fnd_message.set_name('CSF', 'CSF_DEBRIEF_INVALID_LINE_ID');
1436: fnd_msg_pub.add;
1437: x_return_status := fnd_api.g_ret_sts_unexp_error;
1438: RAISE fnd_api.g_exc_unexpected_error;
1439: end ;
1440: ELSE

Line 1550: FND_MSG_PUB.ADD;

1546: x_task_number => l_task_number
1547: );
1548: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1549: FND_MESSAGE.Set_Name('CSF', 'CSF_OVERLAP_LABOR_LINE');
1550: FND_MSG_PUB.ADD;
1551: RAISE fnd_api.g_exc_error;
1552: END IF;
1553: END IF;
1554: --Update actual times for task and task assignment

Line 1665: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1661: END IF;
1662:
1663: EXCEPTION
1664: WHEN OTHERS THEN
1665: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1666: FND_MESSAGE.Set_Name('CSF', 'CSF_DEBRIEF_UPDATE_TASK_ASSIGNMENT');
1667: FND_MSG_PUB.ADD;
1668: END IF;
1669: RAISE FND_API.G_EXC_ERROR;

Line 1667: FND_MSG_PUB.ADD;

1663: EXCEPTION
1664: WHEN OTHERS THEN
1665: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1666: FND_MESSAGE.Set_Name('CSF', 'CSF_DEBRIEF_UPDATE_TASK_ASSIGNMENT');
1667: FND_MSG_PUB.ADD;
1668: END IF;
1669: RAISE FND_API.G_EXC_ERROR;
1670: END;
1671: end if;

Line 1700: FND_MSG_PUB.Count_And_Get

1696:
1697: END IF;
1698:
1699: -- Standard call to get message count and if count is 1, get message info.
1700: FND_MSG_PUB.Count_And_Get
1701: ( p_count => x_msg_count,
1702: p_data => x_msg_data
1703: );
1704:

Line 1709: FND_MSG_PUB.Count_And_Get (

1705: EXCEPTION
1706: WHEN FND_API.G_EXC_ERROR THEN
1707: ROLLBACK TO CREATE_DEBRIEF_LINE_PVT;
1708: x_return_status := FND_API.G_RET_STS_ERROR;
1709: FND_MSG_PUB.Count_And_Get (
1710: P_COUNT => X_MSG_COUNT
1711: ,P_DATA => X_MSG_DATA);
1712:
1713: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1716: FND_MSG_PUB.Count_And_Get (

1712:
1713: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1714: ROLLBACK TO CREATE_DEBRIEF_LINE_PVT;
1715: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1716: FND_MSG_PUB.Count_And_Get (
1717: P_COUNT => X_MSG_COUNT
1718: ,P_DATA => X_MSG_DATA);
1719: WHEN OTHERS THEN
1720: ROLLBACK TO CREATE_DEBRIEF_LINE_PVT;

Line 1722: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1718: ,P_DATA => X_MSG_DATA);
1719: WHEN OTHERS THEN
1720: ROLLBACK TO CREATE_DEBRIEF_LINE_PVT;
1721: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1722: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1723: THEN
1724: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME ,L_API_NAME );
1725: END IF;
1726:

Line 1724: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME ,L_API_NAME );

1720: ROLLBACK TO CREATE_DEBRIEF_LINE_PVT;
1721: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1722: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1723: THEN
1724: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME ,L_API_NAME );
1725: END IF;
1726:
1727: FND_MSG_PUB.Count_And_Get (
1728: P_COUNT => X_MSG_COUNT

Line 1727: FND_MSG_PUB.Count_And_Get (

1723: THEN
1724: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME ,L_API_NAME );
1725: END IF;
1726:
1727: FND_MSG_PUB.Count_And_Get (
1728: P_COUNT => X_MSG_COUNT
1729: ,P_DATA => X_MSG_DATA);
1730: End Create_debrief_lines;
1731:

Line 1755: FND_MSG_PUB.initialize;

1751: BEGIN
1752: -- Initialize message list if p_init_msg_list is set to TRUE.
1753: IF FND_API.to_Boolean( p_init_msg_list )
1754: THEN
1755: FND_MSG_PUB.initialize;
1756: END IF;
1757:
1758: -- Initialize API return status to SUCCESS
1759: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1762: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1758: -- Initialize API return status to SUCCESS
1759: x_return_status := FND_API.G_RET_STS_SUCCESS;
1760: IF (P_Task_Assignment_status is NULL OR P_Task_Assignment_status = FND_API.G_MISS_CHAR) THEN
1761: x_return_status := FND_API.G_RET_STS_ERROR;
1762: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1763: FND_MESSAGE.Set_Name('CSF', 'CSF_DEBRIEF_TA_STATUS');
1764: FND_MSG_PUB.ADD;
1765: END IF;
1766: ELSE

Line 1764: FND_MSG_PUB.ADD;

1760: IF (P_Task_Assignment_status is NULL OR P_Task_Assignment_status = FND_API.G_MISS_CHAR) THEN
1761: x_return_status := FND_API.G_RET_STS_ERROR;
1762: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1763: FND_MESSAGE.Set_Name('CSF', 'CSF_DEBRIEF_TA_STATUS');
1764: FND_MSG_PUB.ADD;
1765: END IF;
1766: ELSE
1767: open validate_ta_status;
1768: fetch validate_ta_status into X_TA_STATUS_ID;

Line 1772: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1768: fetch validate_ta_status into X_TA_STATUS_ID;
1769: if validate_ta_status%notfound then
1770: close validate_ta_status ;
1771: x_return_status := FND_API.G_RET_STS_ERROR;
1772: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1773: FND_MESSAGE.Set_Name('CSF', 'CSF_DEBRIEF_TAvalvav_STATUS');
1774: FND_MSG_PUB.ADD;
1775: END IF;
1776: end if;

Line 1774: FND_MSG_PUB.ADD;

1770: close validate_ta_status ;
1771: x_return_status := FND_API.G_RET_STS_ERROR;
1772: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1773: FND_MESSAGE.Set_Name('CSF', 'CSF_DEBRIEF_TAvalvav_STATUS');
1774: FND_MSG_PUB.ADD;
1775: END IF;
1776: end if;
1777: close validate_ta_status ;
1778: END IF;

Line 1781: FND_MSG_PUB.Count_And_Get

1777: close validate_ta_status ;
1778: END IF;
1779:
1780: -- Standard call to get message count and if count is 1, get message info.
1781: FND_MSG_PUB.Count_And_Get
1782: ( p_count => x_msg_count,
1783: p_data => x_msg_data
1784: );
1785: END Validate_Task_Assignment_Satus;

Line 1919: FND_MSG_PUB.initialize;

1915: END IF;
1916:
1917: IF FND_API.to_Boolean( p_init_msg_list )
1918: THEN
1919: FND_MSG_PUB.initialize;
1920: END IF;
1921:
1922: -- Initialize API return status to SUCCESS
1923: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1933: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

1929: open GET_CHARGE_UPLOAD_STATUS(l_DEBRIEF_LINE_ID);
1930: fetch GET_CHARGE_UPLOAD_STATUS into l_charge_upload_status, l_ib_upload_status, l_spare_upload_status, l_labor_start_date;
1931: if GET_CHARGE_UPLOAD_STATUS%notfound then
1932: close GET_CHARGE_UPLOAD_STATUS;
1933: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1934: THEN
1935: FND_MESSAGE.Set_Name('CSF', 'CSF_DEBRIEF_INVALID_LINE_ID');
1936: FND_MSG_PUB.Add;
1937:

Line 1936: FND_MSG_PUB.Add;

1932: close GET_CHARGE_UPLOAD_STATUS;
1933: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1934: THEN
1935: FND_MESSAGE.Set_Name('CSF', 'CSF_DEBRIEF_INVALID_LINE_ID');
1936: FND_MSG_PUB.Add;
1937:
1938: END IF;
1939: raise FND_API.G_EXC_ERROR;
1940: end if;

Line 1955: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

1951: end if;
1952: IF l_charge_upload_status='SUCCEEDED' or
1953: l_ib_upload_status ='SUCCEEDED' or
1954: l_spare_upload_status ='SUCCEEDED' then
1955: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1956: THEN
1957: FND_MESSAGE.Set_Name('CSF', 'CSF_DEBRIEF_CHARGE_UPLOADED');
1958: FND_MSG_PUB.Add;
1959: x_return_status := 'E';

Line 1958: FND_MSG_PUB.Add;

1954: l_spare_upload_status ='SUCCEEDED' then
1955: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1956: THEN
1957: FND_MESSAGE.Set_Name('CSF', 'CSF_DEBRIEF_CHARGE_UPLOADED');
1958: FND_MSG_PUB.Add;
1959: x_return_status := 'E';
1960: END IF;
1961: ELSE
1962: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

Line 1980: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1976: IF nvl(P_DEBRIEF_LINE_REC.Inventory_Item_ID,fnd_api.g_miss_num)= FND_API.G_MISS_NUM and l_debrief_type = 'L' then
1977: if nvl(p_debrief_line_rec.labor_start_date,fnd_api.g_miss_date) = fnd_api.g_miss_date and
1978: nvl(p_debrief_line_rec.labor_end_date,fnd_api.g_miss_date) = fnd_api.g_miss_date then
1979: x_return_status := FND_API.G_RET_STS_ERROR;
1980: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1981: FND_MESSAGE.Set_Name('CSF', 'CSF_DEBRIEF_LABOR_DATES_ITEM');
1982: FND_MSG_PUB.ADD;
1983: END IF;
1984: RAISE fnd_api.g_exc_error;

Line 1982: FND_MSG_PUB.ADD;

1978: nvl(p_debrief_line_rec.labor_end_date,fnd_api.g_miss_date) = fnd_api.g_miss_date then
1979: x_return_status := FND_API.G_RET_STS_ERROR;
1980: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1981: FND_MESSAGE.Set_Name('CSF', 'CSF_DEBRIEF_LABOR_DATES_ITEM');
1982: FND_MSG_PUB.ADD;
1983: END IF;
1984: RAISE fnd_api.g_exc_error;
1985: end if;
1986: else

Line 2315: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2311: END IF;
2312:
2313: EXCEPTION
2314: WHEN OTHERS THEN
2315: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2316: FND_MESSAGE.Set_Name('CSF', 'CSF_DEBRIEF_UPDATE_TASK_ASSIGNMENT');
2317: FND_MSG_PUB.ADD;
2318: END IF;
2319: RAISE FND_API.G_EXC_ERROR;

Line 2317: FND_MSG_PUB.ADD;

2313: EXCEPTION
2314: WHEN OTHERS THEN
2315: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2316: FND_MESSAGE.Set_Name('CSF', 'CSF_DEBRIEF_UPDATE_TASK_ASSIGNMENT');
2317: FND_MSG_PUB.ADD;
2318: END IF;
2319: RAISE FND_API.G_EXC_ERROR;
2320: END;
2321: end if;

Line 2345: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

2341: COMMIT WORK;
2342: END IF;
2343:
2344: -- Debug Message
2345: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
2346: THEN
2347: FND_MESSAGE.Set_Name('CSF', l_api_name);
2348: FND_MESSAGE.Set_Token ('INFO', G_PKG_NAME, FALSE);
2349: FND_MSG_PUB.Add;

Line 2349: FND_MSG_PUB.Add;

2345: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
2346: THEN
2347: FND_MESSAGE.Set_Name('CSF', l_api_name);
2348: FND_MESSAGE.Set_Token ('INFO', G_PKG_NAME, FALSE);
2349: FND_MSG_PUB.Add;
2350: END IF;
2351:
2352: -- Standard call to get message count and if count is 1, get message info.
2353: FND_MSG_PUB.Count_And_Get

Line 2353: FND_MSG_PUB.Count_And_Get

2349: FND_MSG_PUB.Add;
2350: END IF;
2351:
2352: -- Standard call to get message count and if count is 1, get message info.
2353: FND_MSG_PUB.Count_And_Get
2354: ( p_count => x_msg_count,
2355: p_data => x_msg_data
2356: );
2357: end if; -- if charge_upload_status='INTERFACED'

Line 2362: FND_MSG_PUB.Count_And_Get (

2358: EXCEPTION
2359: WHEN FND_API.G_EXC_ERROR THEN
2360: ROLLBACK TO UPDATE_DEBRIEF_LINE_PVT;
2361: x_return_status := FND_API.G_RET_STS_ERROR;
2362: FND_MSG_PUB.Count_And_Get (
2363: P_COUNT => X_MSG_COUNT
2364: ,P_DATA => X_MSG_DATA);
2365:
2366: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2369: FND_MSG_PUB.Count_And_Get (

2365:
2366: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2367: ROLLBACK TO UPDATE_DEBRIEF_LINE_PVT;
2368: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2369: FND_MSG_PUB.Count_And_Get (
2370: P_COUNT => X_MSG_COUNT
2371: ,P_DATA => X_MSG_DATA);
2372:
2373: WHEN OTHERS THEN

Line 2376: IF FND_MSG_PUB.Check_Msg_Level

2372:
2373: WHEN OTHERS THEN
2374: ROLLBACK TO UPDATE_DEBRIEF_LINE_PVT;
2375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2376: IF FND_MSG_PUB.Check_Msg_Level
2377: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2378: THEN
2379: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME ,L_API_NAME );
2380: END IF;

Line 2377: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2373: WHEN OTHERS THEN
2374: ROLLBACK TO UPDATE_DEBRIEF_LINE_PVT;
2375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2376: IF FND_MSG_PUB.Check_Msg_Level
2377: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2378: THEN
2379: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME ,L_API_NAME );
2380: END IF;
2381:

Line 2379: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME ,L_API_NAME );

2375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2376: IF FND_MSG_PUB.Check_Msg_Level
2377: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2378: THEN
2379: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME ,L_API_NAME );
2380: END IF;
2381:
2382: FND_MSG_PUB.Count_And_Get (
2383: P_COUNT => X_MSG_COUNT

Line 2382: FND_MSG_PUB.Count_And_Get (

2378: THEN
2379: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME ,L_API_NAME );
2380: END IF;
2381:
2382: FND_MSG_PUB.Count_And_Get (
2383: P_COUNT => X_MSG_COUNT
2384: ,P_DATA => X_MSG_DATA);
2385:
2386: End Update_debrief_line;

Line 2401: FND_MSG_PUB.initialize;

2397: BEGIN
2398: -- Initialize message list if p_init_msg_list is set to TRUE.
2399: IF FND_API.to_Boolean( p_init_msg_list )
2400: THEN
2401: FND_MSG_PUB.initialize;
2402: END IF;
2403:
2404: -- Initialize API return status to SUCCESS
2405: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2408: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2404: -- Initialize API return status to SUCCESS
2405: x_return_status := FND_API.G_RET_STS_SUCCESS;
2406: IF (p_service_date is NULL OR p_service_date = FND_API.G_MISS_DATE) THEN
2407: x_return_status := FND_API.G_RET_STS_ERROR;
2408: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2409: FND_MESSAGE.Set_Name('CSF', 'CSF_DEBRIEF_SERVICE_DATE');
2410: FND_MSG_PUB.ADD;
2411: END IF;
2412: END IF;

Line 2410: FND_MSG_PUB.ADD;

2406: IF (p_service_date is NULL OR p_service_date = FND_API.G_MISS_DATE) THEN
2407: x_return_status := FND_API.G_RET_STS_ERROR;
2408: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2409: FND_MESSAGE.Set_Name('CSF', 'CSF_DEBRIEF_SERVICE_DATE');
2410: FND_MSG_PUB.ADD;
2411: END IF;
2412: END IF;
2413:
2414: -- Standard call to get message count and if count is 1, get message info.

Line 2415: FND_MSG_PUB.Count_And_Get

2411: END IF;
2412: END IF;
2413:
2414: -- Standard call to get message count and if count is 1, get message info.
2415: FND_MSG_PUB.Count_And_Get
2416: ( p_count => x_msg_count,
2417: p_data => x_msg_data
2418: );
2419:

Line 2447: FND_MSG_PUB.initialize;

2443: BEGIN
2444: -- Initialize message list if p_init_msg_list is set to TRUE.
2445: IF FND_API.to_Boolean( p_init_msg_list )
2446: THEN
2447: FND_MSG_PUB.initialize;
2448: END IF;
2449:
2450: -- Initialize API return status to SUCCESS
2451: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2457: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2453: fetch c_subinventory_code into l_organization_code,l_subinventory_code;
2454: close c_subinventory_code;
2455: IF l_subinventory_code is NULL THEN
2456: x_return_status := FND_API.G_RET_STS_ERROR;
2457: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2458: FND_MESSAGE.Set_Name('CSP', 'CSP_INVALID_ORG_SUBINV');
2459: FND_MESSAGE.set_token('ORG',l_organization_code,TRUE);
2460: FND_MESSAGE.set_token('SUBINV',l_subinventory_code,TRUE);
2461: FND_MSG_PUB.ADD;

Line 2461: FND_MSG_PUB.ADD;

2457: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2458: FND_MESSAGE.Set_Name('CSP', 'CSP_INVALID_ORG_SUBINV');
2459: FND_MESSAGE.set_token('ORG',l_organization_code,TRUE);
2460: FND_MESSAGE.set_token('SUBINV',l_subinventory_code,TRUE);
2461: FND_MSG_PUB.ADD;
2462: END IF;
2463: END IF;
2464:
2465: -- Standard call to get message count and if count is 1, get message info.

Line 2466: FND_MSG_PUB.Count_And_Get

2462: END IF;
2463: END IF;
2464:
2465: -- Standard call to get message count and if count is 1, get message info.
2466: FND_MSG_PUB.Count_And_Get
2467: ( p_count => x_msg_count,
2468: p_data => x_msg_data);
2469:
2470: END validate_subinventory_code;

Line 2492: FND_MSG_PUB.initialize;

2488: BEGIN
2489: -- Initialize message list if p_init_msg_list is set to TRUE.
2490: IF FND_API.to_Boolean( p_init_msg_list )
2491: THEN
2492: FND_MSG_PUB.initialize;
2493: END IF;
2494:
2495: -- Initialize API return status to SUCCESS
2496: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2503: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2499: fetch c_inventory_item into l_inventory_item_id;
2500: close c_inventory_item;
2501: IF l_inventory_item_id is null THEN
2502: x_return_status := FND_API.G_RET_STS_ERROR;
2503: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2504: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_INVENTORY_ITEM_ID');
2505: FND_MSG_PUB.ADD;
2506: END IF;
2507: END IF;

Line 2505: FND_MSG_PUB.ADD;

2501: IF l_inventory_item_id is null THEN
2502: x_return_status := FND_API.G_RET_STS_ERROR;
2503: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2504: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_INVENTORY_ITEM_ID');
2505: FND_MSG_PUB.ADD;
2506: END IF;
2507: END IF;
2508: -- Standard call to get message count and if count is 1, get message info.
2509: FND_MSG_PUB.Count_And_Get

Line 2509: FND_MSG_PUB.Count_And_Get

2505: FND_MSG_PUB.ADD;
2506: END IF;
2507: END IF;
2508: -- Standard call to get message count and if count is 1, get message info.
2509: FND_MSG_PUB.Count_And_Get
2510: ( p_count => x_msg_count,
2511: p_data => x_msg_data
2512: );
2513:

Line 2536: FND_MSG_PUB.initialize;

2532:
2533: -- Initialize message list if p_init_msg_list is set to TRUE.
2534: IF FND_API.to_Boolean( p_init_msg_list )
2535: THEN
2536: FND_MSG_PUB.initialize;
2537: END IF;
2538:
2539: -- Initialize API return status to SUCCESS
2540: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2547: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2543: fetch get_instance_id into l_dummy;
2544: if get_instance_id%notfound then
2545: close get_instance_id;
2546: x_return_status := FND_API.G_RET_STS_ERROR;
2547: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2548: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_INSTANCE_ID');
2549: FND_MSG_PUB.ADD;
2550: END IF;
2551: end if;

Line 2549: FND_MSG_PUB.ADD;

2545: close get_instance_id;
2546: x_return_status := FND_API.G_RET_STS_ERROR;
2547: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2548: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_INSTANCE_ID');
2549: FND_MSG_PUB.ADD;
2550: END IF;
2551: end if;
2552: close get_instance_id;
2553: END IF;

Line 2556: FND_MSG_PUB.Count_And_Get

2552: close get_instance_id;
2553: END IF;
2554:
2555: -- Standard call to get message count and if count is 1, get message info.
2556: FND_MSG_PUB.Count_And_Get
2557: ( p_count => x_msg_count,
2558: p_data => x_msg_data
2559: );
2560: END Validate_Instance_ID;

Line 2580: FND_MSG_PUB.initialize;

2576:
2577: -- Initialize message list if p_init_msg_list is set to TRUE.
2578: IF FND_API.to_Boolean( p_init_msg_list )
2579: THEN
2580: FND_MSG_PUB.initialize;
2581: END IF;
2582:
2583: -- Initialize API return status to SUCCESS
2584: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2587: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2583: -- Initialize API return status to SUCCESS
2584: x_return_status := FND_API.G_RET_STS_SUCCESS;
2585: IF (P_DEBRIEF_HEADER_ID is NULL OR P_DEBRIEF_HEADER_ID = FND_API.G_MISS_NUM) THEN
2586: x_return_status := FND_API.G_RET_STS_ERROR;
2587: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2588: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_HEADER_ID');
2589: FND_MSG_PUB.ADD;
2590: END IF;
2591: ELSE

Line 2589: FND_MSG_PUB.ADD;

2585: IF (P_DEBRIEF_HEADER_ID is NULL OR P_DEBRIEF_HEADER_ID = FND_API.G_MISS_NUM) THEN
2586: x_return_status := FND_API.G_RET_STS_ERROR;
2587: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2588: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_HEADER_ID');
2589: FND_MSG_PUB.ADD;
2590: END IF;
2591: ELSE
2592: open validate_header_id;
2593: fetch validate_header_id into l_dummy;

Line 2597: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2593: fetch validate_header_id into l_dummy;
2594: if validate_header_id%notfound then
2595: -- close validate_header_id;
2596: x_return_status := FND_API.G_RET_STS_ERROR;
2597: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2598: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_HEADER_ID');
2599: FND_MSG_PUB.ADD;
2600: END IF;
2601: end if;

Line 2599: FND_MSG_PUB.ADD;

2595: -- close validate_header_id;
2596: x_return_status := FND_API.G_RET_STS_ERROR;
2597: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2598: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_HEADER_ID');
2599: FND_MSG_PUB.ADD;
2600: END IF;
2601: end if;
2602: close validate_header_id ;
2603: END IF;

Line 2605: FND_MSG_PUB.Count_And_Get

2601: end if;
2602: close validate_header_id ;
2603: END IF;
2604: -- Standard call to get message count and if count is 1, get message info.
2605: FND_MSG_PUB.Count_And_Get
2606: ( p_count => x_msg_count,
2607: p_data => x_msg_data
2608: );
2609:

Line 2628: FND_MSG_PUB.initialize;

2624: BEGIN
2625: -- Initialize message list if p_init_msg_list is set to TRUE.
2626: IF FND_API.to_Boolean( p_init_msg_list )
2627: THEN
2628: FND_MSG_PUB.initialize;
2629: END IF;
2630:
2631: -- Initialize API return status to SUCCESS
2632: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2636: ELSIF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2632: x_return_status := FND_API.G_RET_STS_SUCCESS;
2633: IF(p_validation_mode = G_CREATE) THEN
2634: IF (p_debrief_line_number is NULL OR p_debrief_line_number = FND_API.G_MISS_NUM ) THEN
2635: x_return_status := FND_API.G_RET_STS_ERROR;
2636: ELSIF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2637: THEN
2638: FND_MESSAGE.Set_Name('CSF', l_api_name);
2639: FND_MESSAGE.Set_Token('COLUMN', 'DEBRIEF_LINE_NUMBER', FALSE);
2640: FND_MSG_PUB.ADD;

Line 2640: FND_MSG_PUB.ADD;

2636: ELSIF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2637: THEN
2638: FND_MESSAGE.Set_Name('CSF', l_api_name);
2639: FND_MESSAGE.Set_Token('COLUMN', 'DEBRIEF_LINE_NUMBER', FALSE);
2640: FND_MSG_PUB.ADD;
2641: END IF;
2642: END IF;
2643:
2644: -- Standard call to get message count and if count is 1, get message info.

Line 2645: FND_MSG_PUB.Count_And_Get

2641: END IF;
2642: END IF;
2643:
2644: -- Standard call to get message count and if count is 1, get message info.
2645: FND_MSG_PUB.Count_And_Get
2646: ( p_count => x_msg_count,
2647: p_data => x_msg_data
2648: );
2649:

Line 2669: FND_MSG_PUB.initialize;

2665: BEGIN
2666: -- Initialize message list if p_init_msg_list is set to TRUE.
2667: IF FND_API.to_Boolean( p_init_msg_list )
2668: THEN
2669: FND_MSG_PUB.initialize;
2670: END IF;
2671:
2672: -- Initialize API return status to SUCCESS
2673: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2676: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2672: -- Initialize API return status to SUCCESS
2673: x_return_status := FND_API.G_RET_STS_SUCCESS;
2674: IF (p_business_process_id is NULL OR p_business_process_id = FND_API.G_MISS_NUM ) THEN
2675: x_return_status := FND_API.G_RET_STS_ERROR;
2676: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2677: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_BUS_PROCESS_ID');
2678: FND_MSG_PUB.ADD;
2679: END IF;
2680: ELSE

Line 2678: FND_MSG_PUB.ADD;

2674: IF (p_business_process_id is NULL OR p_business_process_id = FND_API.G_MISS_NUM ) THEN
2675: x_return_status := FND_API.G_RET_STS_ERROR;
2676: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2677: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_BUS_PROCESS_ID');
2678: FND_MSG_PUB.ADD;
2679: END IF;
2680: ELSE
2681: open get_business_process_id;
2682: fetch get_business_process_id into l_dummy;

Line 2686: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2682: fetch get_business_process_id into l_dummy;
2683: if get_business_process_id%notfound then
2684: close get_business_process_id;
2685: x_return_status := FND_API.G_RET_STS_ERROR;
2686: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2687: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_BUS_PROCESS_ID');
2688: FND_MSG_PUB.ADD;
2689: END IF;
2690: end if;

Line 2688: FND_MSG_PUB.ADD;

2684: close get_business_process_id;
2685: x_return_status := FND_API.G_RET_STS_ERROR;
2686: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2687: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_BUS_PROCESS_ID');
2688: FND_MSG_PUB.ADD;
2689: END IF;
2690: end if;
2691: close get_business_process_id;
2692: END IF;

Line 2695: FND_MSG_PUB.Count_And_Get

2691: close get_business_process_id;
2692: END IF;
2693:
2694: -- Standard call to get message count and if count is 1, get message info.
2695: FND_MSG_PUB.Count_And_Get
2696: ( p_count => x_msg_count,
2697: p_data => x_msg_data
2698: );
2699: END Validate_BUSINESS_PROCESS_ID;

Line 2717: FND_MSG_PUB.initialize;

2713: BEGIN
2714: -- Initialize message list if p_init_msg_list is set to TRUE.
2715: IF FND_API.to_Boolean( p_init_msg_list )
2716: THEN
2717: FND_MSG_PUB.initialize;
2718: END IF;
2719:
2720: -- Initialize API return status to SUCCESS
2721: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2724: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2720: -- Initialize API return status to SUCCESS
2721: x_return_status := FND_API.G_RET_STS_SUCCESS;
2722: IF (p_transaction_type_id is NULL OR p_transaction_type_id = FND_API.G_MISS_NUM ) THEN
2723: x_return_status := FND_API.G_RET_STS_ERROR;
2724: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2725: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_TXN_BILLING_TYP_ID');
2726: FND_MSG_PUB.ADD;
2727: END IF;
2728: ELSE

Line 2726: FND_MSG_PUB.ADD;

2722: IF (p_transaction_type_id is NULL OR p_transaction_type_id = FND_API.G_MISS_NUM ) THEN
2723: x_return_status := FND_API.G_RET_STS_ERROR;
2724: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2725: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_TXN_BILLING_TYP_ID');
2726: FND_MSG_PUB.ADD;
2727: END IF;
2728: ELSE
2729: open get_transaction_type_id;
2730: fetch get_transaction_type_id into l_dummy;

Line 2734: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2730: fetch get_transaction_type_id into l_dummy;
2731: if get_transaction_type_id%notfound then
2732: close get_transaction_type_id;
2733: x_return_status := FND_API.G_RET_STS_ERROR;
2734: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2735: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_TXN_BILLING_TYP_ID');
2736: FND_MSG_PUB.ADD;
2737: END IF;
2738: end if;

Line 2736: FND_MSG_PUB.ADD;

2732: close get_transaction_type_id;
2733: x_return_status := FND_API.G_RET_STS_ERROR;
2734: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2735: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_TXN_BILLING_TYP_ID');
2736: FND_MSG_PUB.ADD;
2737: END IF;
2738: end if;
2739: close get_transaction_type_id;
2740: END IF;

Line 2743: FND_MSG_PUB.Count_And_Get

2739: close get_transaction_type_id;
2740: END IF;
2741:
2742: -- Standard call to get message count and if count is 1, get message info.
2743: FND_MSG_PUB.Count_And_Get
2744: ( p_count => x_msg_count,
2745: p_data => x_msg_data
2746: );
2747: END Validate_TRANSACTION_TYPE_ID;

Line 2792: FND_MSG_PUB.initialize;

2788:
2789: -- Initialize message list if p_init_msg_list is set to TRUE.
2790: IF FND_API.to_Boolean( p_init_msg_list )
2791: THEN
2792: FND_MSG_PUB.initialize;
2793: END IF;
2794:
2795: -- Initialize API return status to SUCCESS
2796: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2833: FND_MSG_PUB.GET(P_MSG_INDEX=>1,

2829: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2830: RAISE FND_API.G_EXC_ERROR;
2831: END IF;
2832:
2833: FND_MSG_PUB.GET(P_MSG_INDEX=>1,
2834: P_ENCODED=>'F',
2835: p_data=>l_msg_data,
2836: p_MSG_index_out=>l_msg_index_out);
2837:

Line 2882: FND_MSG_PUB.Count_And_Get (

2878: EXCEPTION
2879: WHEN FND_API.G_EXC_ERROR THEN
2880: ROLLBACK TO CREATE_INTERACTION;
2881: x_return_status := FND_API.G_RET_STS_ERROR;
2882: FND_MSG_PUB.Count_And_Get (
2883: P_COUNT => X_MSG_COUNT
2884: ,P_DATA => X_MSG_DATA);
2885:
2886: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2889: FND_MSG_PUB.Count_And_Get (

2885:
2886: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2887: ROLLBACK TO CREATE_INTERACTION;
2888: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2889: FND_MSG_PUB.Count_And_Get (
2890: P_COUNT => X_MSG_COUNT
2891: ,P_DATA => X_MSG_DATA);
2892:
2893: WHEN OTHERS THEN

Line 2896: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2892:
2893: WHEN OTHERS THEN
2894: ROLLBACK TO CREATE_INTERACTION;
2895: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2896: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2897: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,L_API_NAME);
2898: END IF;
2899: FND_MSG_PUB.Count_And_Get (
2900: P_COUNT => X_MSG_COUNT

Line 2897: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,L_API_NAME);

2893: WHEN OTHERS THEN
2894: ROLLBACK TO CREATE_INTERACTION;
2895: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2896: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2897: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,L_API_NAME);
2898: END IF;
2899: FND_MSG_PUB.Count_And_Get (
2900: P_COUNT => X_MSG_COUNT
2901: ,P_DATA => X_MSG_DATA);

Line 2899: FND_MSG_PUB.Count_And_Get (

2895: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2896: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2897: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,L_API_NAME);
2898: END IF;
2899: FND_MSG_PUB.Count_And_Get (
2900: P_COUNT => X_MSG_COUNT
2901: ,P_DATA => X_MSG_DATA);
2902:
2903: END;

Line 3238: FND_MSG_PUB.ADD;

3234:
3235: if l_debrief_header_id is not null then
3236: x_return_status := FND_API.G_RET_STS_ERROR;
3237: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_EXISTS');
3238: FND_MSG_PUB.ADD;
3239: end if;
3240:
3241: exception
3242: when others then

Line 3262: FND_MSG_PUB.initialize;

3258: where cdh.task_assignment_id = p_task_assignment_id
3259: and cdh.debrief_header_id = cdl.debrief_header_id;
3260:
3261: BEGIN
3262: FND_MSG_PUB.initialize;
3263: -- Initialize API return status to SUCCESS
3264: x_return_status := FND_API.G_RET_STS_SUCCESS;
3265: open get_debrief_status;
3266: fetch get_debrief_status into l_processed_flag;

Line 3273: FND_MSG_PUB.ADD;

3269: x_return_status := FND_API.G_RET_STS_SUCCESS;
3270: else
3271: x_return_status := FND_API.G_RET_STS_ERROR;
3272: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_PENDING');
3273: FND_MSG_PUB.ADD;
3274: end if;
3275: -- Standard call to get message count and if count is 1, get message info.
3276: FND_MSG_PUB.Count_And_Get
3277: ( p_count => x_msg_count,

Line 3276: FND_MSG_PUB.Count_And_Get

3272: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_PENDING');
3273: FND_MSG_PUB.ADD;
3274: end if;
3275: -- Standard call to get message count and if count is 1, get message info.
3276: FND_MSG_PUB.Count_And_Get
3277: ( p_count => x_msg_count,
3278: p_data => x_msg_data);
3279: END CLOSE_DEBRIEF;
3280:

Line 3830: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

3826: or p_actual_travel_start_time = FND_API.g_miss_date)
3827: and (p_actual_travel_end_time <> FND_API.g_miss_date
3828: and p_actual_travel_end_time IS NOT NULL) THEN
3829: X_Return_Status := FND_API.G_RET_STS_ERROR;
3830: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3831: FND_MESSAGE.Set_Name('CSF','CSF_TRAVEL_START_TIME');
3832: FND_MSG_PUB.ADD;
3833: END IF;
3834: END IF;

Line 3832: FND_MSG_PUB.ADD;

3828: and p_actual_travel_end_time IS NOT NULL) THEN
3829: X_Return_Status := FND_API.G_RET_STS_ERROR;
3830: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3831: FND_MESSAGE.Set_Name('CSF','CSF_TRAVEL_START_TIME');
3832: FND_MSG_PUB.ADD;
3833: END IF;
3834: END IF;
3835:
3836: If (p_actual_travel_start_time IS NOT NULL

Line 3842: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

3838: and p_actual_travel_start_time <> FND_API.g_miss_date
3839: and p_actual_travel_end_time <> FND_API.g_miss_date
3840: AND p_actual_travel_start_time > p_actual_travel_end_time) THEN
3841: X_Return_Status := FND_API.G_RET_STS_ERROR;
3842: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3843: FND_MESSAGE.Set_Name('CSF','CSF_TRAVEL_START_AFTER_END');
3844: FND_MSG_PUB.ADD;
3845: END IF;
3846: END IF;

Line 3844: FND_MSG_PUB.ADD;

3840: AND p_actual_travel_start_time > p_actual_travel_end_time) THEN
3841: X_Return_Status := FND_API.G_RET_STS_ERROR;
3842: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3843: FND_MESSAGE.Set_Name('CSF','CSF_TRAVEL_START_AFTER_END');
3844: FND_MSG_PUB.ADD;
3845: END IF;
3846: END IF;
3847:
3848: If p_actual_travel_start_time IS NOT NULL

Line 3857: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

3853: > trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
3854: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
3855: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')))) THEN
3856: X_Return_Status := FND_API.G_RET_STS_ERROR;
3857: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3858: FND_MESSAGE.Set_Name('CSF','CSF_TRAVEL_START_CURR_DATE');
3859: FND_MSG_PUB.ADD;
3860: END IF;
3861: END IF;

Line 3859: FND_MSG_PUB.ADD;

3855: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')))) THEN
3856: X_Return_Status := FND_API.G_RET_STS_ERROR;
3857: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3858: FND_MESSAGE.Set_Name('CSF','CSF_TRAVEL_START_CURR_DATE');
3859: FND_MSG_PUB.ADD;
3860: END IF;
3861: END IF;
3862: If p_actual_travel_end_time IS NOT NULL
3863: and p_actual_travel_end_time <> FND_API.g_miss_date

Line 3871: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

3867: > trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
3868: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
3869: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')))) THEN
3870: X_Return_Status := FND_API.G_RET_STS_ERROR;
3871: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3872: FND_MESSAGE.Set_Name('CSF','CSF_TRAVEL_END_CURR_DATE');
3873: FND_MSG_PUB.ADD;
3874: END IF;
3875: END IF;

Line 3873: FND_MSG_PUB.ADD;

3869: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')))) THEN
3870: X_Return_Status := FND_API.G_RET_STS_ERROR;
3871: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3872: FND_MESSAGE.Set_Name('CSF','CSF_TRAVEL_END_CURR_DATE');
3873: FND_MSG_PUB.ADD;
3874: END IF;
3875: END IF;
3876:
3877: If (p_actual_travel_start_time IS NOT NULL

Line 3881: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

3877: If (p_actual_travel_start_time IS NOT NULL
3878: and p_actual_travel_start_time <> FND_API.g_miss_date
3879: and p_actual_travel_start_time < l_service_request_date) THEN
3880: X_Return_Status := FND_API.G_RET_STS_ERROR;
3881: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3882: FND_MESSAGE.Set_Name('CSF','CSF_TRAVEL_START_SR_DATE');
3883: FND_MSG_PUB.ADD;
3884: END IF;
3885: END IF;

Line 3883: FND_MSG_PUB.ADD;

3879: and p_actual_travel_start_time < l_service_request_date) THEN
3880: X_Return_Status := FND_API.G_RET_STS_ERROR;
3881: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3882: FND_MESSAGE.Set_Name('CSF','CSF_TRAVEL_START_SR_DATE');
3883: FND_MSG_PUB.ADD;
3884: END IF;
3885: END IF;
3886: If (p_actual_travel_end_time IS NOT NULL
3887: and p_actual_travel_end_time <> FND_API.g_miss_date

Line 3890: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

3886: If (p_actual_travel_end_time IS NOT NULL
3887: and p_actual_travel_end_time <> FND_API.g_miss_date
3888: and p_actual_travel_end_time < l_service_request_date) THEN
3889: X_Return_Status := FND_API.G_RET_STS_ERROR;
3890: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3891: FND_MESSAGE.Set_Name('CSF','CSF_TRAVEL_END_SR_DATE');
3892: FND_MSG_PUB.ADD;
3893: END IF;
3894: END IF;

Line 3892: FND_MSG_PUB.ADD;

3888: and p_actual_travel_end_time < l_service_request_date) THEN
3889: X_Return_Status := FND_API.G_RET_STS_ERROR;
3890: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3891: FND_MESSAGE.Set_Name('CSF','CSF_TRAVEL_END_SR_DATE');
3892: FND_MSG_PUB.ADD;
3893: END IF;
3894: END IF;
3895: END;
3896: