DBA Data[Home] [Help]

APPS.CSM_SR_ATTRIBUTES_PKG dependencies on FND_LOG

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 754: 'CSM_SERVICE_REQUESTS_PKG.APPLY_HA_ATTR_CHANGES',FND_LOG.LEVEL_PROCEDURE);

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
758: APPLY_SR_ATTR_INSERT

Line 787: 'CSM_SERVICE_REQUESTS_PKG.APPLY_HA_ATTR_CHANGES',FND_LOG.LEVEL_PROCEDURE);

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
791: || ' for HA ID ' || p_HA_PAYLOAD_ID ,'CSM_SERVICE_REQUESTS_PKG.APPLY_HA_ATTR_CHANGES',FND_LOG.LEVEL_EXCEPTION);

Line 791: || ' for HA ID ' || p_HA_PAYLOAD_ID ,'CSM_SERVICE_REQUESTS_PKG.APPLY_HA_ATTR_CHANGES',FND_LOG.LEVEL_EXCEPTION);

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:
795: END APPLY_HA_ATTR_CHANGES;

Line 813: 'CSM_SERVICE_REQUESTS_PKG.APPLY_HA_LINK_CHANGES',FND_LOG.LEVEL_PROCEDURE);

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
817: APPLY_SR_LINK_INSERT

Line 847: 'CSM_SERVICE_REQUESTS_PKG.APPLY_HA_LINK_CHANGES',FND_LOG.LEVEL_PROCEDURE);

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
851: || ' for HA ID ' || p_HA_PAYLOAD_ID ,'CSM_SERVICE_REQUESTS_PKG.APPLY_HA_LINK_CHANGES',FND_LOG.LEVEL_EXCEPTION);

Line 851: || ' for HA ID ' || p_HA_PAYLOAD_ID ,'CSM_SERVICE_REQUESTS_PKG.APPLY_HA_LINK_CHANGES',FND_LOG.LEVEL_EXCEPTION);

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:
855: END APPLY_HA_LINK_CHANGES;