eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CS_SR_WORKITEM_PVT dependencies on FND_API

Line 7: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

3:
4:
5: PROCEDURE Create_Workitem(
6: p_api_version IN NUMBER,
7: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
8: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
9: p_incident_id IN NUMBER,
10: p_incident_number IN VARCHAR2,
11: p_sr_rec IN CS_ServiceRequest_PVT.service_request_rec_type,

Line 8: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

4:
5: PROCEDURE Create_Workitem(
6: p_api_version IN NUMBER,
7: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
8: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
9: p_incident_id IN NUMBER,
10: p_incident_number IN VARCHAR2,
11: p_sr_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
12: --p_owner_group_id IN NUMBER DEFAULT NULL,

Line 71: x_return_status := FND_API.G_RET_STS_SUCCESS;

67:
68: --dbms_output.put_line('owner_group_id:' || p_sr_rec.owner_group_id );
69: --dbms_output.put_line('owner_group_type:' || p_sr_rec.group_type );
70:
71: x_return_status := FND_API.G_RET_STS_SUCCESS;
72:
73: -- First thing to do is check if user wants to use UWQ assignment.
74: -- See if service request as a work source is activated.
75:

Line 78: p_init_msg_list => fnd_api.g_false,

74: -- See if service request as a work source is activated.
75:
76: IEU_WR_PUB.CHECK_WS_ACTIVATION_STATUS
77: ( p_api_version => 1.0,
78: p_init_msg_list => fnd_api.g_false,
79: p_commit => fnd_api.g_false,
80: p_ws_code => 'SR',
81: x_ws_activation_status => l_sr_activation_status,
82: x_msg_count => x_msg_count,

Line 79: p_commit => fnd_api.g_false,

75:
76: IEU_WR_PUB.CHECK_WS_ACTIVATION_STATUS
77: ( p_api_version => 1.0,
78: p_init_msg_list => fnd_api.g_false,
79: p_commit => fnd_api.g_false,
80: p_ws_code => 'SR',
81: x_ws_activation_status => l_sr_activation_status,
82: x_msg_count => x_msg_count,
83: x_msg_data => x_msg_data,

Line 86: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

82: x_msg_count => x_msg_count,
83: x_msg_data => x_msg_data,
84: x_return_status => l_return_status);
85:
86: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
87: l_sr_activation_status := 'N' ;
88: END IF;
89: IF (NVL(l_sr_activation_status,'N') = 'Y') THEN
90:

Line 114: IF (p_sr_rec.group_type = FND_API.G_MISS_CHAR) THEN

110: --dbms_output.put_line('Owner Type :'||p_sr_rec.resource_type);
111: --dbms_output.put_line('Owner Group Type :'||p_sr_rec.group_type);
112: --dbms_output.put_line('Owner Group ID :'||p_sr_rec.owner_group_id);
113:
114: IF (p_sr_rec.group_type = FND_API.G_MISS_CHAR) THEN
115: l_owner_group_type := NULL;
116: ELSE
117: l_owner_group_type := p_sr_rec.group_type;
118: END IF;

Line 120: IF (p_sr_rec.owner_group_id = FND_API.G_MISS_NUM) THEN

116: ELSE
117: l_owner_group_type := p_sr_rec.group_type;
118: END IF;
119:
120: IF (p_sr_rec.owner_group_id = FND_API.G_MISS_NUM) THEN
121: l_owner_group_id := NULL;
122: l_owner_group_type := NULL;
123: ELSIF p_sr_rec.owner_group_id IS NULL THEN
124: l_owner_group_id := NULL;

Line 130: IF (p_sr_rec.resource_type = FND_API.G_MISS_CHAR) THEN

126: ELSE
127: l_owner_group_id := p_sr_rec.owner_group_id;
128: END IF;
129:
130: IF (p_sr_rec.resource_type = FND_API.G_MISS_CHAR) THEN
131: l_individual_owner_type := NULL;
132: ELSE
133: l_individual_owner_type := p_sr_rec.resource_type;
134: END IF;

Line 136: IF (p_sr_rec.owner_id = FND_API.G_MISS_NUM) THEN

132: ELSE
133: l_individual_owner_type := p_sr_rec.resource_type;
134: END IF;
135:
136: IF (p_sr_rec.owner_id = FND_API.G_MISS_NUM) THEN
137: l_individual_owner_id := NULL;
138: l_individual_owner_type := NULL;
139: ELSIF p_sr_rec.owner_id IS NULL THEN
140: l_individual_owner_id := NULL;

Line 170: IF (p_login_id = FND_API.G_MISS_NUM) THEN

166: X_Msg_Count => X_Msg_Count,
167: X_Msg_Data => X_Msg_Data);
168:
169:
170: IF (p_login_id = FND_API.G_MISS_NUM) THEN
171: l_login_id := NULL;
172: ELSE
173: l_login_id := p_login_id;
174: END IF;

Line 217: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

213:
214: --dbms_output.put_line('After calling IEU_WR_PUB.CREATE_WR_ITEM');
215: --dbms_output.put_line('l_return_status:' ||l_return_status );
216:
217: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
218: x_return_status := l_return_status;
219: raise l_API_ERROR;
220: END IF;
221:

Line 228: IF FND_API.To_Boolean(p_commit) THEN

224: CLOSE sel_sr_wi_csr;
225:
226: END IF; -- FND_PROFILE.value('CS_SR_ENABLE_UWQ_WORKITEM' = 'Y'
227:
228: IF FND_API.To_Boolean(p_commit) THEN
229: COMMIT WORK;
230: END IF;
231:
232:

Line 243: WHEN FND_API.G_EXC_ERROR THEN

239: FND_MSG_PUB.Count_And_Get
240: ( p_count => x_msg_count,
241: p_data => x_msg_data );
242:
243: WHEN FND_API.G_EXC_ERROR THEN
244: IF (sel_sr_wi_csr%ISOPEN) THEN
245: CLOSE sel_sr_wi_csr;
246: END IF;
247: x_return_status := FND_API.G_RET_STS_ERROR;

Line 247: x_return_status := FND_API.G_RET_STS_ERROR;

243: WHEN FND_API.G_EXC_ERROR THEN
244: IF (sel_sr_wi_csr%ISOPEN) THEN
245: CLOSE sel_sr_wi_csr;
246: END IF;
247: x_return_status := FND_API.G_RET_STS_ERROR;
248: FND_MSG_PUB.Count_And_Get
249: ( p_count => x_msg_count,
250: p_data => x_msg_data );
251:

Line 252: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

248: FND_MSG_PUB.Count_And_Get
249: ( p_count => x_msg_count,
250: p_data => x_msg_data );
251:
252: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
253: IF (sel_sr_wi_csr%ISOPEN) THEN
254: CLOSE sel_sr_wi_csr;
255: END IF;
256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

252: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
253: IF (sel_sr_wi_csr%ISOPEN) THEN
254: CLOSE sel_sr_wi_csr;
255: END IF;
256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
257: FND_MSG_PUB.Count_And_Get
258: ( p_count => x_msg_count,
259: p_data => x_msg_data );
260:

Line 265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

261: WHEN OTHERS THEN
262: IF (sel_sr_wi_csr%ISOPEN) THEN
263: CLOSE sel_sr_wi_csr;
264: END IF;
265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
266: FND_MSG_PUB.Count_And_Get
267: ( p_count => x_msg_count,
268: p_data => x_msg_data );
269:

Line 279: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

275: ******************************************************/
276:
277: PROCEDURE Update_Workitem(
278: p_api_version IN NUMBER,
279: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
280: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
281: p_incident_id IN NUMBER,
282: p_old_sr_rec IN CS_ServiceRequest_PVT.sr_oldvalues_rec_type,
283: p_new_sr_rec IN CS_ServiceRequest_PVT.service_request_rec_type,

Line 280: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

276:
277: PROCEDURE Update_Workitem(
278: p_api_version IN NUMBER,
279: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
280: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
281: p_incident_id IN NUMBER,
282: p_old_sr_rec IN CS_ServiceRequest_PVT.sr_oldvalues_rec_type,
283: p_new_sr_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
284: p_user_id IN NUMBER, -- Required

Line 343: x_return_status := FND_API.G_RET_STS_SUCCESS;

339:
340:
341: BEGIN
342:
343: x_return_status := FND_API.G_RET_STS_SUCCESS;
344:
345: -- First thing to do is check if user wants to use UWQ assignment.
346:
347: -- See if service request as a work source is activated.

Line 351: p_init_msg_list => fnd_api.g_false,

347: -- See if service request as a work source is activated.
348:
349: IEU_WR_PUB.CHECK_WS_ACTIVATION_STATUS
350: ( p_api_version => 1.0,
351: p_init_msg_list => fnd_api.g_false,
352: p_commit => fnd_api.g_false,
353: p_ws_code => 'SR',
354: x_ws_activation_status => l_sr_activation_status,
355: x_msg_count => x_msg_count,

Line 352: p_commit => fnd_api.g_false,

348:
349: IEU_WR_PUB.CHECK_WS_ACTIVATION_STATUS
350: ( p_api_version => 1.0,
351: p_init_msg_list => fnd_api.g_false,
352: p_commit => fnd_api.g_false,
353: p_ws_code => 'SR',
354: x_ws_activation_status => l_sr_activation_status,
355: x_msg_count => x_msg_count,
356: x_msg_data => x_msg_data,

Line 359: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

355: x_msg_count => x_msg_count,
356: x_msg_data => x_msg_data,
357: x_return_status => l_return_status);
358:
359: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
360: l_sr_activation_status := 'N' ;
361: END IF;
362:
363: IF (NVL(l_sr_activation_status,'N') = 'Y') THEN

Line 426: IF (p_new_sr_rec.severity_id = FND_API.G_MISS_NUM) THEN

422: l_customer_id := p_old_sr_rec.customer_id;
423: END IF;
424:
425: -- SR record may not pass new severity id since it may not have changed.
426: IF (p_new_sr_rec.severity_id = FND_API.G_MISS_NUM) THEN
427: l_new_priority := l_old_priority;
428: l_new_severity_id := p_old_sr_rec.incident_severity_id;
429: ELSE
430: l_new_severity_id := p_new_sr_rec.severity_id;

Line 455: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

451: X_Msg_Count => X_Msg_Count,
452: X_Msg_Data => X_Msg_Data);
453:
454:
455: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
456: IF l_change_wi_attr1 = 'Y' THEN
457: l_change_wi_attr := l_change_wi_attr1;
458: END IF;
459: ELSE

Line 480: IF (p_new_sr_rec.status_id = FND_API.G_MISS_NUM) THEN

476: END IF;
477: CLOSE sel_status_flags_csr;
478:
479: -- SR record may not pass new status id since it may not have changed.
480: IF (p_new_sr_rec.status_id = FND_API.G_MISS_NUM) THEN
481: l_new_status_id := p_old_sr_rec.incident_status_id;
482: l_new_close_flag := l_old_close_flag;
483: l_new_on_hold_flag := l_old_on_hold_flag;
484: ELSE

Line 525: IF (l_resource_type = FND_API.G_MISS_CHAR) THEN

521: -- CS stores G_MISS_NUM, G_MISS_CHAR, G_MISS_DATE in tables
522: -- so we have to default these values to null since UWQ does not
523: -- interpret these values correctly.
524:
525: IF (l_resource_type = FND_API.G_MISS_CHAR) THEN
526: l_resource_type := NULL;
527: END IF;
528:
529: IF (l_owner_id = FND_API.G_MISS_NUM) THEN

Line 529: IF (l_owner_id = FND_API.G_MISS_NUM) THEN

525: IF (l_resource_type = FND_API.G_MISS_CHAR) THEN
526: l_resource_type := NULL;
527: END IF;
528:
529: IF (l_owner_id = FND_API.G_MISS_NUM) THEN
530: l_owner_id := NULL;
531: l_resource_type := NULL;
532: ELSIF l_owner_id IS NULL THEN
533: l_resource_type := NULL;

Line 536: IF (l_group_type = FND_API.G_MISS_CHAR) THEN

532: ELSIF l_owner_id IS NULL THEN
533: l_resource_type := NULL;
534: END IF;
535:
536: IF (l_group_type = FND_API.G_MISS_CHAR) THEN
537: l_group_type := NULL;
538: END IF;
539:
540: IF (l_owner_group_id = FND_API.G_MISS_NUM) THEN

Line 540: IF (l_owner_group_id = FND_API.G_MISS_NUM) THEN

536: IF (l_group_type = FND_API.G_MISS_CHAR) THEN
537: l_group_type := NULL;
538: END IF;
539:
540: IF (l_owner_group_id = FND_API.G_MISS_NUM) THEN
541: l_owner_group_id := NULL;
542: l_group_type := NULL;
543: ELSIF l_owner_group_id IS NULL THEN
544: l_group_type := NULL;

Line 547: IF (l_summary = FND_API.G_MISS_CHAR) THEN

543: ELSIF l_owner_group_id IS NULL THEN
544: l_group_type := NULL;
545: END IF;
546:
547: IF (l_summary = FND_API.G_MISS_CHAR) THEN
548: l_summary := NULL;
549: END IF;
550: IF (l_customer_id = FND_API.G_MISS_NUM) THEN
551: l_customer_id := NULL;

Line 550: IF (l_customer_id = FND_API.G_MISS_NUM) THEN

546:
547: IF (l_summary = FND_API.G_MISS_CHAR) THEN
548: l_summary := NULL;
549: END IF;
550: IF (l_customer_id = FND_API.G_MISS_NUM) THEN
551: l_customer_id := NULL;
552: END IF;
553:
554: IF (l_priority = FND_API.G_MISS_CHAR) THEN

Line 554: IF (l_priority = FND_API.G_MISS_CHAR) THEN

550: IF (l_customer_id = FND_API.G_MISS_NUM) THEN
551: l_customer_id := NULL;
552: END IF;
553:
554: IF (l_priority = FND_API.G_MISS_CHAR) THEN
555: l_priority := NULL;
556: END IF;
557: IF (l_due_date = FND_API.G_MISS_DATE) THEN
558: l_due_date := NULL;

Line 557: IF (l_due_date = FND_API.G_MISS_DATE) THEN

553:
554: IF (l_priority = FND_API.G_MISS_CHAR) THEN
555: l_priority := NULL;
556: END IF;
557: IF (l_due_date = FND_API.G_MISS_DATE) THEN
558: l_due_date := NULL;
559: END IF;
560:
561: /************************************************/

Line 604: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

600: x_msg_data => x_msg_data,
601: x_return_status => l_return_status
602: );
603:
604: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
605: x_return_status := l_return_status;
606: raise l_API_ERROR;
607: END IF;
608:

Line 654: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

650: x_msg_count => x_msg_count,
651: x_msg_data => x_msg_data);
652:
653:
654: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
655: x_return_status := l_return_status;
656: raise l_API_ERROR;
657: END IF;
658:

Line 666: IF FND_API.To_Boolean(p_commit) THEN

662: close sel_sr_wi_csr;
663:
664: END IF; -- FND_PROFILE.value('CS_SR_ENABLE_UWQ_WORKITEM' = 'Y')
665:
666: IF FND_API.To_Boolean(p_commit) THEN
667: COMMIT WORK;
668: END IF;
669:
670: EXCEPTION

Line 680: WHEN FND_API.G_EXC_ERROR THEN

676: FND_MSG_PUB.Count_And_Get
677: ( p_count => x_msg_count,
678: p_data => x_msg_data );
679:
680: WHEN FND_API.G_EXC_ERROR THEN
681: IF (sel_sr_wi_csr%ISOPEN) THEN
682: CLOSE sel_sr_wi_csr;
683: END IF;
684: x_return_status := FND_API.G_RET_STS_ERROR;

Line 684: x_return_status := FND_API.G_RET_STS_ERROR;

680: WHEN FND_API.G_EXC_ERROR THEN
681: IF (sel_sr_wi_csr%ISOPEN) THEN
682: CLOSE sel_sr_wi_csr;
683: END IF;
684: x_return_status := FND_API.G_RET_STS_ERROR;
685: FND_MSG_PUB.Count_And_Get
686: ( p_count => x_msg_count,
687: p_data => x_msg_data );
688:

Line 689: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

685: FND_MSG_PUB.Count_And_Get
686: ( p_count => x_msg_count,
687: p_data => x_msg_data );
688:
689: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
690: IF (sel_sr_wi_csr%ISOPEN) THEN
691: CLOSE sel_sr_wi_csr;
692: END IF;
693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

689: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
690: IF (sel_sr_wi_csr%ISOPEN) THEN
691: CLOSE sel_sr_wi_csr;
692: END IF;
693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
694: FND_MSG_PUB.Count_And_Get
695: ( p_count => x_msg_count,
696: p_data => x_msg_data );
697:

Line 702: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

698: WHEN OTHERS THEN
699: IF (sel_sr_wi_csr%ISOPEN) THEN
700: CLOSE sel_sr_wi_csr;
701: END IF;
702: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
703: FND_MSG_PUB.Count_And_Get
704: ( p_count => x_msg_count,
705: p_data => x_msg_data );
706:

Line 720: IF (p_new_val = FND_API.G_MISS_CHAR) THEN

716: p_new_val IN VARCHAR2) RETURN BOOLEAN IS
717:
718: BEGIN
719:
720: IF (p_new_val = FND_API.G_MISS_CHAR) THEN
721: return false;
722: ELSIF ( (p_old_val IS NOT NULL AND p_new_val IS NULL) OR
723: (p_old_val IS NULL AND p_new_val IS NOT NULL) OR
724: (p_old_val IS NOT NULL AND p_new_val IS NOT NULL AND

Line 743: IF (p_new_val = FND_API.G_MISS_NUM) THEN

739: p_new_val IN NUMBER) RETURN BOOLEAN IS
740:
741: BEGIN
742:
743: IF (p_new_val = FND_API.G_MISS_NUM) THEN
744: return false;
745: ELSIF ( (p_old_val IS NOT NULL AND p_new_val IS NULL) OR
746: (p_old_val IS NULL AND p_new_val IS NOT NULL) OR
747: (p_old_val IS NOT NULL AND p_new_val IS NOT NULL AND

Line 766: IF (p_new_val = FND_API.G_MISS_DATE) THEN

762: p_new_val IN DATE) RETURN BOOLEAN IS
763:
764: BEGIN
765:
766: IF (p_new_val = FND_API.G_MISS_DATE) THEN
767: return false;
768: ELSIF ( (p_old_val IS NOT NULL AND p_new_val IS NULL) OR
769: (p_old_val IS NULL AND p_new_val IS NOT NULL) OR
770: (p_old_val IS NOT NULL AND p_new_val IS NOT NULL AND

Line 819: X_Return_Status := FND_API.G_RET_STS_SUCCESS;

815: WHERE incident_severity_id = l_severity_id;
816:
817: BEGIN
818:
819: X_Return_Status := FND_API.G_RET_STS_SUCCESS;
820:
821: IF p_operation_mode = 'CREATE' THEN -- Operation Mode
822:
823: IF p_new_inc_responded_by_date = FND_API.G_MISS_DATE THEN

Line 823: IF p_new_inc_responded_by_date = FND_API.G_MISS_DATE THEN

819: X_Return_Status := FND_API.G_RET_STS_SUCCESS;
820:
821: IF p_operation_mode = 'CREATE' THEN -- Operation Mode
822:
823: IF p_new_inc_responded_by_date = FND_API.G_MISS_DATE THEN
824: l_Inc_responded_by_date := NULL;
825: ELSE
826: l_Inc_responded_by_date := p_new_inc_responded_by_date;
827: END IF;

Line 829: IF P_New_obligation_date = FND_API.G_MISS_DATE THEN

825: ELSE
826: l_Inc_responded_by_date := p_new_inc_responded_by_date;
827: END IF;
828:
829: IF P_New_obligation_date = FND_API.G_MISS_DATE THEN
830: l_obligation_date := NULL;
831: ELSE
832: l_obligation_date := P_New_obligation_date;
833: END IF;

Line 835: IF P_New_exp_resolution_date = FND_API.G_MISS_DATE THEN

831: ELSE
832: l_obligation_date := P_New_obligation_date;
833: END IF;
834:
835: IF P_New_exp_resolution_date = FND_API.G_MISS_DATE THEN
836: l_exp_resolution_date := NULL;
837: ELSE
838: l_exp_resolution_date := P_New_exp_resolution_date;
839: END IF;

Line 875: p_new_inc_responded_by_date <> FND_API.G_MISS_DATE) OR

871: ELSE --p_operation_mode = 'UPDATE' THEN -- Operation Mode
872:
873: IF ((p_old_inc_responded_by_date IS NULL AND
874: p_new_inc_responded_by_date IS NOT NULL AND
875: p_new_inc_responded_by_date <> FND_API.G_MISS_DATE) OR
876: (p_old_inc_responded_by_date IS NOT NULL AND
877: p_new_inc_responded_by_date IS NULL)
878: ) THEN
879:

Line 931: IF p_new_inc_responded_by_date = FND_API.G_MISS_DATE THEN

927: END IF; -- End of: Determine if we need to update Work Item Due Date.
928:
929: -- Derive the responded by and resolve on dates.
930:
931: IF p_new_inc_responded_by_date = FND_API.G_MISS_DATE THEN
932: l_inc_responded_by_date := p_old_inc_responded_by_date;
933: ELSE
934: l_inc_responded_by_date := p_new_inc_responded_by_date;
935: END IF;

Line 937: IF p_new_obligation_date = FND_API.G_MISS_DATE THEN

933: ELSE
934: l_inc_responded_by_date := p_new_inc_responded_by_date;
935: END IF;
936:
937: IF p_new_obligation_date = FND_API.G_MISS_DATE THEN
938: l_obligation_date := p_old_obligation_date;
939: ELSE
940: l_obligation_date := p_new_obligation_date;
941: END IF;

Line 943: IF p_new_exp_resolution_date = FND_API.G_MISS_DATE THEN

939: ELSE
940: l_obligation_date := p_new_obligation_date;
941: END IF;
942:
943: IF p_new_exp_resolution_date = FND_API.G_MISS_DATE THEN
944: l_exp_resolution_date := p_old_exp_resolution_date;
945: ELSE
946: l_exp_resolution_date := p_new_exp_resolution_date;
947: END IF;

Line 963: IF p_new_Severity_Id = FND_API.G_MISS_NUM THEN

959:
960: CLOSE c_get_priority_code ;
961:
962: -- SR record may not pass new severity id since it may not have changed.
963: IF p_new_Severity_Id = FND_API.G_MISS_NUM THEN
964: l_new_priority_code := l_old_priority_code;
965: ELSE
966: OPEN c_get_priority_code (P_New_Severity_Id) ;
967: FETCH c_get_priority_code INTO l_new_priority_code;

Line 982: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

978: END IF ; -- Operation Mode
979:
980: EXCEPTION
981: WHEN OTHERS THEN
982: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
983: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
984: p_data => x_msg_data );
985:
986: END Apply_Priority_Rule;