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.CSM_SR_ATTRIBUTES_PKG dependencies on CSM_SR_ATTRIBUTES_PKG

Line 1: PACKAGE BODY CSM_SR_ATTRIBUTES_PKG AS

1: PACKAGE BODY CSM_SR_ATTRIBUTES_PKG AS
2: /* $Header: csmusrab.pls 120.1 2011/01/10 10:31:33 saradhak noship $ */
3: error EXCEPTION;
4:
5: PROCEDURE APPLY_SR_LINK_INSERT

Line 29: CSM_UTIL_PKG.LOG('Entering CSM_SR_ATTRIBUTES_PKG.APPLY_SR_LINK_INSERT for HA ID ' || p_HA_PAYLOAD_ID ,

25:
26:
27: BEGIN
28: X_Return_Status := Fnd_Api.G_Ret_Sts_Success;
29: CSM_UTIL_PKG.LOG('Entering CSM_SR_ATTRIBUTES_PKG.APPLY_SR_LINK_INSERT for HA ID ' || p_HA_PAYLOAD_ID ,
30: 'CSM_SR_ATTRIBUTES_PKG.APPLY_SR_LINK_INSERT',FND_LOG.LEVEL_PROCEDURE);
31:
32:
33: -- prepare the SR link for the given SR link

Line 30: 'CSM_SR_ATTRIBUTES_PKG.APPLY_SR_LINK_INSERT',FND_LOG.LEVEL_PROCEDURE);

26:
27: BEGIN
28: X_Return_Status := Fnd_Api.G_Ret_Sts_Success;
29: CSM_UTIL_PKG.LOG('Entering CSM_SR_ATTRIBUTES_PKG.APPLY_SR_LINK_INSERT for HA ID ' || p_HA_PAYLOAD_ID ,
30: 'CSM_SR_ATTRIBUTES_PKG.APPLY_SR_LINK_INSERT',FND_LOG.LEVEL_PROCEDURE);
31:
32:
33: -- prepare the SR link for the given SR link
34:

Line 124: CSM_UTIL_PKG.LOG('Leaving CSM_SR_ATTRIBUTES_PKG.APPLY_SR_LINK_INSERT for HA ID ' || p_HA_PAYLOAD_ID ,

120: X_Error_Message := l_Msg_Data;
121: ELSE
122: X_Return_Status := Fnd_Api.G_Ret_Sts_Success;
123: END IF;
124: CSM_UTIL_PKG.LOG('Leaving CSM_SR_ATTRIBUTES_PKG.APPLY_SR_LINK_INSERT for HA ID ' || p_HA_PAYLOAD_ID ,
125: 'CSM_SR_ATTRIBUTES_PKG.APPLY_SR_LINK_INSERT',Fnd_Log.Level_Procedure);
126:
127: EXCEPTION
128: WHEN OTHERS THEN

Line 125: 'CSM_SR_ATTRIBUTES_PKG.APPLY_SR_LINK_INSERT',Fnd_Log.Level_Procedure);

121: ELSE
122: X_Return_Status := Fnd_Api.G_Ret_Sts_Success;
123: END IF;
124: CSM_UTIL_PKG.LOG('Leaving CSM_SR_ATTRIBUTES_PKG.APPLY_SR_LINK_INSERT for HA ID ' || p_HA_PAYLOAD_ID ,
125: 'CSM_SR_ATTRIBUTES_PKG.APPLY_SR_LINK_INSERT',Fnd_Log.Level_Procedure);
126:
127: EXCEPTION
128: WHEN OTHERS THEN
129: X_Return_Status := Fnd_Api.G_Ret_Sts_Error;

Line 131: CSM_UTIL_PKG.LOG('Leaving CSM_SR_ATTRIBUTES_PKG.APPLY_SR_LINK_INSERT for HA ID ' || p_HA_PAYLOAD_ID ,

127: EXCEPTION
128: WHEN OTHERS THEN
129: X_Return_Status := Fnd_Api.G_Ret_Sts_Error;
130: X_Error_Message := L_Msg_Data;
131: CSM_UTIL_PKG.LOG('Leaving CSM_SR_ATTRIBUTES_PKG.APPLY_SR_LINK_INSERT for HA ID ' || p_HA_PAYLOAD_ID ,
132: 'CSM_SR_ATTRIBUTES_PKG.APPLY_SR_LINK_INSERT',FND_LOG.LEVEL_PROCEDURE);
133:
134: END APPLY_SR_LINK_INSERT;
135:

Line 132: 'CSM_SR_ATTRIBUTES_PKG.APPLY_SR_LINK_INSERT',FND_LOG.LEVEL_PROCEDURE);

128: WHEN OTHERS THEN
129: X_Return_Status := Fnd_Api.G_Ret_Sts_Error;
130: X_Error_Message := L_Msg_Data;
131: CSM_UTIL_PKG.LOG('Leaving CSM_SR_ATTRIBUTES_PKG.APPLY_SR_LINK_INSERT for HA ID ' || p_HA_PAYLOAD_ID ,
132: 'CSM_SR_ATTRIBUTES_PKG.APPLY_SR_LINK_INSERT',FND_LOG.LEVEL_PROCEDURE);
133:
134: END APPLY_SR_LINK_INSERT;
135:
136: ---sr link update

Line 168: CSM_UTIL_PKG.LOG('Entering CSM_SR_ATTRIBUTES_PKG.APPLY_SR_LINK_UPDATE for HA ID ' || p_HA_PAYLOAD_ID ,

164:
165:
166: BEGIN
167: X_Return_Status := Fnd_Api.G_Ret_Sts_Success;
168: CSM_UTIL_PKG.LOG('Entering CSM_SR_ATTRIBUTES_PKG.APPLY_SR_LINK_UPDATE for HA ID ' || p_HA_PAYLOAD_ID ,
169: 'CSM_SR_ATTRIBUTES_PKG.APPLY_SR_LINK_UPDATE',FND_LOG.LEVEL_PROCEDURE);
170:
171:
172: -- prepare the SR link for the given SR link

Line 169: 'CSM_SR_ATTRIBUTES_PKG.APPLY_SR_LINK_UPDATE',FND_LOG.LEVEL_PROCEDURE);

165:
166: BEGIN
167: X_Return_Status := Fnd_Api.G_Ret_Sts_Success;
168: CSM_UTIL_PKG.LOG('Entering CSM_SR_ATTRIBUTES_PKG.APPLY_SR_LINK_UPDATE for HA ID ' || p_HA_PAYLOAD_ID ,
169: 'CSM_SR_ATTRIBUTES_PKG.APPLY_SR_LINK_UPDATE',FND_LOG.LEVEL_PROCEDURE);
170:
171:
172: -- prepare the SR link for the given SR link
173:

Line 271: CSM_UTIL_PKG.LOG('Leaving CSM_SR_ATTRIBUTES_PKG.APPLY_SR_LINK_UPDATE for HA ID ' || p_HA_PAYLOAD_ID ,

267: X_Error_Message := l_Msg_Data;
268: ELSE
269: X_Return_Status := Fnd_Api.G_Ret_Sts_Success;
270: END IF;
271: CSM_UTIL_PKG.LOG('Leaving CSM_SR_ATTRIBUTES_PKG.APPLY_SR_LINK_UPDATE for HA ID ' || p_HA_PAYLOAD_ID ,
272: 'CSM_SR_ATTRIBUTES_PKG.APPLY_SR_LINK_UPDATE',Fnd_Log.Level_Procedure);
273:
274: EXCEPTION
275: WHEN OTHERS THEN

Line 272: 'CSM_SR_ATTRIBUTES_PKG.APPLY_SR_LINK_UPDATE',Fnd_Log.Level_Procedure);

268: ELSE
269: X_Return_Status := Fnd_Api.G_Ret_Sts_Success;
270: END IF;
271: CSM_UTIL_PKG.LOG('Leaving CSM_SR_ATTRIBUTES_PKG.APPLY_SR_LINK_UPDATE for HA ID ' || p_HA_PAYLOAD_ID ,
272: 'CSM_SR_ATTRIBUTES_PKG.APPLY_SR_LINK_UPDATE',Fnd_Log.Level_Procedure);
273:
274: EXCEPTION
275: WHEN OTHERS THEN
276: X_Return_Status := Fnd_Api.G_Ret_Sts_Error;

Line 278: CSM_UTIL_PKG.LOG('Leaving CSM_SR_ATTRIBUTES_PKG.APPLY_SR_LINK_UPDATE for HA ID ' || p_HA_PAYLOAD_ID ,

274: EXCEPTION
275: WHEN OTHERS THEN
276: X_Return_Status := Fnd_Api.G_Ret_Sts_Error;
277: X_Error_Message := L_Msg_Data;
278: CSM_UTIL_PKG.LOG('Leaving CSM_SR_ATTRIBUTES_PKG.APPLY_SR_LINK_UPDATE for HA ID ' || p_HA_PAYLOAD_ID ,
279: 'CSM_SR_ATTRIBUTES_PKG.APPLY_SR_LINK_UPDATE',FND_LOG.LEVEL_PROCEDURE);
280:
281: END APPLY_SR_LINK_UPDATE;
282: --sr link update ends

Line 279: 'CSM_SR_ATTRIBUTES_PKG.APPLY_SR_LINK_UPDATE',FND_LOG.LEVEL_PROCEDURE);

275: WHEN OTHERS THEN
276: X_Return_Status := Fnd_Api.G_Ret_Sts_Error;
277: X_Error_Message := L_Msg_Data;
278: CSM_UTIL_PKG.LOG('Leaving CSM_SR_ATTRIBUTES_PKG.APPLY_SR_LINK_UPDATE for HA ID ' || p_HA_PAYLOAD_ID ,
279: 'CSM_SR_ATTRIBUTES_PKG.APPLY_SR_LINK_UPDATE',FND_LOG.LEVEL_PROCEDURE);
280:
281: END APPLY_SR_LINK_UPDATE;
282: --sr link update ends
283: --sr link delete starts

Line 305: CSM_UTIL_PKG.LOG('Entering CSM_SR_ATTRIBUTES_PKG.APPLY_SR_LINK_DELETE for HA ID ' || p_HA_PAYLOAD_ID ,

301:
302:
303: BEGIN
304: X_Return_Status := Fnd_Api.G_Ret_Sts_Success;
305: CSM_UTIL_PKG.LOG('Entering CSM_SR_ATTRIBUTES_PKG.APPLY_SR_LINK_DELETE for HA ID ' || p_HA_PAYLOAD_ID ,
306: 'CSM_SR_ATTRIBUTES_PKG.APPLY_SR_LINK_DELETE',FND_LOG.LEVEL_PROCEDURE);
307:
308:
309: -- prepare the SR link for the given SR link

Line 306: 'CSM_SR_ATTRIBUTES_PKG.APPLY_SR_LINK_DELETE',FND_LOG.LEVEL_PROCEDURE);

302:
303: BEGIN
304: X_Return_Status := Fnd_Api.G_Ret_Sts_Success;
305: CSM_UTIL_PKG.LOG('Entering CSM_SR_ATTRIBUTES_PKG.APPLY_SR_LINK_DELETE for HA ID ' || p_HA_PAYLOAD_ID ,
306: 'CSM_SR_ATTRIBUTES_PKG.APPLY_SR_LINK_DELETE',FND_LOG.LEVEL_PROCEDURE);
307:
308:
309: -- prepare the SR link for the given SR link
310: L_API_VERSION := 2.0;

Line 344: CSM_UTIL_PKG.LOG('Leaving CSM_SR_ATTRIBUTES_PKG.APPLY_SR_LINK_DELETE for HA ID ' || p_HA_PAYLOAD_ID ,

340: X_Error_Message := l_Msg_Data;
341: ELSE
342: X_Return_Status := Fnd_Api.G_Ret_Sts_Success;
343: END IF;
344: CSM_UTIL_PKG.LOG('Leaving CSM_SR_ATTRIBUTES_PKG.APPLY_SR_LINK_DELETE for HA ID ' || p_HA_PAYLOAD_ID ,
345: 'CSM_SR_ATTRIBUTES_PKG.APPLY_SR_LINK_DELETE',Fnd_Log.Level_Procedure);
346:
347: EXCEPTION
348: WHEN OTHERS THEN

Line 345: 'CSM_SR_ATTRIBUTES_PKG.APPLY_SR_LINK_DELETE',Fnd_Log.Level_Procedure);

341: ELSE
342: X_Return_Status := Fnd_Api.G_Ret_Sts_Success;
343: END IF;
344: CSM_UTIL_PKG.LOG('Leaving CSM_SR_ATTRIBUTES_PKG.APPLY_SR_LINK_DELETE for HA ID ' || p_HA_PAYLOAD_ID ,
345: 'CSM_SR_ATTRIBUTES_PKG.APPLY_SR_LINK_DELETE',Fnd_Log.Level_Procedure);
346:
347: EXCEPTION
348: WHEN OTHERS THEN
349: X_Return_Status := Fnd_Api.G_Ret_Sts_Error;

Line 351: CSM_UTIL_PKG.LOG('Leaving CSM_SR_ATTRIBUTES_PKG.APPLY_SR_LINK_DELETE for HA ID ' || p_HA_PAYLOAD_ID ,

347: EXCEPTION
348: WHEN OTHERS THEN
349: X_Return_Status := Fnd_Api.G_Ret_Sts_Error;
350: X_Error_Message := L_Msg_Data;
351: CSM_UTIL_PKG.LOG('Leaving CSM_SR_ATTRIBUTES_PKG.APPLY_SR_LINK_DELETE for HA ID ' || p_HA_PAYLOAD_ID ,
352: 'CSM_SR_ATTRIBUTES_PKG.APPLY_SR_LINK_DELETE',FND_LOG.LEVEL_PROCEDURE);
353:
354: END APPLY_SR_LINK_DELETE;
355: --sr link delete ends

Line 352: 'CSM_SR_ATTRIBUTES_PKG.APPLY_SR_LINK_DELETE',FND_LOG.LEVEL_PROCEDURE);

348: WHEN OTHERS THEN
349: X_Return_Status := Fnd_Api.G_Ret_Sts_Error;
350: X_Error_Message := L_Msg_Data;
351: CSM_UTIL_PKG.LOG('Leaving CSM_SR_ATTRIBUTES_PKG.APPLY_SR_LINK_DELETE for HA ID ' || p_HA_PAYLOAD_ID ,
352: 'CSM_SR_ATTRIBUTES_PKG.APPLY_SR_LINK_DELETE',FND_LOG.LEVEL_PROCEDURE);
353:
354: END APPLY_SR_LINK_DELETE;
355: --sr link delete ends
356: --SR Attributes insert

Line 400: CSM_UTIL_PKG.LOG('Entering CSM_SR_ATTRIBUTES_PKG.APPLY_SR_ATTR_INSERT for HA ID ' || p_HA_PAYLOAD_ID ,

396: l_msg_data VARCHAR2(2000);
397:
398: BEGIN
399: l_return_status := Fnd_Api.G_Ret_Sts_Success;
400: CSM_UTIL_PKG.LOG('Entering CSM_SR_ATTRIBUTES_PKG.APPLY_SR_ATTR_INSERT for HA ID ' || p_HA_PAYLOAD_ID ,
401: 'CSM_SR_ATTRIBUTES_PKG.APPLY_SR_ATTR_INSERT',FND_LOG.LEVEL_PROCEDURE);
402:
403:
404: -- prepare the SR link for the given SR link

Line 401: 'CSM_SR_ATTRIBUTES_PKG.APPLY_SR_ATTR_INSERT',FND_LOG.LEVEL_PROCEDURE);

397:
398: BEGIN
399: l_return_status := Fnd_Api.G_Ret_Sts_Success;
400: CSM_UTIL_PKG.LOG('Entering CSM_SR_ATTRIBUTES_PKG.APPLY_SR_ATTR_INSERT for HA ID ' || p_HA_PAYLOAD_ID ,
401: 'CSM_SR_ATTRIBUTES_PKG.APPLY_SR_ATTR_INSERT',FND_LOG.LEVEL_PROCEDURE);
402:
403:
404: -- prepare the SR link for the given SR link
405:

Line 504: CSM_UTIL_PKG.LOG('Leaving CSM_SR_ATTRIBUTES_PKG.APPLY_SR_ATTR_INSERT for HA ID ' || p_HA_PAYLOAD_ID ,

500: X_Error_Message := l_Msg_Data;
501: ELSE
502: X_Return_Status := Fnd_Api.G_Ret_Sts_Success;
503: END IF;
504: CSM_UTIL_PKG.LOG('Leaving CSM_SR_ATTRIBUTES_PKG.APPLY_SR_ATTR_INSERT for HA ID ' || p_HA_PAYLOAD_ID ,
505: 'CSM_SR_ATTRIBUTES_PKG.APPLY_SR_ATTR_INSERT',Fnd_Log.Level_Procedure);
506:
507: EXCEPTION
508: WHEN OTHERS THEN

Line 505: 'CSM_SR_ATTRIBUTES_PKG.APPLY_SR_ATTR_INSERT',Fnd_Log.Level_Procedure);

501: ELSE
502: X_Return_Status := Fnd_Api.G_Ret_Sts_Success;
503: END IF;
504: CSM_UTIL_PKG.LOG('Leaving CSM_SR_ATTRIBUTES_PKG.APPLY_SR_ATTR_INSERT for HA ID ' || p_HA_PAYLOAD_ID ,
505: 'CSM_SR_ATTRIBUTES_PKG.APPLY_SR_ATTR_INSERT',Fnd_Log.Level_Procedure);
506:
507: EXCEPTION
508: WHEN OTHERS THEN
509: x_return_status := FND_API.G_Ret_Sts_Error;

Line 511: CSM_UTIL_PKG.LOG('Leaving CSM_SR_ATTRIBUTES_PKG.APPLY_SR_ATTR_INSERT for HA ID ' || p_HA_PAYLOAD_ID ,

507: EXCEPTION
508: WHEN OTHERS THEN
509: x_return_status := FND_API.G_Ret_Sts_Error;
510: X_Error_Message := L_Msg_Data;
511: CSM_UTIL_PKG.LOG('Leaving CSM_SR_ATTRIBUTES_PKG.APPLY_SR_ATTR_INSERT for HA ID ' || p_HA_PAYLOAD_ID ,
512: 'CSM_SR_ATTRIBUTES_PKG.APPLY_SR_ATTR_INSERT',FND_LOG.LEVEL_PROCEDURE);
513:
514: End APPLY_SR_ATTR_INSERT;
515:

Line 512: 'CSM_SR_ATTRIBUTES_PKG.APPLY_SR_ATTR_INSERT',FND_LOG.LEVEL_PROCEDURE);

508: WHEN OTHERS THEN
509: x_return_status := FND_API.G_Ret_Sts_Error;
510: X_Error_Message := L_Msg_Data;
511: CSM_UTIL_PKG.LOG('Leaving CSM_SR_ATTRIBUTES_PKG.APPLY_SR_ATTR_INSERT for HA ID ' || p_HA_PAYLOAD_ID ,
512: 'CSM_SR_ATTRIBUTES_PKG.APPLY_SR_ATTR_INSERT',FND_LOG.LEVEL_PROCEDURE);
513:
514: End APPLY_SR_ATTR_INSERT;
515:
516: --SR Attributes UPDATE

Line 566: CSM_UTIL_PKG.LOG('Entering CSM_SR_ATTRIBUTES_PKG.APPLY_SR_ATTR_UPDATE for HA ID ' || p_HA_PAYLOAD_ID ,

562: WHERE INCIDNT_ATTR_VAL_ID = B_INCIDNT_ATTR_VAL_ID;
563:
564: BEGIN
565: l_return_status := Fnd_Api.G_Ret_Sts_Success;
566: CSM_UTIL_PKG.LOG('Entering CSM_SR_ATTRIBUTES_PKG.APPLY_SR_ATTR_UPDATE for HA ID ' || p_HA_PAYLOAD_ID ,
567: 'CSM_SR_ATTRIBUTES_PKG.APPLY_SR_ATTR_UPDATE',FND_LOG.LEVEL_PROCEDURE);
568:
569:
570: -- prepare the SR link for the given SR link

Line 567: 'CSM_SR_ATTRIBUTES_PKG.APPLY_SR_ATTR_UPDATE',FND_LOG.LEVEL_PROCEDURE);

563:
564: BEGIN
565: l_return_status := Fnd_Api.G_Ret_Sts_Success;
566: CSM_UTIL_PKG.LOG('Entering CSM_SR_ATTRIBUTES_PKG.APPLY_SR_ATTR_UPDATE for HA ID ' || p_HA_PAYLOAD_ID ,
567: 'CSM_SR_ATTRIBUTES_PKG.APPLY_SR_ATTR_UPDATE',FND_LOG.LEVEL_PROCEDURE);
568:
569:
570: -- prepare the SR link for the given SR link
571:

Line 668: CSM_UTIL_PKG.LOG('Leaving CSM_SR_ATTRIBUTES_PKG.APPLY_SR_ATTR_UPDATE for HA ID ' || p_HA_PAYLOAD_ID ,

664: X_Error_Message := l_Msg_Data;
665: ELSE
666: X_Return_Status := Fnd_Api.G_Ret_Sts_Success;
667: END IF;
668: CSM_UTIL_PKG.LOG('Leaving CSM_SR_ATTRIBUTES_PKG.APPLY_SR_ATTR_UPDATE for HA ID ' || p_HA_PAYLOAD_ID ,
669: 'CSM_SR_ATTRIBUTES_PKG.APPLY_SR_ATTR_UPDATE',Fnd_Log.Level_Procedure);
670:
671: EXCEPTION
672: WHEN OTHERS THEN

Line 669: 'CSM_SR_ATTRIBUTES_PKG.APPLY_SR_ATTR_UPDATE',Fnd_Log.Level_Procedure);

665: ELSE
666: X_Return_Status := Fnd_Api.G_Ret_Sts_Success;
667: END IF;
668: CSM_UTIL_PKG.LOG('Leaving CSM_SR_ATTRIBUTES_PKG.APPLY_SR_ATTR_UPDATE for HA ID ' || p_HA_PAYLOAD_ID ,
669: 'CSM_SR_ATTRIBUTES_PKG.APPLY_SR_ATTR_UPDATE',Fnd_Log.Level_Procedure);
670:
671: EXCEPTION
672: WHEN OTHERS THEN
673: x_return_status := FND_API.G_Ret_Sts_Error;

Line 675: CSM_UTIL_PKG.LOG('Leaving CSM_SR_ATTRIBUTES_PKG.APPLY_SR_ATTR_UPDATE for HA ID ' || p_HA_PAYLOAD_ID ,

671: EXCEPTION
672: WHEN OTHERS THEN
673: x_return_status := FND_API.G_Ret_Sts_Error;
674: X_Error_Message := L_Msg_Data;
675: CSM_UTIL_PKG.LOG('Leaving CSM_SR_ATTRIBUTES_PKG.APPLY_SR_ATTR_UPDATE for HA ID ' || p_HA_PAYLOAD_ID ,
676: 'CSM_SR_ATTRIBUTES_PKG.APPLY_SR_ATTR_UPDATE',FND_LOG.LEVEL_PROCEDURE);
677:
678: END APPLY_SR_ATTR_UPDATE;
679:

Line 676: 'CSM_SR_ATTRIBUTES_PKG.APPLY_SR_ATTR_UPDATE',FND_LOG.LEVEL_PROCEDURE);

672: WHEN OTHERS THEN
673: x_return_status := FND_API.G_Ret_Sts_Error;
674: X_Error_Message := L_Msg_Data;
675: CSM_UTIL_PKG.LOG('Leaving CSM_SR_ATTRIBUTES_PKG.APPLY_SR_ATTR_UPDATE for HA ID ' || p_HA_PAYLOAD_ID ,
676: 'CSM_SR_ATTRIBUTES_PKG.APPLY_SR_ATTR_UPDATE',FND_LOG.LEVEL_PROCEDURE);
677:
678: END APPLY_SR_ATTR_UPDATE;
679:
680: --SR Attributes DELETE

Line 697: CSM_UTIL_PKG.LOG('Entering CSM_SR_ATTRIBUTES_PKG.APPLY_SR_ATTR_DELETE for HA ID ' || p_HA_PAYLOAD_ID ,

693: l_msg_data VARCHAR2(2000);
694:
695: BEGIN
696: l_return_status := Fnd_Api.G_Ret_Sts_Success;
697: CSM_UTIL_PKG.LOG('Entering CSM_SR_ATTRIBUTES_PKG.APPLY_SR_ATTR_DELETE for HA ID ' || p_HA_PAYLOAD_ID ,
698: 'CSM_SR_ATTRIBUTES_PKG.APPLY_SR_ATTR_DELETE',FND_LOG.LEVEL_PROCEDURE);
699:
700:
701: -- prepare the SR link for the given SR link

Line 698: 'CSM_SR_ATTRIBUTES_PKG.APPLY_SR_ATTR_DELETE',FND_LOG.LEVEL_PROCEDURE);

694:
695: BEGIN
696: l_return_status := Fnd_Api.G_Ret_Sts_Success;
697: CSM_UTIL_PKG.LOG('Entering CSM_SR_ATTRIBUTES_PKG.APPLY_SR_ATTR_DELETE for HA ID ' || p_HA_PAYLOAD_ID ,
698: 'CSM_SR_ATTRIBUTES_PKG.APPLY_SR_ATTR_DELETE',FND_LOG.LEVEL_PROCEDURE);
699:
700:
701: -- prepare the SR link for the given SR link
702:

Line 726: CSM_UTIL_PKG.LOG('Leaving CSM_SR_ATTRIBUTES_PKG.APPLY_SR_ATTR_DELETE for HA ID ' || p_HA_PAYLOAD_ID ,

722: X_Error_Message := l_Msg_Data;
723: ELSE
724: X_Return_Status := Fnd_Api.G_Ret_Sts_Success;
725: END IF;
726: CSM_UTIL_PKG.LOG('Leaving CSM_SR_ATTRIBUTES_PKG.APPLY_SR_ATTR_DELETE for HA ID ' || p_HA_PAYLOAD_ID ,
727: 'CSM_SR_ATTRIBUTES_PKG.APPLY_SR_ATTR_DELETE',Fnd_Log.Level_Procedure);
728:
729: EXCEPTION
730: WHEN OTHERS THEN

Line 727: 'CSM_SR_ATTRIBUTES_PKG.APPLY_SR_ATTR_DELETE',Fnd_Log.Level_Procedure);

723: ELSE
724: X_Return_Status := Fnd_Api.G_Ret_Sts_Success;
725: END IF;
726: CSM_UTIL_PKG.LOG('Leaving CSM_SR_ATTRIBUTES_PKG.APPLY_SR_ATTR_DELETE for HA ID ' || p_HA_PAYLOAD_ID ,
727: 'CSM_SR_ATTRIBUTES_PKG.APPLY_SR_ATTR_DELETE',Fnd_Log.Level_Procedure);
728:
729: EXCEPTION
730: WHEN OTHERS THEN
731: x_return_status := FND_API.G_Ret_Sts_Error;

Line 733: CSM_UTIL_PKG.LOG('Leaving CSM_SR_ATTRIBUTES_PKG.APPLY_SR_ATTR_DELETE for HA ID ' || p_HA_PAYLOAD_ID ,

729: EXCEPTION
730: WHEN OTHERS THEN
731: x_return_status := FND_API.G_Ret_Sts_Error;
732: X_Error_Message := L_Msg_Data;
733: CSM_UTIL_PKG.LOG('Leaving CSM_SR_ATTRIBUTES_PKG.APPLY_SR_ATTR_DELETE for HA ID ' || p_HA_PAYLOAD_ID ,
734: 'CSM_SR_ATTRIBUTES_PKG.APPLY_SR_ATTR_DELETE',FND_LOG.LEVEL_PROCEDURE);
735:
736: END APPLY_SR_ATTR_DELETE;
737:

Line 734: 'CSM_SR_ATTRIBUTES_PKG.APPLY_SR_ATTR_DELETE',FND_LOG.LEVEL_PROCEDURE);

730: WHEN OTHERS THEN
731: x_return_status := FND_API.G_Ret_Sts_Error;
732: X_Error_Message := L_Msg_Data;
733: CSM_UTIL_PKG.LOG('Leaving CSM_SR_ATTRIBUTES_PKG.APPLY_SR_ATTR_DELETE for HA ID ' || p_HA_PAYLOAD_ID ,
734: 'CSM_SR_ATTRIBUTES_PKG.APPLY_SR_ATTR_DELETE',FND_LOG.LEVEL_PROCEDURE);
735:
736: END APPLY_SR_ATTR_DELETE;
737:
738: PROCEDURE APPLY_HA_ATTR_CHANGES

Line 857: END CSM_SR_ATTRIBUTES_PKG;

853: X_ERROR_MESSAGE := TO_CHAR(SQLERRM,2000);
854:
855: END APPLY_HA_LINK_CHANGES;
856:
857: END CSM_SR_ATTRIBUTES_PKG;