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_UTIL_PKG

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 753: CSM_UTIL_PKG.LOG('Entering CSM_SERVICE_REQUESTS_PKG.APPLY_HA_ATTR_CHANGES for Payload ID ' || p_HA_PAYLOAD_ID ,

749: /*** initialize return status and message list ***/
750: L_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
751: FND_MSG_PUB.INITIALIZE;
752:
753: CSM_UTIL_PKG.LOG('Entering CSM_SERVICE_REQUESTS_PKG.APPLY_HA_ATTR_CHANGES for Payload ID ' || p_HA_PAYLOAD_ID ,
754: 'CSM_SERVICE_REQUESTS_PKG.APPLY_HA_ATTR_CHANGES',FND_LOG.LEVEL_PROCEDURE);
755:
756: IF p_dml_type ='I' THEN
757: -- Process insert

Line 786: CSM_UTIL_PKG.LOG('Leaving CSM_SERVICE_REQUESTS_PKG.APPLY_HA_ATTR_CHANGES for HA ID ' || p_HA_PAYLOAD_ID ,

782: );
783: END IF;
784: X_RETURN_STATUS := l_RETURN_STATUS;
785: x_ERROR_MESSAGE := l_ERROR_MESSAGE;
786: CSM_UTIL_PKG.LOG('Leaving CSM_SERVICE_REQUESTS_PKG.APPLY_HA_ATTR_CHANGES for HA ID ' || p_HA_PAYLOAD_ID ,
787: 'CSM_SERVICE_REQUESTS_PKG.APPLY_HA_ATTR_CHANGES',FND_LOG.LEVEL_PROCEDURE);
788:
789: EXCEPTION WHEN OTHERS THEN
790: CSM_UTIL_PKG.log( 'Exception in CSM_SERVICE_REQUESTS_PKG.APPLY_HA_ATTR_CHANGES: ' || sqlerrm

Line 790: CSM_UTIL_PKG.log( 'Exception in CSM_SERVICE_REQUESTS_PKG.APPLY_HA_ATTR_CHANGES: ' || sqlerrm

786: CSM_UTIL_PKG.LOG('Leaving CSM_SERVICE_REQUESTS_PKG.APPLY_HA_ATTR_CHANGES for HA ID ' || p_HA_PAYLOAD_ID ,
787: 'CSM_SERVICE_REQUESTS_PKG.APPLY_HA_ATTR_CHANGES',FND_LOG.LEVEL_PROCEDURE);
788:
789: EXCEPTION WHEN OTHERS THEN
790: CSM_UTIL_PKG.log( 'Exception in CSM_SERVICE_REQUESTS_PKG.APPLY_HA_ATTR_CHANGES: ' || sqlerrm
791: || ' for HA ID ' || p_HA_PAYLOAD_ID ,'CSM_SERVICE_REQUESTS_PKG.APPLY_HA_ATTR_CHANGES',FND_LOG.LEVEL_EXCEPTION);
792: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
793: X_ERROR_MESSAGE := TO_CHAR(SQLERRM,2000);
794:

Line 812: CSM_UTIL_PKG.LOG('Entering CSM_SERVICE_REQUESTS_PKG.APPLY_HA_LINK_CHANGES for Payload ID ' || p_HA_PAYLOAD_ID ,

808: /*** initialize return status and message list ***/
809: L_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
810: FND_MSG_PUB.INITIALIZE;
811:
812: CSM_UTIL_PKG.LOG('Entering CSM_SERVICE_REQUESTS_PKG.APPLY_HA_LINK_CHANGES for Payload ID ' || p_HA_PAYLOAD_ID ,
813: 'CSM_SERVICE_REQUESTS_PKG.APPLY_HA_LINK_CHANGES',FND_LOG.LEVEL_PROCEDURE);
814:
815: IF p_dml_type ='I' THEN
816: -- Process insert

Line 846: CSM_UTIL_PKG.LOG('Leaving CSM_SERVICE_REQUESTS_PKG.APPLY_HA_LINK_CHANGES for HA ID ' || p_HA_PAYLOAD_ID ,

842: END IF;
843:
844: X_RETURN_STATUS := l_RETURN_STATUS;
845: x_ERROR_MESSAGE := l_ERROR_MESSAGE;
846: CSM_UTIL_PKG.LOG('Leaving CSM_SERVICE_REQUESTS_PKG.APPLY_HA_LINK_CHANGES for HA ID ' || p_HA_PAYLOAD_ID ,
847: 'CSM_SERVICE_REQUESTS_PKG.APPLY_HA_LINK_CHANGES',FND_LOG.LEVEL_PROCEDURE);
848:
849: EXCEPTION WHEN OTHERS THEN
850: CSM_UTIL_PKG.log( 'Exception in CSM_SERVICE_REQUESTS_PKG.APPLY_HA_LINK_CHANGES: ' || sqlerrm

Line 850: CSM_UTIL_PKG.log( 'Exception in CSM_SERVICE_REQUESTS_PKG.APPLY_HA_LINK_CHANGES: ' || sqlerrm

846: CSM_UTIL_PKG.LOG('Leaving CSM_SERVICE_REQUESTS_PKG.APPLY_HA_LINK_CHANGES for HA ID ' || p_HA_PAYLOAD_ID ,
847: 'CSM_SERVICE_REQUESTS_PKG.APPLY_HA_LINK_CHANGES',FND_LOG.LEVEL_PROCEDURE);
848:
849: EXCEPTION WHEN OTHERS THEN
850: CSM_UTIL_PKG.log( 'Exception in CSM_SERVICE_REQUESTS_PKG.APPLY_HA_LINK_CHANGES: ' || sqlerrm
851: || ' for HA ID ' || p_HA_PAYLOAD_ID ,'CSM_SERVICE_REQUESTS_PKG.APPLY_HA_LINK_CHANGES',FND_LOG.LEVEL_EXCEPTION);
852: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
853: X_ERROR_MESSAGE := TO_CHAR(SQLERRM,2000);
854: