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 FND_API

Line 28: X_Return_Status := Fnd_Api.G_Ret_Sts_Success;

24: l_msg_data VARCHAR2(2000);
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:

Line 118: IF l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

114: X_Object_Version_Number => L_Object_Version_Number, -- new for 1159
115: X_Reciprocal_Link_Id => L_Reciprocal_Link_Id, -- new for 1159
116: X_Link_Id => L_LINK_ID);
117:
118: IF l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
119: X_Return_Status := Fnd_Api.G_Ret_Sts_Error;
120: X_Error_Message := l_Msg_Data;
121: ELSE
122: X_Return_Status := Fnd_Api.G_Ret_Sts_Success;

Line 119: X_Return_Status := Fnd_Api.G_Ret_Sts_Error;

115: X_Reciprocal_Link_Id => L_Reciprocal_Link_Id, -- new for 1159
116: X_Link_Id => L_LINK_ID);
117:
118: IF l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
119: X_Return_Status := Fnd_Api.G_Ret_Sts_Error;
120: X_Error_Message := l_Msg_Data;
121: ELSE
122: X_Return_Status := Fnd_Api.G_Ret_Sts_Success;
123: END IF;

Line 122: X_Return_Status := Fnd_Api.G_Ret_Sts_Success;

118: IF l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
119: X_Return_Status := Fnd_Api.G_Ret_Sts_Error;
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:

Line 129: X_Return_Status := Fnd_Api.G_Ret_Sts_Error;

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;
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:

Line 167: X_Return_Status := Fnd_Api.G_Ret_Sts_Success;

163: WHERE LINK_ID = B_LINK_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:

Line 265: IF l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

261: X_Msg_Data => l_msg_data,
262: X_Object_Version_Number => L_Object_Version_Number -- new for 1159
263: );
264:
265: IF l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
266: X_Return_Status := Fnd_Api.G_Ret_Sts_Error;
267: X_Error_Message := l_Msg_Data;
268: ELSE
269: X_Return_Status := Fnd_Api.G_Ret_Sts_Success;

Line 266: X_Return_Status := Fnd_Api.G_Ret_Sts_Error;

262: X_Object_Version_Number => L_Object_Version_Number -- new for 1159
263: );
264:
265: IF l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
266: X_Return_Status := Fnd_Api.G_Ret_Sts_Error;
267: X_Error_Message := l_Msg_Data;
268: ELSE
269: X_Return_Status := Fnd_Api.G_Ret_Sts_Success;
270: END IF;

Line 269: X_Return_Status := Fnd_Api.G_Ret_Sts_Success;

265: IF l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
266: X_Return_Status := Fnd_Api.G_Ret_Sts_Error;
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:

Line 276: X_Return_Status := Fnd_Api.G_Ret_Sts_Error;

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;
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:

Line 304: X_Return_Status := Fnd_Api.G_Ret_Sts_Success;

300: l_msg_data VARCHAR2(2000);
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:

Line 325: P_Init_Msg_List => FND_API.G_FALSE,

321:
322: --Call the SR link Api
323: Cs_Incidentlinks_Pub.DELETE_INCIDENTLINK (
324: P_Api_Version => L_Api_Version,
325: P_Init_Msg_List => FND_API.G_FALSE,
326: P_Commit => FND_API.G_FALSE,
327: P_Resp_Appl_Id => Null, -- not used
328: P_Resp_Id => Null, -- not used
329: P_User_Id => Fnd_Global.User_Id,

Line 326: P_Commit => FND_API.G_FALSE,

322: --Call the SR link Api
323: Cs_Incidentlinks_Pub.DELETE_INCIDENTLINK (
324: P_Api_Version => L_Api_Version,
325: P_Init_Msg_List => FND_API.G_FALSE,
326: P_Commit => FND_API.G_FALSE,
327: P_Resp_Appl_Id => Null, -- not used
328: P_Resp_Id => Null, -- not used
329: P_User_Id => Fnd_Global.User_Id,
330: P_Login_Id => NULL,

Line 338: IF l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

334: X_Msg_Count => l_msg_count,
335: X_Msg_Data => l_msg_data
336: );
337:
338: IF l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
339: X_Return_Status := Fnd_Api.G_Ret_Sts_Error;
340: X_Error_Message := l_Msg_Data;
341: ELSE
342: X_Return_Status := Fnd_Api.G_Ret_Sts_Success;

Line 339: X_Return_Status := Fnd_Api.G_Ret_Sts_Error;

335: X_Msg_Data => l_msg_data
336: );
337:
338: IF l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
339: X_Return_Status := Fnd_Api.G_Ret_Sts_Error;
340: X_Error_Message := l_Msg_Data;
341: ELSE
342: X_Return_Status := Fnd_Api.G_Ret_Sts_Success;
343: END IF;

Line 342: X_Return_Status := Fnd_Api.G_Ret_Sts_Success;

338: IF l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
339: X_Return_Status := Fnd_Api.G_Ret_Sts_Error;
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:

Line 349: X_Return_Status := Fnd_Api.G_Ret_Sts_Error;

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;
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:

Line 399: l_return_status := Fnd_Api.G_Ret_Sts_Success;

395: l_msg_count NUMBER;
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:

Line 498: IF l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

494: X_Last_Updated_By => L_Last_Updated_By,
495: X_Last_Update_Login => L_Last_Update_Login
496: ) ;
497:
498: IF l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
499: X_Return_Status := Fnd_Api.G_Ret_Sts_Error;
500: X_Error_Message := l_Msg_Data;
501: ELSE
502: X_Return_Status := Fnd_Api.G_Ret_Sts_Success;

Line 499: X_Return_Status := Fnd_Api.G_Ret_Sts_Error;

495: X_Last_Update_Login => L_Last_Update_Login
496: ) ;
497:
498: IF l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
499: X_Return_Status := Fnd_Api.G_Ret_Sts_Error;
500: X_Error_Message := l_Msg_Data;
501: ELSE
502: X_Return_Status := Fnd_Api.G_Ret_Sts_Success;
503: END IF;

Line 502: X_Return_Status := Fnd_Api.G_Ret_Sts_Success;

498: IF l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
499: X_Return_Status := Fnd_Api.G_Ret_Sts_Error;
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:

Line 509: x_return_status := FND_API.G_Ret_Sts_Error;

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;
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:

Line 565: l_return_status := Fnd_Api.G_Ret_Sts_Success;

561: FROM CUG_INCIDNT_ATTR_VALS_B
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:

Line 662: IF l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

658: X_Last_Updated_By => L_Last_Updated_By,
659: X_Last_Update_Login => L_Last_Update_Login
660: ) ;
661:
662: IF l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
663: X_Return_Status := Fnd_Api.G_Ret_Sts_Error;
664: X_Error_Message := l_Msg_Data;
665: ELSE
666: X_Return_Status := Fnd_Api.G_Ret_Sts_Success;

Line 663: X_Return_Status := Fnd_Api.G_Ret_Sts_Error;

659: X_Last_Update_Login => L_Last_Update_Login
660: ) ;
661:
662: IF l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
663: X_Return_Status := Fnd_Api.G_Ret_Sts_Error;
664: X_Error_Message := l_Msg_Data;
665: ELSE
666: X_Return_Status := Fnd_Api.G_Ret_Sts_Success;
667: END IF;

Line 666: X_Return_Status := Fnd_Api.G_Ret_Sts_Success;

662: IF l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
663: X_Return_Status := Fnd_Api.G_Ret_Sts_Error;
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:

Line 673: x_return_status := FND_API.G_Ret_Sts_Error;

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;
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:

Line 696: l_return_status := Fnd_Api.G_Ret_Sts_Success;

692: l_msg_count NUMBER;
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:

Line 720: IF l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

716: (
717: X_Incidnt_Attr_Val_Id => L_Incidnt_Attr_Val_Id
718: ) ;
719:
720: IF l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
721: X_Return_Status := Fnd_Api.G_Ret_Sts_Error;
722: X_Error_Message := l_Msg_Data;
723: ELSE
724: X_Return_Status := Fnd_Api.G_Ret_Sts_Success;

Line 721: X_Return_Status := Fnd_Api.G_Ret_Sts_Error;

717: X_Incidnt_Attr_Val_Id => L_Incidnt_Attr_Val_Id
718: ) ;
719:
720: IF l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
721: X_Return_Status := Fnd_Api.G_Ret_Sts_Error;
722: X_Error_Message := l_Msg_Data;
723: ELSE
724: X_Return_Status := Fnd_Api.G_Ret_Sts_Success;
725: END IF;

Line 724: X_Return_Status := Fnd_Api.G_Ret_Sts_Success;

720: IF l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
721: X_Return_Status := Fnd_Api.G_Ret_Sts_Error;
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:

Line 731: x_return_status := FND_API.G_Ret_Sts_Error;

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;
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:

Line 750: L_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

746: L_RETURN_STATUS VARCHAR2(100);
747: l_ERROR_MESSAGE VARCHAR2(4000);
748: BEGIN
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);

Line 792: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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;
796:

Line 809: L_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

805: L_RETURN_STATUS VARCHAR2(100);
806: l_ERROR_MESSAGE VARCHAR2(4000);
807: BEGIN
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);

Line 852: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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;
856: