APPS.CSF_DEBRIEF_PVT dependencies on FND_MSG_PUB

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

57: and p_labor_start_time <> FND_API.g_miss_date
58: and p_labor_end_time <> FND_API.g_miss_date
59: AND p_labor_start_time > p_labor_end_time) THEN
60: X_Return_Status := FND_API.G_RET_STS_ERROR;
61: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
62: FND_MESSAGE.Set_Name('CSF','CSF_LABOR_START_DATE_ERR');
63: FND_MSG_PUB.ADD;
64: END IF;
65: END IF;

Line 63: FND_MSG_PUB.ADD;

59: AND p_labor_start_time > p_labor_end_time) THEN
60: X_Return_Status := FND_API.G_RET_STS_ERROR;
61: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
62: FND_MESSAGE.Set_Name('CSF','CSF_LABOR_START_DATE_ERR');
63: FND_MSG_PUB.ADD;
64: END IF;
65: END IF;
66: If p_labor_start_time IS NOT NULL
67: and l_date_val in ('N','P')

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

72: > trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
73: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
74: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')))) THEN
75: X_Return_Status := FND_API.G_RET_STS_ERROR;
76: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
77: FND_MESSAGE.Set_Name('CSF','CSFW_SERVICE_DATE');
78: fnd_message.set_token('P_SR_DATE',to_char(fnd_timezones_pvt.adjust_datetime(l_service_request_date,
79: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
80: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID'))),'DD-Mon-RRRR HH24:MI'));

Line 84: FND_MSG_PUB.ADD;

80: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID'))),'DD-Mon-RRRR HH24:MI'));
81: fnd_message.set_token('P_SYSTEM_DATE',to_char(trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
82: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
83: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')))),'DD-Mon-RRRR')||' 23:59');
84: FND_MSG_PUB.ADD;
85: END IF;
86: END IF;
87: If p_labor_end_time IS NOT NULL
88: and l_date_val in ('N','P')

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

93: > trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
94: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
95: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')))) THEN
96: X_Return_Status := FND_API.G_RET_STS_ERROR;
97: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
98: FND_MESSAGE.Set_Name('CSF','CSFW_SERVICE_DATE_END');
99: fnd_message.set_token('P_SR_DATE',to_char(fnd_timezones_pvt.adjust_datetime(l_service_request_date,
100: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
101: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID'))),'DD-Mon-RRRR HH24:MI'));

Line 105: FND_MSG_PUB.ADD;

101: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID'))),'DD-Mon-RRRR HH24:MI'));
102: fnd_message.set_token('P_SYSTEM_DATE',to_char(trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
103: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
104: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')))),'DD-Mon-RRRR')||' 23:59');
105: FND_MSG_PUB.ADD;
106: END IF;
107: END IF;
108:
109: If (p_labor_start_time IS NOT NULL

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

110: and l_date_val in ('N','Y')
111: and p_labor_start_time <> FND_API.g_miss_date
112: and p_labor_start_time < l_service_request_date) THEN
113: X_Return_Status := FND_API.G_RET_STS_ERROR;
114: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
115: FND_MESSAGE.Set_Name('CSF','CSFW_SERVICE_DATE');
116: fnd_message.set_token('P_SR_DATE',to_char(fnd_timezones_pvt.adjust_datetime(l_service_request_date,
117: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
118: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID'))),'DD-Mon-RRRR HH24:MI'));

Line 122: FND_MSG_PUB.ADD;

118: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID'))),'DD-Mon-RRRR HH24:MI'));
119: fnd_message.set_token('P_SYSTEM_DATE',to_char(trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
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')||' 23:59');
122: FND_MSG_PUB.ADD;
123: END IF;
124: END IF;
125: If (p_labor_end_time IS NOT NULL
126: and l_date_val in ('N','Y')

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

126: and l_date_val in ('N','Y')
127: and p_labor_end_time <> FND_API.g_miss_date
128: and p_labor_end_time < l_service_request_date) THEN
129: X_Return_Status := FND_API.G_RET_STS_ERROR;
130: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
131: FND_MESSAGE.Set_Name('CSF','CSFW_SERVICE_DATE_END');
132: fnd_message.set_token('P_SR_DATE',to_char(fnd_timezones_pvt.adjust_datetime(l_service_request_date,
133: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
134: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID'))),'DD-Mon-RRRR HH24:MI'));

Line 138: FND_MSG_PUB.ADD;

134: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID'))),'DD-Mon-RRRR HH24:MI'));
135: fnd_message.set_token('P_SYSTEM_DATE',to_char(trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
136: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
137: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')))),'DD-Mon-RRRR')||' 23:59');
138: FND_MSG_PUB.ADD;
139: END IF;
140: END IF;
141: END;
142:

Line 222: FND_MSG_PUB.initialize;

218:
219: -- Initialize message list if p_init_msg_list is set to TRUE.
220: IF FND_API.to_Boolean( p_init_msg_list )
221: THEN
222: FND_MSG_PUB.initialize;
223: END IF;
224:
225:
226: -- Debug Message

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

223: END IF;
224:
225:
226: -- Debug Message
227: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
228: THEN
229: FND_MESSAGE.Set_Name('CSF', l_api_name);
230: FND_MESSAGE.Set_Token ('INFO', G_PKG_NAME, FALSE);
231: FND_MSG_PUB.Add;

Line 231: FND_MSG_PUB.Add;

227: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
228: THEN
229: FND_MESSAGE.Set_Name('CSF', l_api_name);
230: FND_MESSAGE.Set_Token ('INFO', G_PKG_NAME, FALSE);
231: FND_MSG_PUB.Add;
232:
233: END IF;
234:
235: -- Initialize API return status to SUCCESS

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

244:
245: -- Virendra Singh 03/24/2000 check whether Header record is missing
246: if IS_DEBRIEF_HEADER_REC_MISSING(P_DEBRIEF_REC) then
247:
248: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
249: THEN
250: fnd_message.set_name('CSF', 'CSF_DEBRIEF_MISSING_HEADER');
251: fnd_msg_pub.add;
252: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 251: fnd_msg_pub.add;

247:
248: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
249: THEN
250: fnd_message.set_name('CSF', 'CSF_DEBRIEF_MISSING_HEADER');
251: fnd_msg_pub.add;
252: x_return_status := fnd_api.g_ret_sts_unexp_error;
253: RAISE fnd_api.g_exc_unexpected_error;
254: END IF;
255: end if;

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

281: RAISE fnd_api.g_exc_unexpected_error;
282: END IF;
283: END IF;
284: -- Debug Message
285: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
286: THEN
287: FND_MESSAGE.Set_Name('CSF', l_api_name);
288: FND_MESSAGE.Set_Token ('INFO', G_PKG_NAME, FALSE);
289: FND_MSG_PUB.Add;

Line 289: FND_MSG_PUB.Add;

285: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
286: THEN
287: FND_MESSAGE.Set_Name('CSF', l_api_name);
288: FND_MESSAGE.Set_Token ('INFO', G_PKG_NAME, FALSE);
289: FND_MSG_PUB.Add;
290: END IF;
291:
292: -- Invoke table handler(debrief_Insert_Row)
293:

Line 305: fnd_msg_pub.add;

301: from CSF_DEBRIEF_HEADERS
302: where DEBRIEF_HEADER_ID = l_DEBRIEF_HEADER_ID ;
303:
304: fnd_message.set_name('CSF', 'CSF_DEBRIEF_INVALID_HEADER');
305: fnd_msg_pub.add;
306: x_return_status := fnd_api.g_ret_sts_unexp_error;
307: RAISE fnd_api.g_exc_unexpected_error;
308: exception
309: when no_data_found then

Line 313: fnd_msg_pub.add;

309: when no_data_found then
310: null ;
311: when too_many_rows then
312: fnd_message.set_name('CSF', 'CSF_DEBRIEF_INVALID_HEADER');
313: fnd_msg_pub.add;
314: x_return_status := fnd_api.g_ret_sts_unexp_error;
315: RAISE fnd_api.g_exc_unexpected_error;
316: end ;
317:

Line 466: FND_MSG_PUB.Count_And_Get

462: END IF;
463:
464:
465: -- Standard call to get message count and if count is 1, get message info.
466: FND_MSG_PUB.Count_And_Get
467: ( p_count => x_msg_count,
468: p_data => x_msg_data
469: );
470:

Line 476: FND_MSG_PUB.Count_And_Get (

472: EXCEPTION
473: WHEN FND_API.G_EXC_ERROR THEN
474: ROLLBACK TO CREATE_DEBRIEF_HEADER_PVT;
475: x_return_status := FND_API.G_RET_STS_ERROR;
476: FND_MSG_PUB.Count_And_Get (
477: P_COUNT => X_MSG_COUNT
478: ,P_DATA => X_MSG_DATA);
479:
480: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 484: FND_MSG_PUB.Count_And_Get (

480: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
481: ROLLBACK TO CREATE_DEBRIEF_HEADER_PVT;
482:
483: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
484: FND_MSG_PUB.Count_And_Get (
485: P_COUNT => X_MSG_COUNT
486: ,P_DATA => X_MSG_DATA);
487:
488: WHEN OTHERS THEN

Line 491: IF FND_MSG_PUB.Check_Msg_Level

487:
488: WHEN OTHERS THEN
489: ROLLBACK TO CREATE_DEBRIEF_HEADER_PVT;
490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
491: IF FND_MSG_PUB.Check_Msg_Level
492: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
493: THEN
494: FND_MSG_PUB.Add_Exc_Msg (
495: G_PKG_NAME

Line 492: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

488: WHEN OTHERS THEN
489: ROLLBACK TO CREATE_DEBRIEF_HEADER_PVT;
490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
491: IF FND_MSG_PUB.Check_Msg_Level
492: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
493: THEN
494: FND_MSG_PUB.Add_Exc_Msg (
495: G_PKG_NAME
496: ,L_API_NAME );

Line 494: FND_MSG_PUB.Add_Exc_Msg (

490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
491: IF FND_MSG_PUB.Check_Msg_Level
492: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
493: THEN
494: FND_MSG_PUB.Add_Exc_Msg (
495: G_PKG_NAME
496: ,L_API_NAME );
497: END IF;
498:

Line 499: FND_MSG_PUB.Count_And_Get (

495: G_PKG_NAME
496: ,L_API_NAME );
497: END IF;
498:
499: FND_MSG_PUB.Count_And_Get (
500: P_COUNT => X_MSG_COUNT
501: ,P_DATA => X_MSG_DATA);
502:
503: End Create_debrief;

Line 570: FND_MSG_PUB.initialize;

566:
567: -- Initialize message list if p_init_msg_list is set to TRUE.
568: IF FND_API.to_Boolean( p_init_msg_list )
569: THEN
570: FND_MSG_PUB.initialize;
571: END IF;
572:
573: -- Initialize API return status to SUCCESS
574: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

575:
576: l_debrief_header_id:=l_tar_DEBRIEF_rec.Debrief_header_id;
577: -- Virendra Singh 03/27/2000 check whether Debrief_Header_ID is not null or missging
578: if (l_debrief_header_id =FND_API.G_MISS_NUM) or (l_debrief_header_id is NULL ) then
579: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
580: THEN
581: fnd_message.set_name('CSF', 'CSF_DEBRIEF_MISSING_HEADER');
582: fnd_msg_pub.add;
583: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 582: fnd_msg_pub.add;

578: if (l_debrief_header_id =FND_API.G_MISS_NUM) or (l_debrief_header_id is NULL ) then
579: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
580: THEN
581: fnd_message.set_name('CSF', 'CSF_DEBRIEF_MISSING_HEADER');
582: fnd_msg_pub.add;
583: x_return_status := fnd_api.g_ret_sts_unexp_error;
584: RAISE fnd_api.g_exc_unexpected_error;
585: END IF;
586: end if;

Line 714: FND_MSG_PUB.Count_And_Get

710: COMMIT WORK;
711: END IF;
712:
713: -- Standard call to get message count and if count is 1, get message info.
714: FND_MSG_PUB.Count_And_Get
715: ( p_count => x_msg_count,
716: p_data => x_msg_data
717: );
718:

Line 723: FND_MSG_PUB.Count_And_Get (

719: EXCEPTION
720: WHEN FND_API.G_EXC_ERROR THEN
721: ROLLBACK TO UPDATE_DEBRIEF_PVT;
722: x_return_status := FND_API.G_RET_STS_ERROR;
723: FND_MSG_PUB.Count_And_Get (
724: P_COUNT => X_MSG_COUNT
725: ,P_DATA => X_MSG_DATA);
726:
727: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 730: FND_MSG_PUB.Count_And_Get (

726:
727: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
728: ROLLBACK TO UPDATE_DEBRIEF_PVT;
729: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
730: FND_MSG_PUB.Count_And_Get (
731: P_COUNT => X_MSG_COUNT
732: ,P_DATA => X_MSG_DATA);
733:
734: WHEN OTHERS THEN

Line 737: IF FND_MSG_PUB.Check_Msg_Level

733:
734: WHEN OTHERS THEN
735: ROLLBACK TO UPDATE_DEBRIEF_PVT;
736: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
737: IF FND_MSG_PUB.Check_Msg_Level
738: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
739: THEN
740: FND_MSG_PUB.Add_Exc_Msg (
741: G_PKG_NAME

Line 738: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

734: WHEN OTHERS THEN
735: ROLLBACK TO UPDATE_DEBRIEF_PVT;
736: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
737: IF FND_MSG_PUB.Check_Msg_Level
738: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
739: THEN
740: FND_MSG_PUB.Add_Exc_Msg (
741: G_PKG_NAME
742: ,L_API_NAME );

Line 740: FND_MSG_PUB.Add_Exc_Msg (

736: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
737: IF FND_MSG_PUB.Check_Msg_Level
738: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
739: THEN
740: FND_MSG_PUB.Add_Exc_Msg (
741: G_PKG_NAME
742: ,L_API_NAME );
743: END IF;
744:

Line 745: FND_MSG_PUB.Count_And_Get (

741: G_PKG_NAME
742: ,L_API_NAME );
743: END IF;
744:
745: FND_MSG_PUB.Count_And_Get (
746: P_COUNT => X_MSG_COUNT
747: ,P_DATA => X_MSG_DATA);
748:
749: End Update_debrief;

Line 776: FND_MSG_PUB.initialize;

772: BEGIN
773: -- Initialize message list if p_init_msg_list is set to TRUE.
774: IF FND_API.to_Boolean( p_init_msg_list )
775: THEN
776: FND_MSG_PUB.initialize;
777: END IF;
778: -- Initialize API return status to SUCCESS
779: x_return_status := FND_API.G_RET_STS_SUCCESS;
780:

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

779: x_return_status := FND_API.G_RET_STS_SUCCESS;
780:
781: IF (p_task_assignment_id is NULL OR p_task_assignment_id = FND_API.G_MISS_NUM) THEN
782: x_return_status := FND_API.G_RET_STS_ERROR;
783: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
784: THEN
785: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_INVALID_TA_ID');
786: FND_MSG_PUB.ADD;
787: END IF;

Line 786: FND_MSG_PUB.ADD;

782: x_return_status := FND_API.G_RET_STS_ERROR;
783: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
784: THEN
785: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_INVALID_TA_ID');
786: FND_MSG_PUB.ADD;
787: END IF;
788: ELSE
789: open c;
790: fetch c into l_dummy;

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

790: fetch c into l_dummy;
791: if c%notfound then
792: close c;
793: x_return_status := FND_API.G_RET_STS_ERROR;
794: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
795: THEN
796: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_INVALID_TA_ID');
797: FND_MSG_PUB.ADD;
798: END IF;

Line 797: FND_MSG_PUB.ADD;

793: x_return_status := FND_API.G_RET_STS_ERROR;
794: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
795: THEN
796: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_INVALID_TA_ID');
797: FND_MSG_PUB.ADD;
798: END IF;
799: else
800: close c;
801: end if;

Line 805: FND_MSG_PUB.Count_And_Get

801: end if;
802: END IF;
803:
804: -- Standard call to get message count and if count is 1, get message info.
805: FND_MSG_PUB.Count_And_Get
806: ( p_count => x_msg_count,
807: p_data => x_msg_data
808: );
809:

Line 827: FND_MSG_PUB.initialize;

823: BEGIN
824: -- Initialize message list if p_init_msg_list is set to TRUE.
825: IF FND_API.to_Boolean( p_init_msg_list )
826: THEN
827: FND_MSG_PUB.initialize;
828: END IF;
829:
830: -- Initialize API return status to SUCCESS
831: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

830: -- Initialize API return status to SUCCESS
831: x_return_status := FND_API.G_RET_STS_SUCCESS;
832: IF (p_debrief_date is NULL OR p_debrief_date = FND_API.G_MISS_DATE) THEN
833: x_return_status := FND_API.G_RET_STS_ERROR;
834: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
835: THEN
836: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_DEBRIEF_DATE');
837: FND_MSG_PUB.ADD;
838: END IF;

Line 837: FND_MSG_PUB.ADD;

833: x_return_status := FND_API.G_RET_STS_ERROR;
834: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
835: THEN
836: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_DEBRIEF_DATE');
837: FND_MSG_PUB.ADD;
838: END IF;
839: END IF;
840:
841: -- Standard call to get message count and if count is 1, get message info.

Line 842: FND_MSG_PUB.Count_And_Get

838: END IF;
839: END IF;
840:
841: -- Standard call to get message count and if count is 1, get message info.
842: FND_MSG_PUB.Count_And_Get
843: ( p_count => x_msg_count,
844: p_data => x_msg_data
845: );
846: END Validate_Debrief_Date;

Line 1071: FND_MSG_PUB.initialize;

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

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

1379: fnd_api.g_miss_num and l_debrief_type = 'L' then
1380: if nvl(p_debrief_line_rec.labor_start_date,fnd_api.g_miss_date) = fnd_api.g_miss_date and
1381: nvl(p_debrief_line_rec.labor_end_date,fnd_api.g_miss_date) = fnd_api.g_miss_date then
1382: x_return_status := FND_API.G_RET_STS_ERROR;
1383: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1384: FND_MESSAGE.Set_Name('CSF', 'CSF_DEBRIEF_LABOR_DATES_ITEM');
1385: FND_MSG_PUB.ADD;
1386: END IF;
1387: RAISE fnd_api.g_exc_error;

Line 1385: FND_MSG_PUB.ADD;

1381: nvl(p_debrief_line_rec.labor_end_date,fnd_api.g_miss_date) = fnd_api.g_miss_date then
1382: x_return_status := FND_API.G_RET_STS_ERROR;
1383: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1384: FND_MESSAGE.Set_Name('CSF', 'CSF_DEBRIEF_LABOR_DATES_ITEM');
1385: FND_MSG_PUB.ADD;
1386: END IF;
1387: RAISE fnd_api.g_exc_error;
1388: end if;
1389: else

Line 1461: fnd_msg_pub.add;

1457: from CSF_DEBRIEF_LINES
1458: where DEBRIEF_LINE_ID = l_DEBRIEF_LINE_ID ;
1459:
1460: fnd_message.set_name('CSF', 'CSF_DEBRIEF_INVALID_LINE_ID');
1461: fnd_msg_pub.add;
1462: x_return_status := fnd_api.g_ret_sts_unexp_error;
1463: RAISE fnd_api.g_exc_unexpected_error;
1464: exception
1465: when no_data_found then

Line 1469: fnd_msg_pub.add;

1465: when no_data_found then
1466: null ;
1467: when too_many_rows then
1468: fnd_message.set_name('CSF', 'CSF_DEBRIEF_INVALID_LINE_ID');
1469: fnd_msg_pub.add;
1470: x_return_status := fnd_api.g_ret_sts_unexp_error;
1471: RAISE fnd_api.g_exc_unexpected_error;
1472: end ;
1473: ELSE

Line 1600: FND_MSG_PUB.ADD;

1596: );
1597: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1598: FND_MESSAGE.Set_Name('CSF', 'CSF_OVERLAP_LABOR_LINE');
1599: FND_MESSAGE.SET_TOKEN ('TASK_NUMBER', l_task_number);
1600: FND_MSG_PUB.ADD;
1601: RAISE fnd_api.g_exc_error;
1602: END IF;
1603: END IF;
1604: --Update actual times for task and task assignment

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

1711: END IF;
1712:
1713: EXCEPTION
1714: WHEN OTHERS THEN
1715: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1716: FND_MESSAGE.Set_Name('CSF', 'CSF_DEBRIEF_UPDATE_TASK_ASSIGNMENT');
1717: FND_MSG_PUB.ADD;
1718: END IF;
1719: RAISE FND_API.G_EXC_ERROR;

Line 1717: FND_MSG_PUB.ADD;

1713: EXCEPTION
1714: WHEN OTHERS THEN
1715: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1716: FND_MESSAGE.Set_Name('CSF', 'CSF_DEBRIEF_UPDATE_TASK_ASSIGNMENT');
1717: FND_MSG_PUB.ADD;
1718: END IF;
1719: RAISE FND_API.G_EXC_ERROR;
1720: END;
1721: end if;

Line 1753: FND_MSG_PUB.Count_And_Get

1749:
1750: END IF;
1751:
1752: -- Standard call to get message count and if count is 1, get message info.
1753: FND_MSG_PUB.Count_And_Get
1754: ( p_count => x_msg_count,
1755: p_data => x_msg_data
1756: );
1757: --dbms_output.put_line('Start of EXCEPTION Block');

Line 1762: FND_MSG_PUB.Count_And_Get (

1758: EXCEPTION
1759: WHEN FND_API.G_EXC_ERROR THEN
1760: ROLLBACK TO CREATE_DEBRIEF_LINE_PVT;
1761: x_return_status := FND_API.G_RET_STS_ERROR;
1762: FND_MSG_PUB.Count_And_Get (
1763: P_COUNT => X_MSG_COUNT
1764: ,P_DATA => X_MSG_DATA);
1765:
1766: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1769: FND_MSG_PUB.Count_And_Get (

1765:
1766: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1767: ROLLBACK TO CREATE_DEBRIEF_LINE_PVT;
1768: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1769: FND_MSG_PUB.Count_And_Get (
1770: P_COUNT => X_MSG_COUNT
1771: ,P_DATA => X_MSG_DATA);
1772: WHEN OTHERS THEN
1773: ROLLBACK TO CREATE_DEBRIEF_LINE_PVT;

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

1771: ,P_DATA => X_MSG_DATA);
1772: WHEN OTHERS THEN
1773: ROLLBACK TO CREATE_DEBRIEF_LINE_PVT;
1774: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1775: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1776: THEN
1777: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME ,L_API_NAME );
1778: END IF;
1779:

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

1773: ROLLBACK TO CREATE_DEBRIEF_LINE_PVT;
1774: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1775: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1776: THEN
1777: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME ,L_API_NAME );
1778: END IF;
1779:
1780: FND_MSG_PUB.Count_And_Get (
1781: P_COUNT => X_MSG_COUNT

Line 1780: FND_MSG_PUB.Count_And_Get (

1776: THEN
1777: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME ,L_API_NAME );
1778: END IF;
1779:
1780: FND_MSG_PUB.Count_And_Get (
1781: P_COUNT => X_MSG_COUNT
1782: ,P_DATA => X_MSG_DATA);
1783: End Create_debrief_lines;
1784:

Line 1808: FND_MSG_PUB.initialize;

1804: BEGIN
1805: -- Initialize message list if p_init_msg_list is set to TRUE.
1806: IF FND_API.to_Boolean( p_init_msg_list )
1807: THEN
1808: FND_MSG_PUB.initialize;
1809: END IF;
1810:
1811: -- Initialize API return status to SUCCESS
1812: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1811: -- Initialize API return status to SUCCESS
1812: x_return_status := FND_API.G_RET_STS_SUCCESS;
1813: IF (P_Task_Assignment_status is NULL OR P_Task_Assignment_status = FND_API.G_MISS_CHAR) THEN
1814: x_return_status := FND_API.G_RET_STS_ERROR;
1815: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1816: FND_MESSAGE.Set_Name('CSF', 'CSF_DEBRIEF_TA_STATUS');
1817: FND_MSG_PUB.ADD;
1818: END IF;
1819: ELSE

Line 1817: FND_MSG_PUB.ADD;

1813: IF (P_Task_Assignment_status is NULL OR P_Task_Assignment_status = FND_API.G_MISS_CHAR) THEN
1814: x_return_status := FND_API.G_RET_STS_ERROR;
1815: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1816: FND_MESSAGE.Set_Name('CSF', 'CSF_DEBRIEF_TA_STATUS');
1817: FND_MSG_PUB.ADD;
1818: END IF;
1819: ELSE
1820: open validate_ta_status;
1821: fetch validate_ta_status into X_TA_STATUS_ID;

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

1821: fetch validate_ta_status into X_TA_STATUS_ID;
1822: if validate_ta_status%notfound then
1823: close validate_ta_status ;
1824: x_return_status := FND_API.G_RET_STS_ERROR;
1825: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1826: FND_MESSAGE.Set_Name('CSF', 'CSF_DEBRIEF_TAvalvav_STATUS');
1827: FND_MSG_PUB.ADD;
1828: END IF;
1829: end if;

Line 1827: FND_MSG_PUB.ADD;

1823: close validate_ta_status ;
1824: x_return_status := FND_API.G_RET_STS_ERROR;
1825: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1826: FND_MESSAGE.Set_Name('CSF', 'CSF_DEBRIEF_TAvalvav_STATUS');
1827: FND_MSG_PUB.ADD;
1828: END IF;
1829: end if;
1830: close validate_ta_status ;
1831: END IF;

Line 1834: FND_MSG_PUB.Count_And_Get

1830: close validate_ta_status ;
1831: END IF;
1832:
1833: -- Standard call to get message count and if count is 1, get message info.
1834: FND_MSG_PUB.Count_And_Get
1835: ( p_count => x_msg_count,
1836: p_data => x_msg_data
1837: );
1838: END Validate_Task_Assignment_Satus;

Line 1972: FND_MSG_PUB.initialize;

1968: END IF;
1969:
1970: IF FND_API.to_Boolean( p_init_msg_list )
1971: THEN
1972: FND_MSG_PUB.initialize;
1973: END IF;
1974:
1975: -- Initialize API return status to SUCCESS
1976: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1982: open GET_CHARGE_UPLOAD_STATUS(l_DEBRIEF_LINE_ID);
1983: fetch GET_CHARGE_UPLOAD_STATUS into l_charge_upload_status, l_ib_upload_status, l_spare_upload_status, l_labor_start_date;
1984: if GET_CHARGE_UPLOAD_STATUS%notfound then
1985: close GET_CHARGE_UPLOAD_STATUS;
1986: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1987: THEN
1988: FND_MESSAGE.Set_Name('CSF', 'CSF_DEBRIEF_INVALID_LINE_ID');
1989: FND_MSG_PUB.Add;
1990:

Line 1989: FND_MSG_PUB.Add;

1985: close GET_CHARGE_UPLOAD_STATUS;
1986: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1987: THEN
1988: FND_MESSAGE.Set_Name('CSF', 'CSF_DEBRIEF_INVALID_LINE_ID');
1989: FND_MSG_PUB.Add;
1990:
1991: END IF;
1992: raise FND_API.G_EXC_ERROR;
1993: end if;

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

2004: end if;
2005: IF l_charge_upload_status='SUCCEEDED' or
2006: l_ib_upload_status ='SUCCEEDED' or
2007: l_spare_upload_status ='SUCCEEDED' then
2008: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2009: THEN
2010: FND_MESSAGE.Set_Name('CSF', 'CSF_DEBRIEF_CHARGE_UPLOADED');
2011: FND_MSG_PUB.Add;
2012: x_return_status := 'E';

Line 2011: FND_MSG_PUB.Add;

2007: l_spare_upload_status ='SUCCEEDED' then
2008: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2009: THEN
2010: FND_MESSAGE.Set_Name('CSF', 'CSF_DEBRIEF_CHARGE_UPLOADED');
2011: FND_MSG_PUB.Add;
2012: x_return_status := 'E';
2013: END IF;
2014: ELSE
2015: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

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

2029: 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
2030: if nvl(p_debrief_line_rec.labor_start_date,fnd_api.g_miss_date) = fnd_api.g_miss_date and
2031: nvl(p_debrief_line_rec.labor_end_date,fnd_api.g_miss_date) = fnd_api.g_miss_date then
2032: x_return_status := FND_API.G_RET_STS_ERROR;
2033: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2034: FND_MESSAGE.Set_Name('CSF', 'CSF_DEBRIEF_LABOR_DATES_ITEM');
2035: FND_MSG_PUB.ADD;
2036: END IF;
2037: RAISE fnd_api.g_exc_error;

Line 2035: FND_MSG_PUB.ADD;

2031: nvl(p_debrief_line_rec.labor_end_date,fnd_api.g_miss_date) = fnd_api.g_miss_date then
2032: x_return_status := FND_API.G_RET_STS_ERROR;
2033: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2034: FND_MESSAGE.Set_Name('CSF', 'CSF_DEBRIEF_LABOR_DATES_ITEM');
2035: FND_MSG_PUB.ADD;
2036: END IF;
2037: RAISE fnd_api.g_exc_error;
2038: end if;
2039: else

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

2378: END IF;
2379:
2380: EXCEPTION
2381: WHEN OTHERS THEN
2382: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2383: FND_MESSAGE.Set_Name('CSF', 'CSF_DEBRIEF_UPDATE_TASK_ASSIGNMENT');
2384: FND_MSG_PUB.ADD;
2385: END IF;
2386: RAISE FND_API.G_EXC_ERROR;

Line 2384: FND_MSG_PUB.ADD;

2380: EXCEPTION
2381: WHEN OTHERS THEN
2382: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2383: FND_MESSAGE.Set_Name('CSF', 'CSF_DEBRIEF_UPDATE_TASK_ASSIGNMENT');
2384: FND_MSG_PUB.ADD;
2385: END IF;
2386: RAISE FND_API.G_EXC_ERROR;
2387: END;
2388: end if;

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

2408: COMMIT WORK;
2409: END IF;
2410:
2411: -- Debug Message
2412: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
2413: THEN
2414: FND_MESSAGE.Set_Name('CSF', l_api_name);
2415: FND_MESSAGE.Set_Token ('INFO', G_PKG_NAME, FALSE);
2416: FND_MSG_PUB.Add;

Line 2416: FND_MSG_PUB.Add;

2412: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
2413: THEN
2414: FND_MESSAGE.Set_Name('CSF', l_api_name);
2415: FND_MESSAGE.Set_Token ('INFO', G_PKG_NAME, FALSE);
2416: FND_MSG_PUB.Add;
2417: END IF;
2418:
2419: -- Standard call to get message count and if count is 1, get message info.
2420: FND_MSG_PUB.Count_And_Get

Line 2420: FND_MSG_PUB.Count_And_Get

2416: FND_MSG_PUB.Add;
2417: END IF;
2418:
2419: -- Standard call to get message count and if count is 1, get message info.
2420: FND_MSG_PUB.Count_And_Get
2421: ( p_count => x_msg_count,
2422: p_data => x_msg_data
2423: );
2424: end if; -- if charge_upload_status='INTERFACED'

Line 2429: FND_MSG_PUB.Count_And_Get (

2425: EXCEPTION
2426: WHEN FND_API.G_EXC_ERROR THEN
2427: ROLLBACK TO UPDATE_DEBRIEF_LINE_PVT;
2428: x_return_status := FND_API.G_RET_STS_ERROR;
2429: FND_MSG_PUB.Count_And_Get (
2430: P_COUNT => X_MSG_COUNT
2431: ,P_DATA => X_MSG_DATA);
2432:
2433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2436: FND_MSG_PUB.Count_And_Get (

2432:
2433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2434: ROLLBACK TO UPDATE_DEBRIEF_LINE_PVT;
2435: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2436: FND_MSG_PUB.Count_And_Get (
2437: P_COUNT => X_MSG_COUNT
2438: ,P_DATA => X_MSG_DATA);
2439:
2440: WHEN OTHERS THEN

Line 2443: IF FND_MSG_PUB.Check_Msg_Level

2439:
2440: WHEN OTHERS THEN
2441: ROLLBACK TO UPDATE_DEBRIEF_LINE_PVT;
2442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2443: IF FND_MSG_PUB.Check_Msg_Level
2444: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2445: THEN
2446: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME ,L_API_NAME );
2447: END IF;

Line 2444: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2440: WHEN OTHERS THEN
2441: ROLLBACK TO UPDATE_DEBRIEF_LINE_PVT;
2442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2443: IF FND_MSG_PUB.Check_Msg_Level
2444: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2445: THEN
2446: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME ,L_API_NAME );
2447: END IF;
2448:

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

2442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2443: IF FND_MSG_PUB.Check_Msg_Level
2444: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2445: THEN
2446: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME ,L_API_NAME );
2447: END IF;
2448:
2449: FND_MSG_PUB.Count_And_Get (
2450: P_COUNT => X_MSG_COUNT

Line 2449: FND_MSG_PUB.Count_And_Get (

2445: THEN
2446: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME ,L_API_NAME );
2447: END IF;
2448:
2449: FND_MSG_PUB.Count_And_Get (
2450: P_COUNT => X_MSG_COUNT
2451: ,P_DATA => X_MSG_DATA);
2452:
2453: End Update_debrief_line;

Line 2469: FND_MSG_PUB.initialize;

2465: log('Validate_Service_Date' ,'P_Service_Date=' || P_Service_Date);
2466: -- Initialize message list if p_init_msg_list is set to TRUE.
2467: IF FND_API.to_Boolean( p_init_msg_list )
2468: THEN
2469: FND_MSG_PUB.initialize;
2470: END IF;
2471:
2472: -- Initialize API return status to SUCCESS
2473: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

2472: -- Initialize API return status to SUCCESS
2473: x_return_status := FND_API.G_RET_STS_SUCCESS;
2474: IF (p_service_date is NULL OR p_service_date = FND_API.G_MISS_DATE) THEN
2475: x_return_status := FND_API.G_RET_STS_ERROR;
2476: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2477: FND_MESSAGE.Set_Name('CSF', 'CSF_DEBRIEF_SERVICE_DATE');
2478: FND_MSG_PUB.ADD;
2479: END IF;
2480: END IF;

Line 2478: FND_MSG_PUB.ADD;

2474: IF (p_service_date is NULL OR p_service_date = FND_API.G_MISS_DATE) THEN
2475: x_return_status := FND_API.G_RET_STS_ERROR;
2476: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2477: FND_MESSAGE.Set_Name('CSF', 'CSF_DEBRIEF_SERVICE_DATE');
2478: FND_MSG_PUB.ADD;
2479: END IF;
2480: END IF;
2481:
2482: -- Standard call to get message count and if count is 1, get message info.

Line 2483: FND_MSG_PUB.Count_And_Get

2479: END IF;
2480: END IF;
2481:
2482: -- Standard call to get message count and if count is 1, get message info.
2483: FND_MSG_PUB.Count_And_Get
2484: ( p_count => x_msg_count,
2485: p_data => x_msg_data
2486: );
2487:

Line 2515: FND_MSG_PUB.initialize;

2511: BEGIN
2512: -- Initialize message list if p_init_msg_list is set to TRUE.
2513: IF FND_API.to_Boolean( p_init_msg_list )
2514: THEN
2515: FND_MSG_PUB.initialize;
2516: END IF;
2517:
2518: -- Initialize API return status to SUCCESS
2519: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

2521: fetch c_subinventory_code into l_organization_code,l_subinventory_code;
2522: close c_subinventory_code;
2523: IF l_subinventory_code is NULL THEN
2524: x_return_status := FND_API.G_RET_STS_ERROR;
2525: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2526: FND_MESSAGE.Set_Name('CSP', 'CSP_INVALID_ORG_SUBINV');
2527: FND_MESSAGE.set_token('ORG',l_organization_code,TRUE);
2528: FND_MESSAGE.set_token('SUBINV',l_subinventory_code,TRUE);
2529: FND_MSG_PUB.ADD;

Line 2529: FND_MSG_PUB.ADD;

2525: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2526: FND_MESSAGE.Set_Name('CSP', 'CSP_INVALID_ORG_SUBINV');
2527: FND_MESSAGE.set_token('ORG',l_organization_code,TRUE);
2528: FND_MESSAGE.set_token('SUBINV',l_subinventory_code,TRUE);
2529: FND_MSG_PUB.ADD;
2530: END IF;
2531: END IF;
2532:
2533: -- Standard call to get message count and if count is 1, get message info.

Line 2534: FND_MSG_PUB.Count_And_Get

2530: END IF;
2531: END IF;
2532:
2533: -- Standard call to get message count and if count is 1, get message info.
2534: FND_MSG_PUB.Count_And_Get
2535: ( p_count => x_msg_count,
2536: p_data => x_msg_data);
2537:
2538: END validate_subinventory_code;

Line 2560: FND_MSG_PUB.initialize;

2556: BEGIN
2557: -- Initialize message list if p_init_msg_list is set to TRUE.
2558: IF FND_API.to_Boolean( p_init_msg_list )
2559: THEN
2560: FND_MSG_PUB.initialize;
2561: END IF;
2562:
2563: -- Initialize API return status to SUCCESS
2564: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

2567: fetch c_inventory_item into l_inventory_item_id;
2568: close c_inventory_item;
2569: IF l_inventory_item_id is null THEN
2570: x_return_status := FND_API.G_RET_STS_ERROR;
2571: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2572: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_INVENTORY_ITEM_ID');
2573: FND_MSG_PUB.ADD;
2574: END IF;
2575: END IF;

Line 2573: FND_MSG_PUB.ADD;

2569: IF l_inventory_item_id is null THEN
2570: x_return_status := FND_API.G_RET_STS_ERROR;
2571: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2572: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_INVENTORY_ITEM_ID');
2573: FND_MSG_PUB.ADD;
2574: END IF;
2575: END IF;
2576: -- Standard call to get message count and if count is 1, get message info.
2577: FND_MSG_PUB.Count_And_Get

Line 2577: FND_MSG_PUB.Count_And_Get

2573: FND_MSG_PUB.ADD;
2574: END IF;
2575: END IF;
2576: -- Standard call to get message count and if count is 1, get message info.
2577: FND_MSG_PUB.Count_And_Get
2578: ( p_count => x_msg_count,
2579: p_data => x_msg_data
2580: );
2581:

Line 2604: FND_MSG_PUB.initialize;

2600:
2601: -- Initialize message list if p_init_msg_list is set to TRUE.
2602: IF FND_API.to_Boolean( p_init_msg_list )
2603: THEN
2604: FND_MSG_PUB.initialize;
2605: END IF;
2606:
2607: -- Initialize API return status to SUCCESS
2608: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

2611: fetch get_instance_id into l_dummy;
2612: if get_instance_id%notfound then
2613: close get_instance_id;
2614: x_return_status := FND_API.G_RET_STS_ERROR;
2615: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2616: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_INSTANCE_ID');
2617: FND_MSG_PUB.ADD;
2618: END IF;
2619: end if;

Line 2617: FND_MSG_PUB.ADD;

2613: close get_instance_id;
2614: x_return_status := FND_API.G_RET_STS_ERROR;
2615: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2616: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_INSTANCE_ID');
2617: FND_MSG_PUB.ADD;
2618: END IF;
2619: end if;
2620: close get_instance_id;
2621: END IF;

Line 2624: FND_MSG_PUB.Count_And_Get

2620: close get_instance_id;
2621: END IF;
2622:
2623: -- Standard call to get message count and if count is 1, get message info.
2624: FND_MSG_PUB.Count_And_Get
2625: ( p_count => x_msg_count,
2626: p_data => x_msg_data
2627: );
2628: END Validate_Instance_ID;

Line 2648: FND_MSG_PUB.initialize;

2644:
2645: -- Initialize message list if p_init_msg_list is set to TRUE.
2646: IF FND_API.to_Boolean( p_init_msg_list )
2647: THEN
2648: FND_MSG_PUB.initialize;
2649: END IF;
2650:
2651: -- Initialize API return status to SUCCESS
2652: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

2651: -- Initialize API return status to SUCCESS
2652: x_return_status := FND_API.G_RET_STS_SUCCESS;
2653: IF (P_DEBRIEF_HEADER_ID is NULL OR P_DEBRIEF_HEADER_ID = FND_API.G_MISS_NUM) THEN
2654: x_return_status := FND_API.G_RET_STS_ERROR;
2655: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2656: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_HEADER_ID');
2657: FND_MSG_PUB.ADD;
2658: END IF;
2659: ELSE

Line 2657: FND_MSG_PUB.ADD;

2653: IF (P_DEBRIEF_HEADER_ID is NULL OR P_DEBRIEF_HEADER_ID = FND_API.G_MISS_NUM) THEN
2654: x_return_status := FND_API.G_RET_STS_ERROR;
2655: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2656: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_HEADER_ID');
2657: FND_MSG_PUB.ADD;
2658: END IF;
2659: ELSE
2660: open validate_header_id;
2661: fetch validate_header_id into l_dummy;

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

2661: fetch validate_header_id into l_dummy;
2662: if validate_header_id%notfound then
2663: -- close validate_header_id;
2664: x_return_status := FND_API.G_RET_STS_ERROR;
2665: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2666: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_HEADER_ID');
2667: FND_MSG_PUB.ADD;
2668: END IF;
2669: end if;

Line 2667: FND_MSG_PUB.ADD;

2663: -- close validate_header_id;
2664: x_return_status := FND_API.G_RET_STS_ERROR;
2665: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2666: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_HEADER_ID');
2667: FND_MSG_PUB.ADD;
2668: END IF;
2669: end if;
2670: close validate_header_id ;
2671: END IF;

Line 2673: FND_MSG_PUB.Count_And_Get

2669: end if;
2670: close validate_header_id ;
2671: END IF;
2672: -- Standard call to get message count and if count is 1, get message info.
2673: FND_MSG_PUB.Count_And_Get
2674: ( p_count => x_msg_count,
2675: p_data => x_msg_data
2676: );
2677:

Line 2696: FND_MSG_PUB.initialize;

2692: BEGIN
2693: -- Initialize message list if p_init_msg_list is set to TRUE.
2694: IF FND_API.to_Boolean( p_init_msg_list )
2695: THEN
2696: FND_MSG_PUB.initialize;
2697: END IF;
2698:
2699: -- Initialize API return status to SUCCESS
2700: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

2700: x_return_status := FND_API.G_RET_STS_SUCCESS;
2701: IF(p_validation_mode = G_CREATE) THEN
2702: IF (p_debrief_line_number is NULL OR p_debrief_line_number = FND_API.G_MISS_NUM ) THEN
2703: x_return_status := FND_API.G_RET_STS_ERROR;
2704: ELSIF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2705: THEN
2706: FND_MESSAGE.Set_Name('CSF', l_api_name);
2707: FND_MESSAGE.Set_Token('COLUMN', 'DEBRIEF_LINE_NUMBER', FALSE);
2708: FND_MSG_PUB.ADD;

Line 2708: FND_MSG_PUB.ADD;

2704: ELSIF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2705: THEN
2706: FND_MESSAGE.Set_Name('CSF', l_api_name);
2707: FND_MESSAGE.Set_Token('COLUMN', 'DEBRIEF_LINE_NUMBER', FALSE);
2708: FND_MSG_PUB.ADD;
2709: END IF;
2710: END IF;
2711:
2712: -- Standard call to get message count and if count is 1, get message info.

Line 2713: FND_MSG_PUB.Count_And_Get

2709: END IF;
2710: END IF;
2711:
2712: -- Standard call to get message count and if count is 1, get message info.
2713: FND_MSG_PUB.Count_And_Get
2714: ( p_count => x_msg_count,
2715: p_data => x_msg_data
2716: );
2717:

Line 2737: FND_MSG_PUB.initialize;

2733: BEGIN
2734: -- Initialize message list if p_init_msg_list is set to TRUE.
2735: IF FND_API.to_Boolean( p_init_msg_list )
2736: THEN
2737: FND_MSG_PUB.initialize;
2738: END IF;
2739:
2740: -- Initialize API return status to SUCCESS
2741: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

2740: -- Initialize API return status to SUCCESS
2741: x_return_status := FND_API.G_RET_STS_SUCCESS;
2742: IF (p_business_process_id is NULL OR p_business_process_id = FND_API.G_MISS_NUM ) THEN
2743: x_return_status := FND_API.G_RET_STS_ERROR;
2744: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2745: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_BUS_PROCESS_ID');
2746: FND_MSG_PUB.ADD;
2747: END IF;
2748: ELSE

Line 2746: FND_MSG_PUB.ADD;

2742: IF (p_business_process_id is NULL OR p_business_process_id = FND_API.G_MISS_NUM ) THEN
2743: x_return_status := FND_API.G_RET_STS_ERROR;
2744: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2745: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_BUS_PROCESS_ID');
2746: FND_MSG_PUB.ADD;
2747: END IF;
2748: ELSE
2749: open get_business_process_id;
2750: fetch get_business_process_id into l_dummy;

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

2750: fetch get_business_process_id into l_dummy;
2751: if get_business_process_id%notfound then
2752: close get_business_process_id;
2753: x_return_status := FND_API.G_RET_STS_ERROR;
2754: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2755: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_BUS_PROCESS_ID');
2756: FND_MSG_PUB.ADD;
2757: END IF;
2758: end if;

Line 2756: FND_MSG_PUB.ADD;

2752: close get_business_process_id;
2753: x_return_status := FND_API.G_RET_STS_ERROR;
2754: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2755: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_BUS_PROCESS_ID');
2756: FND_MSG_PUB.ADD;
2757: END IF;
2758: end if;
2759: close get_business_process_id;
2760: END IF;

Line 2763: FND_MSG_PUB.Count_And_Get

2759: close get_business_process_id;
2760: END IF;
2761:
2762: -- Standard call to get message count and if count is 1, get message info.
2763: FND_MSG_PUB.Count_And_Get
2764: ( p_count => x_msg_count,
2765: p_data => x_msg_data
2766: );
2767: END Validate_BUSINESS_PROCESS_ID;

Line 2785: FND_MSG_PUB.initialize;

2781: BEGIN
2782: -- Initialize message list if p_init_msg_list is set to TRUE.
2783: IF FND_API.to_Boolean( p_init_msg_list )
2784: THEN
2785: FND_MSG_PUB.initialize;
2786: END IF;
2787:
2788: -- Initialize API return status to SUCCESS
2789: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

2788: -- Initialize API return status to SUCCESS
2789: x_return_status := FND_API.G_RET_STS_SUCCESS;
2790: IF (p_transaction_type_id is NULL OR p_transaction_type_id = FND_API.G_MISS_NUM ) THEN
2791: x_return_status := FND_API.G_RET_STS_ERROR;
2792: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2793: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_TXN_BILLING_TYP_ID');
2794: FND_MSG_PUB.ADD;
2795: END IF;
2796: ELSE

Line 2794: FND_MSG_PUB.ADD;

2790: IF (p_transaction_type_id is NULL OR p_transaction_type_id = FND_API.G_MISS_NUM ) THEN
2791: x_return_status := FND_API.G_RET_STS_ERROR;
2792: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2793: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_TXN_BILLING_TYP_ID');
2794: FND_MSG_PUB.ADD;
2795: END IF;
2796: ELSE
2797: open get_transaction_type_id;
2798: fetch get_transaction_type_id into l_dummy;

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

2798: fetch get_transaction_type_id into l_dummy;
2799: if get_transaction_type_id%notfound then
2800: close get_transaction_type_id;
2801: x_return_status := FND_API.G_RET_STS_ERROR;
2802: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2803: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_TXN_BILLING_TYP_ID');
2804: FND_MSG_PUB.ADD;
2805: END IF;
2806: end if;

Line 2804: FND_MSG_PUB.ADD;

2800: close get_transaction_type_id;
2801: x_return_status := FND_API.G_RET_STS_ERROR;
2802: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2803: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_TXN_BILLING_TYP_ID');
2804: FND_MSG_PUB.ADD;
2805: END IF;
2806: end if;
2807: close get_transaction_type_id;
2808: END IF;

Line 2811: FND_MSG_PUB.Count_And_Get

2807: close get_transaction_type_id;
2808: END IF;
2809:
2810: -- Standard call to get message count and if count is 1, get message info.
2811: FND_MSG_PUB.Count_And_Get
2812: ( p_count => x_msg_count,
2813: p_data => x_msg_data
2814: );
2815: END Validate_TRANSACTION_TYPE_ID;

Line 2860: FND_MSG_PUB.initialize;

2856:
2857: -- Initialize message list if p_init_msg_list is set to TRUE.
2858: IF FND_API.to_Boolean( p_init_msg_list )
2859: THEN
2860: FND_MSG_PUB.initialize;
2861: END IF;
2862:
2863: -- Initialize API return status to SUCCESS
2864: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

2897: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2898: RAISE FND_API.G_EXC_ERROR;
2899: END IF;
2900:
2901: FND_MSG_PUB.GET(P_MSG_INDEX=>1,
2902: P_ENCODED=>'F',
2903: p_data=>l_msg_data,
2904: p_MSG_index_out=>l_msg_index_out);
2905:

Line 2950: FND_MSG_PUB.Count_And_Get (

2946: EXCEPTION
2947: WHEN FND_API.G_EXC_ERROR THEN
2948: ROLLBACK TO CREATE_INTERACTION;
2949: x_return_status := FND_API.G_RET_STS_ERROR;
2950: FND_MSG_PUB.Count_And_Get (
2951: P_COUNT => X_MSG_COUNT
2952: ,P_DATA => X_MSG_DATA);
2953:
2954: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2957: FND_MSG_PUB.Count_And_Get (

2953:
2954: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2955: ROLLBACK TO CREATE_INTERACTION;
2956: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2957: FND_MSG_PUB.Count_And_Get (
2958: P_COUNT => X_MSG_COUNT
2959: ,P_DATA => X_MSG_DATA);
2960:
2961: WHEN OTHERS THEN

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

2960:
2961: WHEN OTHERS THEN
2962: ROLLBACK TO CREATE_INTERACTION;
2963: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2964: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2965: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,L_API_NAME);
2966: END IF;
2967: FND_MSG_PUB.Count_And_Get (
2968: P_COUNT => X_MSG_COUNT

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

2961: WHEN OTHERS THEN
2962: ROLLBACK TO CREATE_INTERACTION;
2963: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2964: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2965: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,L_API_NAME);
2966: END IF;
2967: FND_MSG_PUB.Count_And_Get (
2968: P_COUNT => X_MSG_COUNT
2969: ,P_DATA => X_MSG_DATA);

Line 2967: FND_MSG_PUB.Count_And_Get (

2963: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2964: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2965: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,L_API_NAME);
2966: END IF;
2967: FND_MSG_PUB.Count_And_Get (
2968: P_COUNT => X_MSG_COUNT
2969: ,P_DATA => X_MSG_DATA);
2970:
2971: END;

Line 3303: FND_MSG_PUB.ADD;

3299: if l_old_resource_type <> l_new_resource_type or
3300: l_old_resource_id <> l_new_resource_id then
3301: x_return_status := FND_API.G_RET_STS_ERROR;
3302: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_EXISTS');
3303: FND_MSG_PUB.ADD;
3304: end if;
3305: end if;
3306:
3307: exception

Line 3326: FND_MSG_PUB.ADD;

3322:
3323: if l_debrief_header_id is not null then
3324: x_return_status := FND_API.G_RET_STS_ERROR;
3325: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_EXISTS');
3326: FND_MSG_PUB.ADD;
3327: end if;
3328:
3329: exception
3330: when others then

Line 3706: FND_MSG_PUB.initialize;

3702: where cdh.task_assignment_id = p_task_assignment_id
3703: and cdh.debrief_header_id = cdl.debrief_header_id;
3704:
3705: BEGIN
3706: FND_MSG_PUB.initialize;
3707: -- Initialize API return status to SUCCESS
3708: x_return_status := FND_API.G_RET_STS_SUCCESS;
3709: open get_debrief_status;
3710: fetch get_debrief_status into l_processed_flag;

Line 3717: FND_MSG_PUB.ADD;

3713: x_return_status := FND_API.G_RET_STS_SUCCESS;
3714: else
3715: x_return_status := FND_API.G_RET_STS_ERROR;
3716: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_PENDING');
3717: FND_MSG_PUB.ADD;
3718: end if;
3719: -- Standard call to get message count and if count is 1, get message info.
3720: FND_MSG_PUB.Count_And_Get
3721: ( p_count => x_msg_count,

Line 3720: FND_MSG_PUB.Count_And_Get

3716: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_PENDING');
3717: FND_MSG_PUB.ADD;
3718: end if;
3719: -- Standard call to get message count and if count is 1, get message info.
3720: FND_MSG_PUB.Count_And_Get
3721: ( p_count => x_msg_count,
3722: p_data => x_msg_data);
3723: END CLOSE_DEBRIEF;
3724:

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

4270: or p_actual_travel_start_time = FND_API.g_miss_date)
4271: and (p_actual_travel_end_time <> FND_API.g_miss_date
4272: and p_actual_travel_end_time IS NOT NULL) THEN
4273: X_Return_Status := FND_API.G_RET_STS_ERROR;
4274: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4275: FND_MESSAGE.Set_Name('CSF','CSF_TRAVEL_START_TIME');
4276: FND_MSG_PUB.ADD;
4277: END IF;
4278: END IF;

Line 4276: FND_MSG_PUB.ADD;

4272: and p_actual_travel_end_time IS NOT NULL) THEN
4273: X_Return_Status := FND_API.G_RET_STS_ERROR;
4274: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4275: FND_MESSAGE.Set_Name('CSF','CSF_TRAVEL_START_TIME');
4276: FND_MSG_PUB.ADD;
4277: END IF;
4278: END IF;
4279:
4280: If (p_actual_travel_start_time IS NOT NULL

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

4282: and p_actual_travel_start_time <> FND_API.g_miss_date
4283: and p_actual_travel_end_time <> FND_API.g_miss_date
4284: AND p_actual_travel_start_time > p_actual_travel_end_time) THEN
4285: X_Return_Status := FND_API.G_RET_STS_ERROR;
4286: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4287: FND_MESSAGE.Set_Name('CSF','CSF_TRAVEL_START_AFTER_END');
4288: FND_MSG_PUB.ADD;
4289: END IF;
4290: END IF;

Line 4288: FND_MSG_PUB.ADD;

4284: AND p_actual_travel_start_time > p_actual_travel_end_time) THEN
4285: X_Return_Status := FND_API.G_RET_STS_ERROR;
4286: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4287: FND_MESSAGE.Set_Name('CSF','CSF_TRAVEL_START_AFTER_END');
4288: FND_MSG_PUB.ADD;
4289: END IF;
4290: END IF;
4291:
4292: If p_actual_travel_start_time IS NOT NULL

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

4297: > trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
4298: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
4299: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')))) THEN
4300: X_Return_Status := FND_API.G_RET_STS_ERROR;
4301: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4302: FND_MESSAGE.Set_Name('CSF','CSF_TRAVEL_START_CURR_DATE');
4303: FND_MSG_PUB.ADD;
4304: END IF;
4305: END IF;

Line 4303: FND_MSG_PUB.ADD;

4299: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')))) THEN
4300: X_Return_Status := FND_API.G_RET_STS_ERROR;
4301: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4302: FND_MESSAGE.Set_Name('CSF','CSF_TRAVEL_START_CURR_DATE');
4303: FND_MSG_PUB.ADD;
4304: END IF;
4305: END IF;
4306: If p_actual_travel_end_time IS NOT NULL
4307: and p_actual_travel_end_time <> FND_API.g_miss_date

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

4311: > trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
4312: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
4313: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')))) THEN
4314: X_Return_Status := FND_API.G_RET_STS_ERROR;
4315: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4316: FND_MESSAGE.Set_Name('CSF','CSF_TRAVEL_END_CURR_DATE');
4317: FND_MSG_PUB.ADD;
4318: END IF;
4319: END IF;

Line 4317: FND_MSG_PUB.ADD;

4313: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')))) THEN
4314: X_Return_Status := FND_API.G_RET_STS_ERROR;
4315: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4316: FND_MESSAGE.Set_Name('CSF','CSF_TRAVEL_END_CURR_DATE');
4317: FND_MSG_PUB.ADD;
4318: END IF;
4319: END IF;
4320:
4321: If (p_actual_travel_start_time IS NOT NULL

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

4321: If (p_actual_travel_start_time IS NOT NULL
4322: and p_actual_travel_start_time <> FND_API.g_miss_date
4323: and p_actual_travel_start_time < l_service_request_date) THEN
4324: X_Return_Status := FND_API.G_RET_STS_ERROR;
4325: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4326: FND_MESSAGE.Set_Name('CSF','CSF_TRAVEL_START_SR_DATE');
4327: FND_MSG_PUB.ADD;
4328: END IF;
4329: END IF;

Line 4327: FND_MSG_PUB.ADD;

4323: and p_actual_travel_start_time < l_service_request_date) THEN
4324: X_Return_Status := FND_API.G_RET_STS_ERROR;
4325: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4326: FND_MESSAGE.Set_Name('CSF','CSF_TRAVEL_START_SR_DATE');
4327: FND_MSG_PUB.ADD;
4328: END IF;
4329: END IF;
4330: If (p_actual_travel_end_time IS NOT NULL
4331: and p_actual_travel_end_time <> FND_API.g_miss_date

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

4330: If (p_actual_travel_end_time IS NOT NULL
4331: and p_actual_travel_end_time <> FND_API.g_miss_date
4332: and p_actual_travel_end_time < l_service_request_date) THEN
4333: X_Return_Status := FND_API.G_RET_STS_ERROR;
4334: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4335: FND_MESSAGE.Set_Name('CSF','CSF_TRAVEL_END_SR_DATE');
4336: FND_MSG_PUB.ADD;
4337: END IF;
4338: END IF;

Line 4336: FND_MSG_PUB.ADD;

4332: and p_actual_travel_end_time < l_service_request_date) THEN
4333: X_Return_Status := FND_API.G_RET_STS_ERROR;
4334: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4335: FND_MESSAGE.Set_Name('CSF','CSF_TRAVEL_END_SR_DATE');
4336: FND_MSG_PUB.ADD;
4337: END IF;
4338: END IF;
4339: END;
4340: