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_DUP_CHK_PVT dependencies on FND_API

Line 35: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

31:
32: PROCEDURE Duplicate_Check
33: (
34: p_api_version IN NUMBER,
35: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
36: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
37: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
38: p_incident_id IN NUMBER,
39: p_incident_type_id IN NUMBER,

Line 36: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

32: PROCEDURE Duplicate_Check
33: (
34: p_api_version IN NUMBER,
35: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
36: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
37: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
38: p_incident_id IN NUMBER,
39: p_incident_type_id IN NUMBER,
40: p_customer_product_ID IN NUMBER,

Line 37: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,

33: (
34: p_api_version IN NUMBER,
35: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
36: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
37: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
38: p_incident_id IN NUMBER,
39: p_incident_type_id IN NUMBER,
40: p_customer_product_ID IN NUMBER,
41: p_instance_serial_number IN VARCHAR2,

Line 56: l_ea_attr_dup_flag VARCHAR2(1) := FND_API.g_false;

52: x_msg_count OUT NOCOPY NUMBER,
53: x_msg_data OUT NOCOPY VARCHAR2
54: )
55: IS
56: l_ea_attr_dup_flag VARCHAR2(1) := FND_API.g_false;
57: l_cs_sr_dup_flag VARCHAR2(1) := FND_API.g_false;
58:
59: l_api_name CONSTANT VARCHAR2(30) := 'SR_DUPLICATE_CHECK_API';
60: l_api_version CONSTANT NUMBER := 1.0;

Line 57: l_cs_sr_dup_flag VARCHAR2(1) := FND_API.g_false;

53: x_msg_data OUT NOCOPY VARCHAR2
54: )
55: IS
56: l_ea_attr_dup_flag VARCHAR2(1) := FND_API.g_false;
57: l_cs_sr_dup_flag VARCHAR2(1) := FND_API.g_false;
58:
59: l_api_name CONSTANT VARCHAR2(30) := 'SR_DUPLICATE_CHECK_API';
60: l_api_version CONSTANT NUMBER := 1.0;
61: l_return_status VARCHAR2(1);

Line 72: IF NOT FND_API.Compatible_API_Call

68: l_ea_ea_dup VARCHAR2(1);
69:
70: BEGIN
71:
72: IF NOT FND_API.Compatible_API_Call
73: (l_api_version, p_api_version , l_api_name, G_PKG_NAME )
74: THEN
75: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
76: END IF;

Line 75: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

71:
72: IF NOT FND_API.Compatible_API_Call
73: (l_api_version, p_api_version , l_api_name, G_PKG_NAME )
74: THEN
75: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
76: END IF;
77:
78: -- Initialize message list if p_init_msg_list is set to TRUE.
79: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 79: IF FND_API.to_Boolean( p_init_msg_list ) THEN

75: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
76: END IF;
77:
78: -- Initialize message list if p_init_msg_list is set to TRUE.
79: IF FND_API.to_Boolean( p_init_msg_list ) THEN
80: FND_MSG_PUB.initialize;
81: END IF;
82:
83: -- Initialize API return status to success

Line 84: x_return_status := FND_API.G_RET_STS_SUCCESS;

80: FND_MSG_PUB.initialize;
81: END IF;
82:
83: -- Initialize API return status to success
84: x_return_status := FND_API.G_RET_STS_SUCCESS;
85:
86: IF (p_cs_extended_attr.count > 0 or
87: ( p_incident_address.incident_address is not NULL
88: or p_incident_address.incident_city is not NULL

Line 107: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

103: p_return_status => l_return_status
104: );
105: END IF;
106:
107: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
109: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
110: RAISE FND_API.G_EXC_ERROR;
111: END IF;

Line 108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

104: );
105: END IF;
106:
107: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
109: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
110: RAISE FND_API.G_EXC_ERROR;
111: END IF;
112:

Line 109: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

105: END IF;
106:
107: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
109: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
110: RAISE FND_API.G_EXC_ERROR;
111: END IF;
112:
113: IF ( ( p_customer_product_id is not NULL

Line 110: RAISE FND_API.G_EXC_ERROR;

106:
107: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
109: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
110: RAISE FND_API.G_EXC_ERROR;
111: END IF;
112:
113: IF ( ( p_customer_product_id is not NULL
114: or p_current_serial_number is not NULL

Line 136: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

132: p_return_status => l_return_status
133: );
134: END IF;
135:
136: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
138: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
139: RAISE FND_API.G_EXC_ERROR;
140: END IF;

Line 137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

133: );
134: END IF;
135:
136: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
138: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
139: RAISE FND_API.G_EXC_ERROR;
140: END IF;
141:

Line 138: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

134: END IF;
135:
136: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
138: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
139: RAISE FND_API.G_EXC_ERROR;
140: END IF;
141:
142: IF l_ea_attr_dup_flag = fnd_api.g_true and l_cs_sr_dup_flag = fnd_api.g_true THEN

Line 139: RAISE FND_API.G_EXC_ERROR;

135:
136: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
138: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
139: RAISE FND_API.G_EXC_ERROR;
140: END IF;
141:
142: IF l_ea_attr_dup_flag = fnd_api.g_true and l_cs_sr_dup_flag = fnd_api.g_true THEN
143: x_dup_found_at := 'BOTH';

Line 142: IF l_ea_attr_dup_flag = fnd_api.g_true and l_cs_sr_dup_flag = fnd_api.g_true THEN

138: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
139: RAISE FND_API.G_EXC_ERROR;
140: END IF;
141:
142: IF l_ea_attr_dup_flag = fnd_api.g_true and l_cs_sr_dup_flag = fnd_api.g_true THEN
143: x_dup_found_at := 'BOTH';
144: Construct_Unique_List_Dup_SR(
145: p_cs_ea_dup_rec => l_cs_ea_dup_rec,
146: p_ea_attr_dup_flag => l_ea_attr_dup_flag,

Line 157: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

153: p_duplicate_flag => x_duplicate_flag,
154: p_return_status => l_return_status
155: );
156:
157: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
158: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
159: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
160: RAISE FND_API.G_EXC_ERROR;
161: END IF;

Line 158: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

154: p_return_status => l_return_status
155: );
156:
157: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
158: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
159: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
160: RAISE FND_API.G_EXC_ERROR;
161: END IF;
162:

Line 159: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

155: );
156:
157: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
158: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
159: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
160: RAISE FND_API.G_EXC_ERROR;
161: END IF;
162:
163: ELSIF l_ea_attr_dup_flag = fnd_api.g_true and l_cs_sr_dup_flag = fnd_api.g_false THEN

Line 160: RAISE FND_API.G_EXC_ERROR;

156:
157: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
158: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
159: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
160: RAISE FND_API.G_EXC_ERROR;
161: END IF;
162:
163: ELSIF l_ea_attr_dup_flag = fnd_api.g_true and l_cs_sr_dup_flag = fnd_api.g_false THEN
164: x_dup_found_at := 'EA';

Line 163: ELSIF l_ea_attr_dup_flag = fnd_api.g_true and l_cs_sr_dup_flag = fnd_api.g_false THEN

159: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
160: RAISE FND_API.G_EXC_ERROR;
161: END IF;
162:
163: ELSIF l_ea_attr_dup_flag = fnd_api.g_true and l_cs_sr_dup_flag = fnd_api.g_false THEN
164: x_dup_found_at := 'EA';
165: x_sr_dupl_rec := l_cs_ea_dup_rec;
166: x_duplicate_flag := fnd_api.g_true;
167:

Line 166: x_duplicate_flag := fnd_api.g_true;

162:
163: ELSIF l_ea_attr_dup_flag = fnd_api.g_true and l_cs_sr_dup_flag = fnd_api.g_false THEN
164: x_dup_found_at := 'EA';
165: x_sr_dupl_rec := l_cs_ea_dup_rec;
166: x_duplicate_flag := fnd_api.g_true;
167:
168: ELSIF l_cs_sr_dup_flag = fnd_api.g_true and l_ea_attr_dup_flag = fnd_api.g_false THEN
169: x_dup_found_at := 'SR';
170: x_sr_dupl_rec := l_cs_sr_dup_rec;

Line 168: ELSIF l_cs_sr_dup_flag = fnd_api.g_true and l_ea_attr_dup_flag = fnd_api.g_false THEN

164: x_dup_found_at := 'EA';
165: x_sr_dupl_rec := l_cs_ea_dup_rec;
166: x_duplicate_flag := fnd_api.g_true;
167:
168: ELSIF l_cs_sr_dup_flag = fnd_api.g_true and l_ea_attr_dup_flag = fnd_api.g_false THEN
169: x_dup_found_at := 'SR';
170: x_sr_dupl_rec := l_cs_sr_dup_rec;
171: x_duplicate_flag := fnd_api.g_true;
172:

Line 171: x_duplicate_flag := fnd_api.g_true;

167:
168: ELSIF l_cs_sr_dup_flag = fnd_api.g_true and l_ea_attr_dup_flag = fnd_api.g_false THEN
169: x_dup_found_at := 'SR';
170: x_sr_dupl_rec := l_cs_sr_dup_rec;
171: x_duplicate_flag := fnd_api.g_true;
172:
173: ELSE
174: x_dup_found_at := 'NONE';
175: END IF;

Line 176: x_return_status := FND_API.G_RET_STS_SUCCESS;

172:
173: ELSE
174: x_dup_found_at := 'NONE';
175: END IF;
176: x_return_status := FND_API.G_RET_STS_SUCCESS;
177:
178: EXCEPTION
179: WHEN FND_API.G_EXC_ERROR THEN
180: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 179: WHEN FND_API.G_EXC_ERROR THEN

175: END IF;
176: x_return_status := FND_API.G_RET_STS_SUCCESS;
177:
178: EXCEPTION
179: WHEN FND_API.G_EXC_ERROR THEN
180: x_return_status := FND_API.G_RET_STS_ERROR ;
181: FND_MSG_PUB.Count_And_Get
182: (p_count => x_msg_count,
183: p_data => x_msg_data);

Line 180: x_return_status := FND_API.G_RET_STS_ERROR ;

176: x_return_status := FND_API.G_RET_STS_SUCCESS;
177:
178: EXCEPTION
179: WHEN FND_API.G_EXC_ERROR THEN
180: x_return_status := FND_API.G_RET_STS_ERROR ;
181: FND_MSG_PUB.Count_And_Get
182: (p_count => x_msg_count,
183: p_data => x_msg_data);
184: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 184: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

180: x_return_status := FND_API.G_RET_STS_ERROR ;
181: FND_MSG_PUB.Count_And_Get
182: (p_count => x_msg_count,
183: p_data => x_msg_data);
184: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
186: FND_MSG_PUB.Count_And_Get
187: (p_count => x_msg_count,
188: p_data => x_msg_data);

Line 185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

181: FND_MSG_PUB.Count_And_Get
182: (p_count => x_msg_count,
183: p_data => x_msg_data);
184: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
186: FND_MSG_PUB.Count_And_Get
187: (p_count => x_msg_count,
188: p_data => x_msg_data);
189: WHEN OTHERS THEN

Line 190: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

186: FND_MSG_PUB.Count_And_Get
187: (p_count => x_msg_count,
188: p_data => x_msg_data);
189: WHEN OTHERS THEN
190: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
191: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
192: THEN
193: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
194: l_api_name );

Line 232: p_return_status := FND_API.G_RET_STS_SUCCESS;

228: cs_ea_dup_rec sr_dupl_tbl;
229: cs_dup_prof_value varchar2(100);
230:
231: BEGIN
232: p_return_status := FND_API.G_RET_STS_SUCCESS;
233: OPEN c_CheckIfDupCheckOn_Csr;
234: FETCH c_CheckIfDupCheckOn_Csr INTO c_CheckIfDupCheckOn_rec;
235:
236: IF (c_CheckIfDupCheckOn_csr%NOTFOUND) THEN

Line 237: p_ea_attr_dup_flag := fnd_api.g_false;

233: OPEN c_CheckIfDupCheckOn_Csr;
234: FETCH c_CheckIfDupCheckOn_Csr INTO c_CheckIfDupCheckOn_rec;
235:
236: IF (c_CheckIfDupCheckOn_csr%NOTFOUND) THEN
237: p_ea_attr_dup_flag := fnd_api.g_false;
238: return;
239: END IF;
240: CLOSE c_CheckIfDupCheckOn_csr;
241:

Line 243: p_ea_attr_dup_flag := fnd_api.g_false;

239: END IF;
240: CLOSE c_CheckIfDupCheckOn_csr;
241:
242: IF c_CheckIfDupCheckOn_rec.sr_dup_check_flag <> 'Y' THEN
243: p_ea_attr_dup_flag := fnd_api.g_false;
244: return;
245: END IF;
246:
247: cs_dup_prof_value := fnd_profile.value('CS_SR_DUP_CHK_CRITERIA');

Line 252: p_ea_attr_dup_flag := fnd_api.g_false;

248:
249: IF p_incident_id is not null and
250: (cs_dup_prof_value NOT IN ('CS_DUP_CRIT_EA_ADDR', 'CS_DUP_CRIT_WITHNO_SERIAL', 'CS_DUP_CRIT_WITH_SERIAL') or cs_dup_prof_value is null)
251: THEN
252: p_ea_attr_dup_flag := fnd_api.g_false;
253: return;
254: END IF;
255:
256: Perform_EA_Duplicate(

Line 268: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

264: p_ea_ea_dup => p_ea_ea_dup,
265: p_return_status => p_return_status
266: );
267:
268: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
269: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
270: return;
271: ELSIF p_return_status = FND_API.G_RET_STS_ERROR THEN
272: p_return_status := FND_API.G_RET_STS_ERROR;

Line 269: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

265: p_return_status => p_return_status
266: );
267:
268: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
269: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
270: return;
271: ELSIF p_return_status = FND_API.G_RET_STS_ERROR THEN
272: p_return_status := FND_API.G_RET_STS_ERROR;
273: return;

Line 271: ELSIF p_return_status = FND_API.G_RET_STS_ERROR THEN

267:
268: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
269: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
270: return;
271: ELSIF p_return_status = FND_API.G_RET_STS_ERROR THEN
272: p_return_status := FND_API.G_RET_STS_ERROR;
273: return;
274: END IF;
275: p_cs_ea_dup_rec := cs_ea_dup_rec;

Line 272: p_return_status := FND_API.G_RET_STS_ERROR;

268: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
269: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
270: return;
271: ELSIF p_return_status = FND_API.G_RET_STS_ERROR THEN
272: p_return_status := FND_API.G_RET_STS_ERROR;
273: return;
274: END IF;
275: p_cs_ea_dup_rec := cs_ea_dup_rec;
276:

Line 279: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

275: p_cs_ea_dup_rec := cs_ea_dup_rec;
276:
277: EXCEPTION
278: WHEN OTHERS THEN
279: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
280: return;
281: END Check_EA_Duplicate_Setup;
282:
283:

Line 495: p_return_status := FND_API.G_RET_STS_SUCCESS;

491: incident_id = l_incident_Id;
492:
493: BEGIN
494:
495: p_return_status := FND_API.G_RET_STS_SUCCESS;
496: OPEN c_DuplicateTimeInfo_csr;
497: FETCH c_DuplicateTimeInfo_csr INTO l_DuplicateTimeInfo_rec;
498:
499: CALCULATE_DUPLICATE_TIME_FRAME( p_incident_type_id => l_incident_type_id,

Line 541: p_ea_attr_dup_flag := fnd_api.g_true;

537: END IF;
538: END LOOP;
539:
540: IF match_found <> 0 OR l_DuplicateCheckAttrs_csr%ROWCOUNT = 0 THEN
541: p_ea_attr_dup_flag := fnd_api.g_true;
542: cnt := cnt + 1;
543: l_ea_dup_found_tbl(cnt).incident_id := l_IncidentId_withAddr_rec.incident_id;
544: l_ea_dup_found_tbl(cnt).incident_link_id := l_IncidentId_withAddr_rec.incident_link_id;
545: l_ea_dup_found_tbl(cnt).incident_link_number := l_IncidentId_withAddr_rec.incident_link_number;

Line 596: p_ea_attr_dup_flag := fnd_api.g_true;

592: END IF;
593: END LOOP;
594:
595: IF match_found <> 0 OR l_DuplicateCheckAttrs_csr%ROWCOUNT = 0 THEN
596: p_ea_attr_dup_flag := fnd_api.g_true;
597: cnt := cnt + 1;
598: p_ea_ea_dup := 'Y';
599: l_ea_dup_found_tbl(cnt).incident_id := l_IncidentId_NoAddr_rec.incident_id;
600: l_ea_dup_found_tbl(cnt).incident_link_id := l_IncidentId_NoAddr_rec.incident_link_id;

Line 654: p_ea_attr_dup_flag := fnd_api.g_true;

650: END IF;
651: END LOOP;
652:
653: IF match_found <> 0 OR l_DuplicateCheckAttrs_csr%ROWCOUNT = 0 THEN
654: p_ea_attr_dup_flag := fnd_api.g_true;
655: cnt := cnt + 1;
656: l_ea_dup_found_tbl(cnt).incident_id := l_IncidentId_withAddrUpd_rec.incident_id;
657: l_ea_dup_found_tbl(cnt).incident_link_id := l_IncidentId_withAddrUpd_rec.incident_link_id;
658: l_ea_dup_found_tbl(cnt).incident_link_number := l_IncidentId_withAddrUpd_rec.incident_link_number;

Line 706: p_ea_attr_dup_flag := fnd_api.g_true;

702: END IF;
703: END LOOP;
704:
705: IF match_found <> 0 THEN
706: p_ea_attr_dup_flag := fnd_api.g_true;
707: cnt := cnt + 1;
708: p_ea_ea_dup := 'Y';
709: l_ea_dup_found_tbl(cnt).incident_id := l_IncidentId_NoAddrUpd_rec.incident_id;
710: l_ea_dup_found_tbl(cnt).incident_link_id := l_IncidentId_NoAddrUpd_rec.incident_link_id;

Line 736: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

732: p_dup_tbl => p_cs_ea_dup_rec,
733: p_return_status => p_return_status
734: );
735:
736: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
737: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
738: return;
739: ELSIF p_return_status = FND_API.G_RET_STS_ERROR THEN
740: p_return_status := FND_API.G_RET_STS_ERROR;

Line 737: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

733: p_return_status => p_return_status
734: );
735:
736: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
737: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
738: return;
739: ELSIF p_return_status = FND_API.G_RET_STS_ERROR THEN
740: p_return_status := FND_API.G_RET_STS_ERROR;
741: return;

Line 739: ELSIF p_return_status = FND_API.G_RET_STS_ERROR THEN

735:
736: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
737: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
738: return;
739: ELSIF p_return_status = FND_API.G_RET_STS_ERROR THEN
740: p_return_status := FND_API.G_RET_STS_ERROR;
741: return;
742: END IF;
743:

Line 740: p_return_status := FND_API.G_RET_STS_ERROR;

736: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
737: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
738: return;
739: ELSIF p_return_status = FND_API.G_RET_STS_ERROR THEN
740: p_return_status := FND_API.G_RET_STS_ERROR;
741: return;
742: END IF;
743:
744: p_ea_attr_dup_flag := FND_API.g_true;

Line 744: p_ea_attr_dup_flag := FND_API.g_true;

740: p_return_status := FND_API.G_RET_STS_ERROR;
741: return;
742: END IF;
743:
744: p_ea_attr_dup_flag := FND_API.g_true;
745: p_cs_ea_dup_rec := p_cs_ea_dup_rec;
746: ELSE
747: p_ea_attr_dup_flag := FND_API.g_false;
748: END IF;

Line 747: p_ea_attr_dup_flag := FND_API.g_false;

743:
744: p_ea_attr_dup_flag := FND_API.g_true;
745: p_cs_ea_dup_rec := p_cs_ea_dup_rec;
746: ELSE
747: p_ea_attr_dup_flag := FND_API.g_false;
748: END IF;
749: EXCEPTION
750: WHEN OTHERS THEN
751: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 751: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

747: p_ea_attr_dup_flag := FND_API.g_false;
748: END IF;
749: EXCEPTION
750: WHEN OTHERS THEN
751: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
752: return;
753:
754: END Perform_EA_Duplicate;
755:

Line 779: p_return_status := FND_API.G_RET_STS_SUCCESS;

775: IS
776: l_cs_sr_dup_link_rec SR_Dupl_Link_Tbl;
777: BEGIN
778:
779: p_return_status := FND_API.G_RET_STS_SUCCESS;
780: IF p_customer_product_id is not NULL THEN
781: p_dup_from := 1;
782: Check_SR_Instance_Dup
783: ( p_customer_product_id => p_customer_product_id,

Line 837: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

833: p_return_status => p_return_status
834: );
835: END IF;
836:
837: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
838: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
839: return;
840: ELSIF p_return_status = FND_API.G_RET_STS_ERROR THEN
841: p_return_status := FND_API.G_RET_STS_ERROR;

Line 838: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

834: );
835: END IF;
836:
837: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
838: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
839: return;
840: ELSIF p_return_status = FND_API.G_RET_STS_ERROR THEN
841: p_return_status := FND_API.G_RET_STS_ERROR;
842: return;

Line 840: ELSIF p_return_status = FND_API.G_RET_STS_ERROR THEN

836:
837: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
838: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
839: return;
840: ELSIF p_return_status = FND_API.G_RET_STS_ERROR THEN
841: p_return_status := FND_API.G_RET_STS_ERROR;
842: return;
843: END IF;
844:

Line 841: p_return_status := FND_API.G_RET_STS_ERROR;

837: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
838: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
839: return;
840: ELSIF p_return_status = FND_API.G_RET_STS_ERROR THEN
841: p_return_status := FND_API.G_RET_STS_ERROR;
842: return;
843: END IF;
844:
845: IF p_cs_sr_dup_flag = FND_API.g_true THEN

Line 845: IF p_cs_sr_dup_flag = FND_API.g_true THEN

841: p_return_status := FND_API.G_RET_STS_ERROR;
842: return;
843: END IF;
844:
845: IF p_cs_sr_dup_flag = FND_API.g_true THEN
846: Check_Dup_SR_Link
847: ( p_dup_found_tbl => l_cs_sr_dup_link_rec,
848: p_dup_tbl => p_cs_sr_dup_rec,
849: p_return_status => p_return_status

Line 852: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

848: p_dup_tbl => p_cs_sr_dup_rec,
849: p_return_status => p_return_status
850: );
851:
852: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
853: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
854: return;
855: ELSIF p_return_status = FND_API.G_RET_STS_ERROR THEN
856: p_return_status := FND_API.G_RET_STS_ERROR;

Line 853: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

849: p_return_status => p_return_status
850: );
851:
852: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
853: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
854: return;
855: ELSIF p_return_status = FND_API.G_RET_STS_ERROR THEN
856: p_return_status := FND_API.G_RET_STS_ERROR;
857: return;

Line 855: ELSIF p_return_status = FND_API.G_RET_STS_ERROR THEN

851:
852: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
853: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
854: return;
855: ELSIF p_return_status = FND_API.G_RET_STS_ERROR THEN
856: p_return_status := FND_API.G_RET_STS_ERROR;
857: return;
858: END IF;
859: p_cs_sr_dup_flag := FND_API.g_true;

Line 856: p_return_status := FND_API.G_RET_STS_ERROR;

852: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
853: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
854: return;
855: ELSIF p_return_status = FND_API.G_RET_STS_ERROR THEN
856: p_return_status := FND_API.G_RET_STS_ERROR;
857: return;
858: END IF;
859: p_cs_sr_dup_flag := FND_API.g_true;
860: END IF;

Line 859: p_cs_sr_dup_flag := FND_API.g_true;

855: ELSIF p_return_status = FND_API.G_RET_STS_ERROR THEN
856: p_return_status := FND_API.G_RET_STS_ERROR;
857: return;
858: END IF;
859: p_cs_sr_dup_flag := FND_API.g_true;
860: END IF;
861: EXCEPTION
862: WHEN OTHERS THEN
863: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 863: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

859: p_cs_sr_dup_flag := FND_API.g_true;
860: END IF;
861: EXCEPTION
862: WHEN OTHERS THEN
863: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
864: return;
865:
866: END Perform_Dup_on_SR_Field;
867:

Line 977: p_return_status := FND_API.G_RET_STS_SUCCESS;

973:
974: l_dup_counter number := 0;
975:
976: BEGIN
977: p_return_status := FND_API.G_RET_STS_SUCCESS;
978:
979: CALCULATE_DUPLICATE_TIME_FRAME( p_duplicate_time_frame => l_duplicate_date);
980:
981: l_incident_id := p_incident_id;

Line 1070: p_cs_sr_dup_flag := fnd_api.g_true;

1066: END IF;
1067: END IF;
1068:
1069: IF l_dup_counter > 0 THEN
1070: p_cs_sr_dup_flag := fnd_api.g_true;
1071: ELSE
1072: p_cs_sr_dup_flag := fnd_api.g_false;
1073: END IF;
1074: p_cs_sr_dup_link_rec := l_cs_sr_dup_link_rec;

Line 1072: p_cs_sr_dup_flag := fnd_api.g_false;

1068:
1069: IF l_dup_counter > 0 THEN
1070: p_cs_sr_dup_flag := fnd_api.g_true;
1071: ELSE
1072: p_cs_sr_dup_flag := fnd_api.g_false;
1073: END IF;
1074: p_cs_sr_dup_link_rec := l_cs_sr_dup_link_rec;
1075:
1076: EXCEPTION

Line 1078: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1074: p_cs_sr_dup_link_rec := l_cs_sr_dup_link_rec;
1075:
1076: EXCEPTION
1077: WHEN OTHERS THEN
1078: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1079: return;
1080: END Check_SR_SerialNum_Dup;
1081:
1082:

Line 1129: p_return_status := FND_API.G_RET_STS_SUCCESS;

1125: l_dup_counter number := 0;
1126:
1127: BEGIN
1128:
1129: p_return_status := FND_API.G_RET_STS_SUCCESS;
1130:
1131: CALCULATE_DUPLICATE_TIME_FRAME( p_duplicate_time_frame => l_duplicate_date);
1132:
1133: l_incident_id := p_incident_id;

Line 1163: p_cs_sr_dup_flag := fnd_api.g_true;

1159: END LOOP;
1160: END IF;
1161:
1162: if l_dup_counter > 0 then
1163: p_cs_sr_dup_flag := fnd_api.g_true;
1164: else
1165: p_cs_sr_dup_flag := fnd_api.g_false;
1166: end if;
1167: p_cs_sr_dup_link_rec := l_cs_sr_dup_link_rec;

Line 1165: p_cs_sr_dup_flag := fnd_api.g_false;

1161:
1162: if l_dup_counter > 0 then
1163: p_cs_sr_dup_flag := fnd_api.g_true;
1164: else
1165: p_cs_sr_dup_flag := fnd_api.g_false;
1166: end if;
1167: p_cs_sr_dup_link_rec := l_cs_sr_dup_link_rec;
1168:
1169: EXCEPTION

Line 1171: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1167: p_cs_sr_dup_link_rec := l_cs_sr_dup_link_rec;
1168:
1169: EXCEPTION
1170: WHEN OTHERS THEN
1171: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1172: return;
1173: END Check_SR_Instance_Dup;
1174:
1175:

Line 1224: p_return_status := FND_API.G_RET_STS_SUCCESS;

1220:
1221: l_dup_sr_custprodupd_rec l_dup_sr_custprodUpd_csr%rowtype;
1222:
1223: BEGIN
1224: p_return_status := FND_API.G_RET_STS_SUCCESS;
1225: CALCULATE_DUPLICATE_TIME_FRAME( p_duplicate_time_frame => l_duplicate_date);
1226:
1227: l_incident_id := p_incident_id;
1228: l_customer_id := p_customer_id;

Line 1258: p_cs_sr_dup_flag := fnd_api.g_true;

1254: END LOOP;
1255: END IF;
1256:
1257: if l_dup_counter > 0 then
1258: p_cs_sr_dup_flag := fnd_api.g_true;
1259: else
1260: p_cs_sr_dup_flag := fnd_api.g_false;
1261: end if;
1262: p_cs_sr_dup_link_rec := l_cs_sr_dup_link_rec;

Line 1260: p_cs_sr_dup_flag := fnd_api.g_false;

1256:
1257: if l_dup_counter > 0 then
1258: p_cs_sr_dup_flag := fnd_api.g_true;
1259: else
1260: p_cs_sr_dup_flag := fnd_api.g_false;
1261: end if;
1262: p_cs_sr_dup_link_rec := l_cs_sr_dup_link_rec;
1263:
1264: EXCEPTION

Line 1266: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1262: p_cs_sr_dup_link_rec := l_cs_sr_dup_link_rec;
1263:
1264: EXCEPTION
1265: WHEN OTHERS THEN
1266: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1267: return;
1268: END Check_SR_CustProd_Dup;
1269:
1270:

Line 1393: p_return_status := FND_API.G_RET_STS_SUCCESS;

1389: order by sr.incident_id desc;
1390: l_dup_sr_CustProdItmSerUpd_rec l_dup_sr_CustProdItmSerUpd_csr%rowtype;
1391:
1392: BEGIN
1393: p_return_status := FND_API.G_RET_STS_SUCCESS;
1394: CALCULATE_DUPLICATE_TIME_FRAME( p_duplicate_time_frame => l_duplicate_date);
1395:
1396: l_incident_id := p_incident_id;
1397: l_customer_id := p_customer_id;

Line 1487: p_cs_sr_dup_flag := fnd_api.g_true;

1483:
1484: END IF;
1485:
1486: if l_dup_counter > 0 then
1487: p_cs_sr_dup_flag := fnd_api.g_true;
1488: else
1489: p_cs_sr_dup_flag := fnd_api.g_false;
1490: end if;
1491: p_cs_sr_dup_link_rec := l_cs_sr_dup_link_rec;

Line 1489: p_cs_sr_dup_flag := fnd_api.g_false;

1485:
1486: if l_dup_counter > 0 then
1487: p_cs_sr_dup_flag := fnd_api.g_true;
1488: else
1489: p_cs_sr_dup_flag := fnd_api.g_false;
1490: end if;
1491: p_cs_sr_dup_link_rec := l_cs_sr_dup_link_rec;
1492:
1493: EXCEPTION

Line 1495: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1491: p_cs_sr_dup_link_rec := l_cs_sr_dup_link_rec;
1492:
1493: EXCEPTION
1494: WHEN OTHERS THEN
1495: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1496: return;
1497: END Check_SR_CustProdSerial_Dup;
1498:
1499:

Line 1531: p_return_status := FND_API.G_RET_STS_SUCCESS;

1527: -- end of bug fix 3332447
1528:
1529: BEGIN
1530:
1531: p_return_status := FND_API.G_RET_STS_SUCCESS;
1532: l_loop_dup_rec_tbl := p_dup_found_tbl;
1533:
1534: FOR i IN l_loop_dup_rec_tbl.first..l_loop_dup_rec_tbl.last loop
1535: IF l_loop_dup_rec_tbl(i).incident_link_id is not null THEN

Line 1608: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1604: END LOOP;
1605:
1606: EXCEPTION
1607: WHEN OTHERS THEN
1608: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1609: return;
1610: END Check_Dup_SR_Link;
1611:
1612:

Line 1633: p_return_status := FND_API.G_RET_STS_SUCCESS;

1629: l_sr_dup_rec Sr_Dupl_Tbl;
1630: l_found_incident_id number;
1631:
1632: BEGIN
1633: p_return_status := FND_API.G_RET_STS_SUCCESS;
1634: IF p_ea_attr_dup_flag = fnd_api.g_true THEN
1635:
1636: FOR i in p_cs_ea_dup_rec.first..p_cs_ea_dup_rec.last LOOP
1637: l_counter := l_counter + 1;

Line 1634: IF p_ea_attr_dup_flag = fnd_api.g_true THEN

1630: l_found_incident_id number;
1631:
1632: BEGIN
1633: p_return_status := FND_API.G_RET_STS_SUCCESS;
1634: IF p_ea_attr_dup_flag = fnd_api.g_true THEN
1635:
1636: FOR i in p_cs_ea_dup_rec.first..p_cs_ea_dup_rec.last LOOP
1637: l_counter := l_counter + 1;
1638: l_sr_dup_rec(l_counter).incident_id := p_cs_ea_dup_rec(i).incident_id;

Line 1644: IF p_cs_sr_dup_flag = fnd_api.g_true THEN

1640: END LOOP;
1641:
1642: END IF;
1643:
1644: IF p_cs_sr_dup_flag = fnd_api.g_true THEN
1645: FOR i in p_cs_sr_dup_rec.first..p_cs_sr_dup_rec.last LOOP
1646:
1647: l_included_inList := 'N';
1648: FOR x in p_cs_ea_dup_rec.first..p_cs_ea_dup_Rec.last LOOP

Line 1728: p_duplicate_flag := fnd_api.g_true;

1724: END LOOP;
1725: END IF;
1726:
1727: IF l_counter > 0 THEN
1728: p_duplicate_flag := fnd_api.g_true;
1729: ELSE
1730: p_duplicate_flag := fnd_api.g_false;
1731: END IF;
1732: p_sr_dup_rec := l_sr_dup_rec;

Line 1730: p_duplicate_flag := fnd_api.g_false;

1726:
1727: IF l_counter > 0 THEN
1728: p_duplicate_flag := fnd_api.g_true;
1729: ELSE
1730: p_duplicate_flag := fnd_api.g_false;
1731: END IF;
1732: p_sr_dup_rec := l_sr_dup_rec;
1733:
1734: EXCEPTION

Line 1736: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1732: p_sr_dup_rec := l_sr_dup_rec;
1733:
1734: EXCEPTION
1735: WHEN OTHERS THEN
1736: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1737: return;
1738: END Construct_Unique_List_Dup_Sr;
1739:
1740:

Line 1807: RAISE fnd_api.g_exc_unexpected_error;

1803:
1804: OPEN c_DuplicateTimeInfo_csr;
1805: FETCH c_DuplicateTimeInfo_csr INTO l_DuplicateTimeInfo_rec;
1806: IF (c_DuplicateTimeInfo_csr%NOTFOUND) THEN
1807: RAISE fnd_api.g_exc_unexpected_error;
1808: END IF;
1809:
1810: l_duplicate_uom := l_DuplicateTimeInfo_rec.duplicate_uom;
1811:

Line 1815: RAISE fnd_api.g_exc_unexpected_error;

1811:
1812: OPEN c_UOM_Conversion_Rate_csr;
1813: FETCH c_UOM_Conversion_Rate_csr into l_UOM_Conversion_Rate_rec;
1814: IF (c_UOM_Conversion_Rate_csr%NOTFOUND) THEN
1815: RAISE fnd_api.g_exc_unexpected_error;
1816: END IF;
1817:
1818: IF ( l_DuplicateTimeInfo_rec.duplicate_uom = 'Day') THEN
1819: l_multiple_by := l_DuplicateTimeInfo_rec.duplicate_offset;

Line 1883: RAISE fnd_api.g_exc_unexpected_error;

1879:
1880: OPEN c_UOM_Conversion_Rate_csr;
1881: FETCH c_UOM_Conversion_Rate_csr into l_UOM_Conversion_Rate_rec;
1882: IF (c_UOM_Conversion_Rate_csr%NOTFOUND) THEN
1883: RAISE fnd_api.g_exc_unexpected_error;
1884: END IF;
1885:
1886: l_multiple_by := (l_duplicate_offset*l_UOM_Conversion_Rate_rec.conversion_rate)/24;
1887: