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

Line 8: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

4:
5: G_PKG_NAME VARCHAR2(30) := 'CS_SR_STATUS_PROPAGATION_PKG';
6: PROCEDURE VALIDATE_SR_CLOSURE(
7: p_api_version IN NUMBER,
8: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
9: p_commit IN VARCHAR2,
10: p_service_request_id IN NUMBER,
11: p_user_id IN NUMBER,
12: p_resp_appl_id IN NUMBER,

Line 61: x_return_status := FND_API.G_RET_STS_SUCCESS;

57: AND a.source_object_id = p_service_request_id;
58:
59: BEGIN
60:
61: x_return_status := FND_API.G_RET_STS_SUCCESS;
62:
63: /* Check if child is a charge line with charge_line_type = 'Actual'
64: and OM interface flag = 'Y' and charge line is not yet submitted
65: to OM */

Line 93: raise FND_API.G_EXC_ERROR;

89: x_msg_count => l_msg_count,
90: x_msg_data => l_msg_data);
91:
92: IF (l_func_ret_status = FALSE) THEN
93: raise FND_API.G_EXC_ERROR;
94: END IF;
95: ELSE
96:
97: /* Check if child is an open non-field service task */

Line 122: WHEN FND_API.G_EXC_ERROR THEN

118: END IF;
119: END IF;
120: END LOOP;
121: EXCEPTION
122: WHEN FND_API.G_EXC_ERROR THEN
123: x_return_status := FND_API.G_RET_STS_ERROR;
124: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
125: p_data => x_msg_data);
126:

Line 123: x_return_status := FND_API.G_RET_STS_ERROR;

119: END IF;
120: END LOOP;
121: EXCEPTION
122: WHEN FND_API.G_EXC_ERROR THEN
123: x_return_status := FND_API.G_RET_STS_ERROR;
124: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
125: p_data => x_msg_data);
126:
127: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 127: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

123: x_return_status := FND_API.G_RET_STS_ERROR;
124: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
125: p_data => x_msg_data);
126:
127: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
129: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
130: p_data => x_msg_data);
131:

Line 128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

124: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
125: p_data => x_msg_data);
126:
127: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
129: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
130: p_data => x_msg_data);
131:
132: WHEN CS_UNSUBMITTED_CHARGES_EXIST THEN

Line 133: x_return_status := FND_API.G_RET_STS_ERROR;

129: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
130: p_data => x_msg_data);
131:
132: WHEN CS_UNSUBMITTED_CHARGES_EXIST THEN
133: x_return_status := FND_API.G_RET_STS_ERROR;
134: FND_MESSAGE.SET_NAME('CS','CS_SR_OPEN_CHARGES_EXISTS');
135: FND_MSG_PUB.ADD;
136: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
137: p_data => x_msg_data);

Line 140: x_return_status := FND_API.G_RET_STS_ERROR;

136: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
137: p_data => x_msg_data);
138:
139: WHEN CS_OPEN_TASKS_EXIST THEN
140: x_return_status := FND_API.G_RET_STS_ERROR;
141: FND_MESSAGE.SET_NAME('CS','CS_SR_OPEN_TASKS_EXISTS');
142: FND_MSG_PUB.ADD;
143: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
144: p_data => x_msg_data);

Line 146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

142: FND_MSG_PUB.ADD;
143: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
144: p_data => x_msg_data);
145: WHEN OTHERS THEN
146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
147: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
148: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
149: END IF;
150: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

Line 172: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

168: -- varchar2 to varchar2(240)
169: -- -----------------------------------------------------------------------------
170: PROCEDURE CLOSE_SR_CHILDREN(
171: p_api_version IN NUMBER,
172: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
173: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
174: p_validation_required IN VARCHAR2,
175: p_action_required IN VARCHAR2,
176: p_service_request_id IN NUMBER,

Line 173: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

169: -- -----------------------------------------------------------------------------
170: PROCEDURE CLOSE_SR_CHILDREN(
171: p_api_version IN NUMBER,
172: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
173: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
174: p_validation_required IN VARCHAR2,
175: p_action_required IN VARCHAR2,
176: p_service_request_id IN NUMBER,
177: p_user_id IN NUMBER,

Line 221: x_return_status := FND_API.G_RET_STS_SUCCESS;

217: BEGIN
218:
219: SAVEPOINT CLOSE_SR_CHILDREN;
220:
221: x_return_status := FND_API.G_RET_STS_SUCCESS;
222:
223: -- If the auto task close status is null, return immediately
224:
225: FND_PROFILE.GET('CS_SR_TASK_AUTO_CLOSE_STATUS',l_profile_value);

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

239: l_return_status,
240: x_msg_count,
241: x_msg_data);
242:
243: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
244: x_return_status := FND_API.G_RET_STS_ERROR;
245: raise FND_API.G_EXC_ERROR;
246: END IF;
247: END IF;

Line 244: x_return_status := FND_API.G_RET_STS_ERROR;

240: x_msg_count,
241: x_msg_data);
242:
243: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
244: x_return_status := FND_API.G_RET_STS_ERROR;
245: raise FND_API.G_EXC_ERROR;
246: END IF;
247: END IF;
248:

Line 245: raise FND_API.G_EXC_ERROR;

241: x_msg_data);
242:
243: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
244: x_return_status := FND_API.G_RET_STS_ERROR;
245: raise FND_API.G_EXC_ERROR;
246: END IF;
247: END IF;
248:
249: -- Continue with the rest of the flow if action_required = Y

Line 269: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

265: , x_msg_count => x_msg_count
266: , x_msg_data => x_msg_data
267: );
268:
269: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
270: raise FND_API.G_EXC_UNEXPECTED_ERROR;
271: end if;
272: ELSE
273:

Line 270: raise FND_API.G_EXC_UNEXPECTED_ERROR;

266: , x_msg_data => x_msg_data
267: );
268:
269: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
270: raise FND_API.G_EXC_UNEXPECTED_ERROR;
271: end if;
272: ELSE
273:
274: /*

Line 296: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

292: );
293:
294: -- If update_task() API returned error, raise an exception
295:
296: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
297: raise FND_API.G_EXC_UNEXPECTED_ERROR;
298: end if;
299: END IF;
300: END LOOP;

Line 297: raise FND_API.G_EXC_UNEXPECTED_ERROR;

293:
294: -- If update_task() API returned error, raise an exception
295:
296: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
297: raise FND_API.G_EXC_UNEXPECTED_ERROR;
298: end if;
299: END IF;
300: END LOOP;
301: END IF;

Line 305: WHEN FND_API.G_EXC_ERROR THEN

301: END IF;
302: END IF;
303:
304: EXCEPTION
305: WHEN FND_API.G_EXC_ERROR THEN
306: ROLLBACK TO CLOSE_SR_CHILDREN;
307: x_return_status := FND_API.G_RET_STS_ERROR;
308: FND_MSG_PUB.Count_And_Get
309: ( p_count => x_msg_count,

Line 307: x_return_status := FND_API.G_RET_STS_ERROR;

303:
304: EXCEPTION
305: WHEN FND_API.G_EXC_ERROR THEN
306: ROLLBACK TO CLOSE_SR_CHILDREN;
307: x_return_status := FND_API.G_RET_STS_ERROR;
308: FND_MSG_PUB.Count_And_Get
309: ( p_count => x_msg_count,
310: p_data => x_msg_data
311: );

Line 312: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

308: FND_MSG_PUB.Count_And_Get
309: ( p_count => x_msg_count,
310: p_data => x_msg_data
311: );
312: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
313: ROLLBACK TO CLOSE_SR_CHILDREN;
314: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
315: FND_MSG_PUB.Count_And_Get
316: ( p_count => x_msg_count,

Line 314: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

310: p_data => x_msg_data
311: );
312: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
313: ROLLBACK TO CLOSE_SR_CHILDREN;
314: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
315: FND_MSG_PUB.Count_And_Get
316: ( p_count => x_msg_count,
317: p_data => x_msg_data
318: );

Line 321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

317: p_data => x_msg_data
318: );
319: WHEN OTHERS THEN
320: ROLLBACK TO CLOSE_SR_CHILDREN;
321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
322: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
323: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
324: END IF;
325: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

Line 333: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

329:
330:
331: PROCEDURE SR_UPWARD_STATUS_PROPAGATION(
332: p_api_version IN NUMBER,
333: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
334: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
335: p_service_request_id IN NUMBER,
336: p_user_id IN NUMBER,
337: p_resp_appl_id IN NUMBER,

Line 334: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

330:
331: PROCEDURE SR_UPWARD_STATUS_PROPAGATION(
332: p_api_version IN NUMBER,
333: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
334: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
335: p_service_request_id IN NUMBER,
336: p_user_id IN NUMBER,
337: p_resp_appl_id IN NUMBER,
338: p_login_id IN NUMBER DEFAULT NULL,

Line 432: x_return_status := FND_API.G_RET_STS_SUCCESS;

428: BEGIN
429:
430: SAVEPOINT SR_UPWARD_STATUS_PROPAGATION;
431:
432: x_return_status := FND_API.G_RET_STS_SUCCESS;
433:
434: open c_status(p_service_request_id);
435: fetch c_status into l_sr_status;
436: IF (c_status%NOTFOUND) THEN

Line 437: raise FND_API.G_EXC_UNEXPECTED_ERROR;

433:
434: open c_status(p_service_request_id);
435: fetch c_status into l_sr_status;
436: IF (c_status%NOTFOUND) THEN
437: raise FND_API.G_EXC_UNEXPECTED_ERROR;
438: END IF;
439: -- If all the above conditions are satisfied, update SR status
440: -- to 'Close' status. This status is derived fromt the profile
441: -- 'Service : Service Request Auto Close Status'

Line 499: p_validation_level => fnd_api.g_valid_level_none,

495: ( p_api_version => 2.0,
496: p_init_msg_list => p_init_msg_list,
497: p_commit => p_commit,
498: p_resp_id => l_resp_id,
499: p_validation_level => fnd_api.g_valid_level_none,
500: x_return_status => x_return_status,
501: x_msg_count => x_msg_count,
502: x_msg_data => x_msg_data,
503: p_request_id => p_service_request_id,

Line 524: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

520: -- Set the required WF message attributes
521: -- Invoke WF_NOTIFICATION.Send() API to send an independent notificatiom
522: to the service request owner
523: */
524: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
525: OPEN l_cs_sr_get_empid_csr;
526: FETCH l_cs_sr_get_empid_csr INTO l_request_number, l_subject_owner_id;
527:
528: IF( l_cs_sr_get_empid_csr%NOTFOUND OR l_subject_owner_id IS NULL) THEN

Line 570: END IF; /* IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) */

566: avalue => l_owner_role);
567:
568:
569: END IF; /* If (l_owner_role IS NOT NULL) */
570: END IF; /* IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) */
571: /* ROOPA - 12/02/2003 - End*/
572:
573:
574:

Line 578: WHEN FND_API.G_EXC_ERROR THEN

574:
575: END IF;
576:
577: EXCEPTION
578: WHEN FND_API.G_EXC_ERROR THEN
579: ROLLBACK TO SR_UPWARD_STATUS_PROPAGATION;
580: x_return_status := FND_API.G_RET_STS_ERROR;
581: FND_MSG_PUB.Count_And_Get
582: ( p_count => x_msg_count,

Line 580: x_return_status := FND_API.G_RET_STS_ERROR;

576:
577: EXCEPTION
578: WHEN FND_API.G_EXC_ERROR THEN
579: ROLLBACK TO SR_UPWARD_STATUS_PROPAGATION;
580: x_return_status := FND_API.G_RET_STS_ERROR;
581: FND_MSG_PUB.Count_And_Get
582: ( p_count => x_msg_count,
583: p_data => x_msg_data
584: );

Line 585: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

581: FND_MSG_PUB.Count_And_Get
582: ( p_count => x_msg_count,
583: p_data => x_msg_data
584: );
585: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
586: ROLLBACK TO SR_UPWARD_STATUS_PROPAGATION;
587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
588: FND_MSG_PUB.Count_And_Get
589: ( p_count => x_msg_count,

Line 587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

583: p_data => x_msg_data
584: );
585: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
586: ROLLBACK TO SR_UPWARD_STATUS_PROPAGATION;
587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
588: FND_MSG_PUB.Count_And_Get
589: ( p_count => x_msg_count,
590: p_data => x_msg_data
591: );

Line 594: x_return_status := FND_API.G_RET_STS_ERROR;

590: p_data => x_msg_data
591: );
592: WHEN CS_DEPOT_ORDERS_EXIST THEN
593: ROLLBACK TO SR_UPWARD_STATUS_PROPAGATION;
594: x_return_status := FND_API.G_RET_STS_ERROR;
595: FND_MESSAGE.SET_NAME('CS','CS_SR_EAM_ORDERS_EXIST');
596: FND_MSG_PUB.ADD;
597: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
598: p_data => x_msg_data);

Line 601: x_return_status := FND_API.G_RET_STS_ERROR;

597: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
598: p_data => x_msg_data);
599: WHEN CS_EAM_ORDERS_EXIST THEN
600: ROLLBACK TO SR_UPWARD_STATUS_PROPAGATION;
601: x_return_status := FND_API.G_RET_STS_ERROR;
602: FND_MESSAGE.SET_NAME('CS','CS_SR_CMRO_ORDERS_EXIST');
603: FND_MSG_PUB.ADD;
604: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
605: p_data => x_msg_data);

Line 608: x_return_status := FND_API.G_RET_STS_ERROR;

604: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
605: p_data => x_msg_data);
606: WHEN CS_CMRO_ORDERS_EXIST THEN
607: ROLLBACK TO SR_UPWARD_STATUS_PROPAGATION;
608: x_return_status := FND_API.G_RET_STS_ERROR;
609: FND_MESSAGE.SET_NAME('CS','CS_SR_CMRO_ORDERS_EXIST');
610: FND_MSG_PUB.ADD;
611: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
612: p_data => x_msg_data);

Line 615: x_return_status := FND_API.G_RET_STS_ERROR;

611: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
612: p_data => x_msg_data);
613: WHEN CS_UNSUBMITTED_CHARGES_EXIST THEN
614: ROLLBACK TO SR_UPWARD_STATUS_PROPAGATION;
615: x_return_status := FND_API.G_RET_STS_ERROR;
616: FND_MESSAGE.SET_NAME('CS','CS_SR_OPEN_CHARGES_EXISTS');
617: FND_MSG_PUB.ADD;
618: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
619: p_data => x_msg_data);

Line 622: x_return_status := FND_API.G_RET_STS_ERROR;

618: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
619: p_data => x_msg_data);
620: WHEN CS_OPEN_TASKS_EXIST THEN
621: ROLLBACK TO SR_UPWARD_STATUS_PROPAGATION;
622: x_return_status := FND_API.G_RET_STS_ERROR;
623: FND_MESSAGE.SET_NAME('CS','CS_SR_OPEN_TASKS_EXIST');
624: FND_MSG_PUB.ADD;
625: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
626: p_data => x_msg_data);

Line 629: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

625: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
626: p_data => x_msg_data);
627: WHEN OTHERS THEN
628: ROLLBACK TO SR_UPWARD_STATUS_PROPAGATION;
629: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
630: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
631: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
632: END IF;
633: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

Line 635: p_encoded => FND_API.G_FALSE );

631: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
632: END IF;
633: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
634: p_data => x_msg_data,
635: p_encoded => FND_API.G_FALSE );
636: END;
637:
638: END CS_SR_STATUS_PROPAGATION_PKG;