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_WF_PKG dependencies on FND_LOG

Line 284: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_WF_PKG.TASK_POST_INS',FND_LOG.LEVEL_EXCEPTION);

280: l_sqlerrno := to_char(SQLCODE);
281: l_sqlerrmsg := substr(SQLERRM, 1,2000);
282: l_error_msg := ' Exception in TASK_POST_INS for task_id:'
283: || to_char(l_task_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
284: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_WF_PKG.TASK_POST_INS',FND_LOG.LEVEL_EXCEPTION);
285: END TASK_POST_INS;
286:
287:
288: /* Starts TASK_DEL workflow, Should be called when new SR is created */

Line 318: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_WF_PKG.TASK_POST_DEL',FND_LOG.LEVEL_EXCEPTION);

314: l_sqlerrno := to_char(SQLCODE);
315: l_sqlerrmsg := substr(SQLERRM, 1,2000);
316: l_error_msg := ' Exception in TASK_POST_DEL for task_id:'
317: || to_char(l_task_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
318: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_WF_PKG.TASK_POST_DEL',FND_LOG.LEVEL_EXCEPTION);
319: END TASK_POST_DEL;
320:
321: /* Task_Assignment_Post_Ins
322: */

Line 434: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_WF_PKG.Task_Assignment_Post_Ins',FND_LOG.LEVEL_EXCEPTION);

430: l_sqlerrno := to_char(SQLCODE);
431: l_sqlerrmsg := substr(SQLERRM, 1,2000);
432: l_error_msg := l_error_msg || '-Exception for Task_Assignment_Post_Ins :' || TO_CHAR(l_task_assignment_id)
433: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
434: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_WF_PKG.Task_Assignment_Post_Ins',FND_LOG.LEVEL_EXCEPTION);
435: END Task_Assignment_Post_Ins;
436:
437: /*-----------------------------------------------------------------
438: Description:

Line 514: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_WF_PKG.Task_Assignment_Pre_Upd',FND_LOG.LEVEL_EXCEPTION);

510: l_sqlerrno := to_char(SQLCODE);
511: l_sqlerrmsg := substr(SQLERRM, 1,2000);
512: l_error_msg := l_error_msg || '-Exception for Task_Assignment_Pre_Upd :' || TO_CHAR(l_task_assignment_id)
513: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
514: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_WF_PKG.Task_Assignment_Pre_Upd',FND_LOG.LEVEL_EXCEPTION);
515: END Task_Assignment_Pre_Upd;
516:
517: PROCEDURE Task_Assignment_Post_Upd(
518: x_return_status OUT NOCOPY VARCHAR2

Line 614: 'CSM_WF_PKG.Task_Assignment_Post_Upd',FND_LOG.LEVEL_PROCEDURE);

610: RETURN;
611: END IF;
612:
613: CSM_UTIL_PKG.LOG('Entering CSM_WF_PKG.Task_Assignment_Post_Upd for task_assg_id:' || l_task_assignment_id ,
614: 'CSM_WF_PKG.Task_Assignment_Post_Upd',FND_LOG.LEVEL_PROCEDURE);
615:
616: -- initialise the flags
617: l_is_resource_updated := 'N';
618: l_is_assg_status_updated := 'N';

Line 691: 'CSM_WF_PKG.Task_Assignment_Post_Upd',FND_LOG.LEVEL_PROCEDURE);

687: -- if old_resource_id and new resource_id are not mobile users then return
688: IF (( NOT CSM_UTIL_PKG.is_palm_resource(g_task_ass_pre_upd_rec.resource_id)) AND
689: ( NOT CSM_UTIL_PKG.is_palm_resource(l_task_ass_post_upd_rec.resource_id))) THEN
690: CSM_UTIL_PKG.LOG('No mobile resource for task_assg_id:' || l_task_assignment_id ,
691: 'CSM_WF_PKG.Task_Assignment_Post_Upd',FND_LOG.LEVEL_PROCEDURE);
692: RETURN;
693: END IF;
694:
695: -- And check if resource id has changed

Line 699: 'CSM_WF_PKG.Task_Assignment_Post_Upd',FND_LOG.LEVEL_PROCEDURE);

695: -- And check if resource id has changed
696: IF g_task_ass_pre_upd_rec.resource_id <> l_task_ass_post_upd_rec.resource_id
697: THEN
698: CSM_UTIL_PKG.LOG('Resource updated for task_assg_id:' || l_task_assignment_id ,
699: 'CSM_WF_PKG.Task_Assignment_Post_Upd',FND_LOG.LEVEL_PROCEDURE);
700:
701: l_is_resource_updated := 'Y';
702: OPEN l_check_acc_exists(l_task_assignment_id);
703: FETCH l_check_acc_exists INTO l_dummy;

Line 725: 'CSM_WF_PKG.Task_Assignment_Post_Upd',FND_LOG.LEVEL_PROCEDURE);

721: -- And check if task_assignment_status has changed
722: IF g_task_ass_pre_upd_rec.assignment_status_id <> l_task_ass_post_upd_rec.assignment_status_id
723: THEN
724: CSM_UTIL_PKG.LOG('Status updated for task_assg_id:' || l_task_assignment_id ,
725: 'CSM_WF_PKG.Task_Assignment_Post_Upd',FND_LOG.LEVEL_PROCEDURE);
726:
727: l_is_assg_status_updated := 'Y';
728:
729: -- if both are not downloadable, or both are downloadable, UPDATE process

Line 737: 'CSM_WF_PKG.Task_Assignment_Post_Upd',FND_LOG.LEVEL_PROCEDURE);

733: IF ( ( NOT IS_TASK_STATUS_DOWNLOADABLE(g_task_ass_pre_upd_rec.task_id, g_task_ass_pre_upd_rec.assignment_status_id))
734: AND IS_TASK_STATUS_DOWNLOADABLE(l_task_ass_post_upd_rec.task_id, l_task_ass_post_upd_rec.assignment_status_id)
735: AND l_is_resource_updated = 'N') THEN
736: CSM_UTIL_PKG.LOG('Status updated to downloadable for task_assg_id:' || l_task_assignment_id ,
737: 'CSM_WF_PKG.Task_Assignment_Post_Upd',FND_LOG.LEVEL_PROCEDURE);
738:
739: -- Task_Assignment_Post_Ins( x_return_status );
740: csm_task_assignment_event_pkg.task_assignment_initializer(p_task_assignment_id=>l_task_assignment_id,
741: p_error_msg=>l_error_msg,

Line 754: 'CSM_WF_PKG.Task_Assignment_Post_Upd',FND_LOG.LEVEL_PROCEDURE);

750: IF ( IS_TASK_STATUS_DOWNLOADABLE(g_task_ass_pre_upd_rec.task_id, g_task_ass_pre_upd_rec.assignment_status_id )
751: AND (NOT IS_TASK_STATUS_DOWNLOADABLE(l_task_ass_post_upd_rec.task_id, l_task_ass_post_upd_rec.assignment_status_id))
752: AND l_is_resource_updated = 'N') THEN
753: CSM_UTIL_PKG.LOG('Status updated to non-downloadable for task_assg_id:' || l_task_assignment_id ,
754: 'CSM_WF_PKG.Task_Assignment_Post_Upd',FND_LOG.LEVEL_PROCEDURE);
755:
756: Task_Assignment_Post_Del( x_return_status );
757: RETURN;
758: END IF;

Line 793: 'CSM_WF_PKG.Task_Assignment_Post_Upd',FND_LOG.LEVEL_PROCEDURE);

789: END IF;
790: END IF;
791:
792: CSM_UTIL_PKG.LOG('Leaving CSM_WF_PKG.Task_Assignment_Post_Upd for task_assg_id:' || l_task_assignment_id ,
793: 'CSM_WF_PKG.Task_Assignment_Post_Upd',FND_LOG.LEVEL_PROCEDURE);
794:
795: EXCEPTION
796: WHEN OTHERS THEN
797: x_return_status := FND_API.G_RET_STS_ERROR;

Line 802: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_WF_PKG.Task_Assignment_Post_Upd',FND_LOG.LEVEL_EXCEPTION);

798: l_sqlerrno := to_char(SQLCODE);
799: l_sqlerrmsg := substr(SQLERRM, 1,2000);
800: l_error_msg := l_error_msg || '-Exception for Task_Assignment_Post_Upd :' || TO_CHAR(l_task_assignment_id)
801: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
802: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_WF_PKG.Task_Assignment_Post_Upd',FND_LOG.LEVEL_EXCEPTION);
803: END Task_Assignment_Post_Upd;
804:
805: /*--------------------------------------------------------
806: Description:

Line 845: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_WF_PKG.Task_Assignment_Post_Del',FND_LOG.LEVEL_EXCEPTION);

841: l_sqlerrno := to_char(SQLCODE);
842: l_sqlerrmsg := substr(SQLERRM, 1,2000);
843: l_error_msg := l_error_msg || '-Exception for Task_Assignment_Post_Del :' || TO_CHAR(l_task_assignment_id)
844: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
845: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_WF_PKG.Task_Assignment_Post_Del',FND_LOG.LEVEL_EXCEPTION);
846: END Task_Assignment_Post_Del;
847:
848: /*-----------------------------------------------------------------
849: Description:

Line 918: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_WF_PKG.Task_Pre_Upd',FND_LOG.LEVEL_EXCEPTION);

914: l_sqlerrno := to_char(SQLCODE);
915: l_sqlerrmsg := substr(SQLERRM, 1,2000);
916: l_error_msg := 'Exception in Task_Pre_Upd for task_id:' || TO_CHAR(l_jtf_task_id)
917: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
918: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_WF_PKG.Task_Pre_Upd',FND_LOG.LEVEL_EXCEPTION);
919: END Task_Pre_Upd;
920:
921: Procedure Task_Post_Upd (
922: x_return_status OUT NOCOPY VARCHAR2

Line 1003: 'CSM_WF_PKG.Task_Post_Upd',FND_LOG.LEVEL_PROCEDURE);

999: RETURN;
1000: END IF;
1001:
1002: CSM_UTIL_PKG.LOG('Entering CSM_WF_PKG.Task_Post_Upd for task_id:' || l_jtf_task_id ,
1003: 'CSM_WF_PKG.Task_Post_Upd',FND_LOG.LEVEL_PROCEDURE);
1004:
1005: /*12.1: TASK_TYPE CHANGE should be captured*/
1006: l_task_downloadable_to_owner := CSM_SR_EVENT_PKG.is_sr_downloaded_to_owner(l_jtf_task_id);
1007:

Line 1118: 'CSM_WF_PKG.Task_Post_Upd',FND_LOG.LEVEL_PROCEDURE);

1114: l_task_post_upd_rec.scheduled_end_date)
1115: )
1116: THEN
1117: CSM_UTIL_PKG.LOG('old NOT downloadable, new downloadable for task_id:' || l_jtf_task_id ,
1118: 'CSM_WF_PKG.Task_Post_Upd',FND_LOG.LEVEL_PROCEDURE);
1119:
1120: FOR i IN l_task_assignment_list.FIRST..l_task_assignment_list.LAST LOOP
1121: IF (CSM_UTIL_PKG.is_palm_resource(l_resource_list(i))) THEN
1122: csm_task_assignment_event_pkg.task_assignment_initializer(p_task_assignment_id=>l_task_assignment_list(i),

Line 1146: 'CSM_WF_PKG.Task_Post_Upd',FND_LOG.LEVEL_PROCEDURE);

1142: g_task_pre_upd_rec.scheduled_end_date)
1143: )
1144: THEN
1145: CSM_UTIL_PKG.LOG('old downloadable, new NOT downloadable for task_id:' || l_jtf_task_id ,
1146: 'CSM_WF_PKG.Task_Post_Upd',FND_LOG.LEVEL_PROCEDURE);
1147:
1148: FOR i IN l_task_assignment_list.FIRST..l_task_assignment_list.LAST LOOP
1149: IF (CSM_UTIL_PKG.is_palm_resource(l_resource_list(i))) THEN
1150: csm_task_assignment_event_pkg.TASK_ASSIGNMENT_PURGE_INIT

Line 1162: 'CSM_WF_PKG.Task_Post_Upd',FND_LOG.LEVEL_PROCEDURE);

1158: END IF ; -- count > 0
1159:
1160: --do the updates for the task
1161: CSM_UTIL_PKG.LOG('Do updates for task_id:' || l_jtf_task_id ,
1162: 'CSM_WF_PKG.Task_Post_Upd',FND_LOG.LEVEL_PROCEDURE);
1163:
1164: csm_task_event_pkg.TASK_MAKE_DIRTY_U_FOREACHUSER(l_jtf_task_id,l_error_msg, l_return_status);
1165: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1166: csm_util_pkg.LOG(l_error_msg, 'CSM_WF_PKG.Task_Pre_Upd', FND_LOG.LEVEL_ERROR);

Line 1166: csm_util_pkg.LOG(l_error_msg, 'CSM_WF_PKG.Task_Pre_Upd', FND_LOG.LEVEL_ERROR);

1162: 'CSM_WF_PKG.Task_Post_Upd',FND_LOG.LEVEL_PROCEDURE);
1163:
1164: csm_task_event_pkg.TASK_MAKE_DIRTY_U_FOREACHUSER(l_jtf_task_id,l_error_msg, l_return_status);
1165: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1166: csm_util_pkg.LOG(l_error_msg, 'CSM_WF_PKG.Task_Pre_Upd', FND_LOG.LEVEL_ERROR);
1167: END IF;
1168:
1169: CSM_UTIL_PKG.LOG('Leaving CSM_WF_PKG.Task_Post_Upd for task_id:' || l_jtf_task_id ,
1170: 'CSM_WF_PKG.Task_Post_Upd',FND_LOG.LEVEL_PROCEDURE);

Line 1170: 'CSM_WF_PKG.Task_Post_Upd',FND_LOG.LEVEL_PROCEDURE);

1166: csm_util_pkg.LOG(l_error_msg, 'CSM_WF_PKG.Task_Pre_Upd', FND_LOG.LEVEL_ERROR);
1167: END IF;
1168:
1169: CSM_UTIL_PKG.LOG('Leaving CSM_WF_PKG.Task_Post_Upd for task_id:' || l_jtf_task_id ,
1170: 'CSM_WF_PKG.Task_Post_Upd',FND_LOG.LEVEL_PROCEDURE);
1171:
1172: /*call Start Sync event - NOTIFY CLIENT*/
1173: RAISE_START_AUTO_SYNC_EVENT('CSM_TASKS',to_char(l_jtf_task_id),'UPDATE');
1174:

Line 1183: csm_util_pkg.LOG(l_error_msg,'CSM_WF_PKG.Task_Post_Upd', FND_LOG.LEVEL_EXCEPTION);

1179: l_sqlerrno := to_char(SQLCODE);
1180: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1181: l_error_msg := l_error_msg || '-' || 'Exception in Task_Post_Upd for task_id:' || l_jtf_task_id
1182: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
1183: csm_util_pkg.LOG(l_error_msg,'CSM_WF_PKG.Task_Post_Upd', FND_LOG.LEVEL_EXCEPTION);
1184: END Task_Post_Upd;
1185:
1186: /********************************************************
1187: Starts the USER_RESP_INS workflow. Should be called when new

Line 1203: 'csm_wf_pkg.User_Resp_Post_Ins',FND_LOG.LEVEL_PROCEDURE);

1199: l_return_status VARCHAR2(2000);
1200:
1201: BEGIN
1202: CSM_UTIL_PKG.LOG('Entering User_Resp_Post_Ins for user_id:' || p_user_id,
1203: 'csm_wf_pkg.User_Resp_Post_Ins',FND_LOG.LEVEL_PROCEDURE);
1204:
1205: csm_user_event_pkg.user_resp_ins_initializer(p_user_id=>p_user_id,
1206: p_responsibility_id=>p_responsibility_id);
1207:

Line 1209: 'csm_wf_pkg.User_Resp_Post_Ins',FND_LOG.LEVEL_PROCEDURE);

1205: csm_user_event_pkg.user_resp_ins_initializer(p_user_id=>p_user_id,
1206: p_responsibility_id=>p_responsibility_id);
1207:
1208: CSM_UTIL_PKG.LOG('Leaving User_Resp_Post_Ins for user_id:' || p_user_id,
1209: 'csm_wf_pkg.User_Resp_Post_Ins',FND_LOG.LEVEL_PROCEDURE);
1210: EXCEPTION
1211: WHEN OTHERS THEN
1212: l_sqlerrno := to_char(SQLCODE);
1213: l_sqlerrmsg := substr(SQLERRM, 1,2000);

Line 1216: CSM_UTIL_PKG.LOG(l_error_msg, 'csm_wf_pkg.User_Resp_Post_Ins',FND_LOG.LEVEL_EXCEPTION);

1212: l_sqlerrno := to_char(SQLCODE);
1213: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1214: l_error_msg := ' Exception in User_Resp_Post_Ins for user_id:'
1215: || to_char(p_user_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
1216: CSM_UTIL_PKG.LOG(l_error_msg, 'csm_wf_pkg.User_Resp_Post_Ins',FND_LOG.LEVEL_EXCEPTION);
1217: RAISE;
1218: END User_Resp_Post_Ins;
1219:
1220: --12.1XB6

Line 1271: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_WF_PKG.SR_Post_Ins',FND_LOG.LEVEL_EXCEPTION);

1267: l_sqlerrno := to_char(SQLCODE);
1268: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1269: l_error_msg := l_error_msg || '- Exception in SR_Post_Ins for incident_id:'
1270: || TO_CHAR(l_incident_id) || l_sqlerrno || ':' || l_sqlerrmsg;
1271: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_WF_PKG.SR_Post_Ins',FND_LOG.LEVEL_EXCEPTION);
1272: END SR_Post_Ins;
1273:
1274: /*
1275: * The user hook interface for SR pre_update

Line 1402: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_WF_PKG.sr_pre_upd',FND_LOG.LEVEL_EXCEPTION);

1398: l_sqlerrno := to_char(SQLCODE);
1399: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1400: l_error_msg := 'Exception in sr_pre_upd for incident_id:' || TO_CHAR(l_incident_id)
1401: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
1402: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_WF_PKG.sr_pre_upd',FND_LOG.LEVEL_EXCEPTION);
1403: END sr_pre_upd;
1404:
1405: /********************************************************
1406: Starts the SR_UPD workflow. Should be called when new

Line 1727: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_WF_PKG.sr_post_upd',FND_LOG.LEVEL_EXCEPTION);

1723: l_sqlerrno := to_char(SQLCODE);
1724: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1725: l_error_msg := 'Exception in sr_post_upd for incident_id:' || TO_CHAR(l_incident_id)
1726: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
1727: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_WF_PKG.sr_post_upd',FND_LOG.LEVEL_EXCEPTION);
1728: END sr_post_upd;
1729:
1730: /*--------------------------------------------------
1731: Description:

Line 1767: 'CSM_WF_PKG.JTF_RS_Group_Member_Post_Ins', FND_LOG.LEVEL_EXCEPTION);

1763: l_sqlerrno := to_char(SQLCODE);
1764: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1765: CSM_UTIL_PKG.LOG('Exception in JTF_RS_Group_Member_Post_Ins for resource_id: ' || TO_CHAR(p_resource_id)
1766: || ' and group_id: ' || TO_CHAR(p_group_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg,
1767: 'CSM_WF_PKG.JTF_RS_Group_Member_Post_Ins', FND_LOG.LEVEL_EXCEPTION);
1768: END JTF_RS_Group_Member_Post_Ins;
1769:
1770: Procedure JTF_RS_Group_Member_Pre_Upd(p_user_id in number,
1771: p_jtf_rs_group_memb jtf_rs_group_members%rowtype)

Line 1820: 'CSM_WF_PKG.JTF_RS_Group_Member_Pre_Del', FND_LOG.LEVEL_EXCEPTION);

1816: l_sqlerrno := to_char(SQLCODE);
1817: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1818: CSM_UTIL_PKG.LOG('Exception in JTF_RS_Group_Member_Pre_Del for resource_id: ' || TO_CHAR(p_resource_id)
1819: || ' and group_id: ' || TO_CHAR(p_group_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg,
1820: 'CSM_WF_PKG.JTF_RS_Group_Member_Pre_Del', FND_LOG.LEVEL_EXCEPTION);
1821: END JTF_RS_Group_Member_Pre_Del;
1822:
1823: /********************************************************
1824: Starts the DEBRIEF_HEADER_INS workflow. Should be called when new

Line 1858: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_WF_PKG.CSF_Debrief_Header_Post_Ins',FND_LOG.LEVEL_EXCEPTION);

1854: l_sqlerrno := to_char(SQLCODE);
1855: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1856: l_error_msg := 'Exception in CSF_Debrief_Header_Post_Ins for debrief_header_id:' || TO_CHAR(l_debrief_header_id)
1857: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
1858: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_WF_PKG.CSF_Debrief_Header_Post_Ins',FND_LOG.LEVEL_EXCEPTION);
1859: END CSF_Debrief_Header_Post_Ins;
1860:
1861: PROCEDURE CSF_Debrief_Header_Pre_Upd(x_return_status OUT NOCOPY VARCHAR2)
1862: IS

Line 1905: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_WF_PKG.CSF_Debrief_Header_Post_Upd',FND_LOG.LEVEL_EXCEPTION);

1901: l_sqlerrno := to_char(SQLCODE);
1902: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1903: l_error_msg := 'Exception in CSF_Debrief_Header_Post_Upd for debrief_header_id:' || TO_CHAR(l_debrief_header_id)
1904: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
1905: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_WF_PKG.CSF_Debrief_Header_Post_Upd',FND_LOG.LEVEL_EXCEPTION);
1906: END CSF_Debrief_Header_Post_Upd;
1907:
1908: PROCEDURE CSF_Debrief_Header_Post_Del(x_return_status OUT NOCOPY VARCHAR2)
1909: IS

Line 1967: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_WF_PKG.CSF_Debrief_Header_Post_Del',FND_LOG.LEVEL_EXCEPTION);

1963: l_sqlerrno := to_char(SQLCODE);
1964: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1965: l_error_msg := 'Exception in CSF_Debrief_Header_Post_Del for debrief_header_id:' || TO_CHAR(l_debrief_header_id)
1966: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
1967: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_WF_PKG.CSF_Debrief_Header_Post_Del',FND_LOG.LEVEL_EXCEPTION);
1968: END CSF_Debrief_Header_Post_Del;
1969:
1970: /********************************************************
1971: Starts the DEBRIEF_LINE_INS workflow. Should be called when new

Line 2005: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_WF_PKG.CSF_Debrief_Line_Post_Ins',FND_LOG.LEVEL_EXCEPTION);

2001: l_sqlerrno := to_char(SQLCODE);
2002: l_sqlerrmsg := substr(SQLERRM, 1,2000);
2003: l_error_msg := 'Exception in CSF_Debrief_Line_Post_Ins for debrief_Line_id:' || TO_CHAR(l_debrief_line_id)
2004: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
2005: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_WF_PKG.CSF_Debrief_Line_Post_Ins',FND_LOG.LEVEL_EXCEPTION);
2006: END CSF_Debrief_Line_Post_Ins;
2007:
2008: /********************************************************
2009: Captures the old inventory_item_id before the upd

Line 2053: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_WF_PKG.CSF_Debrief_Line_Pre_Upd',FND_LOG.LEVEL_EXCEPTION);

2049: l_sqlerrno := to_char(SQLCODE);
2050: l_sqlerrmsg := substr(SQLERRM, 1,2000);
2051: l_error_msg := 'Exception in CSF_Debrief_Line_Pre_Upd for debrief_Line_id:' || TO_CHAR(l_debrief_line_id)
2052: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
2053: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_WF_PKG.CSF_Debrief_Line_Pre_Upd',FND_LOG.LEVEL_EXCEPTION);
2054: END CSF_Debrief_Line_Pre_Upd;
2055:
2056:
2057: Procedure CSF_Debrief_Line_Post_Upd(x_return_status OUT NOCOPY VARCHAR2)

Line 2121: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_WF_PKG.CSF_Debrief_Line_Post_Upd',FND_LOG.LEVEL_EXCEPTION);

2117: l_sqlerrno := to_char(SQLCODE);
2118: l_sqlerrmsg := substr(SQLERRM, 1,2000);
2119: l_error_msg := 'Exception in CSF_Debrief_Line_Post_Upd for debrief_Line_id:' || TO_CHAR(l_debrief_line_id)
2120: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
2121: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_WF_PKG.CSF_Debrief_Line_Post_Upd',FND_LOG.LEVEL_EXCEPTION);
2122: END CSF_Debrief_Line_Post_Upd;
2123:
2124:
2125: /*

Line 2173: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_WF_PKG.CSF_Debrief_Line_Post_Del',FND_LOG.LEVEL_EXCEPTION);

2169: l_sqlerrno := to_char(SQLCODE);
2170: l_sqlerrmsg := substr(SQLERRM, 1,2000);
2171: l_error_msg := 'Exception in CSF_Debrief_Line_Post_Del for debrief_Line_id:' || TO_CHAR(l_debrief_line_id)
2172: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
2173: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_WF_PKG.CSF_Debrief_Line_Post_Del',FND_LOG.LEVEL_EXCEPTION);
2174: END CSF_Debrief_Line_Post_Del;
2175:
2176: PROCEDURE CSP_Inv_Loc_Assignmnt_Post_Ins(x_return_status OUT NOCOPY VARCHAR2)
2177: IS

Line 2192: 'CSM_WF_PKG.CSP_Inv_Loc_Assignmnt_Post_Ins', FND_LOG.LEVEL_PROCEDURE );

2188:
2189: l_csp_inv_loc_assignment_id := CSP_INV_LOC_ASSIGNMENTS_PKG.user_hooks_rec.CSP_INV_LOC_ASSIGNMENT_ID;
2190:
2191: CSM_UTIL_PKG.LOG('Entering CSP_Inv_Loc_Assignmnt_Post_Ins for csp_inv_loc_assignment_id: ' || TO_CHAR(l_csp_inv_loc_assignment_id),
2192: 'CSM_WF_PKG.CSP_Inv_Loc_Assignmnt_Post_Ins', FND_LOG.LEVEL_PROCEDURE );
2193:
2194: CSM_INV_LOC_ASS_EVENT_PKG.INV_LOC_ASSIGNMENT_INS_INIT(p_csp_inv_loc_assignment_id=>l_csp_inv_loc_assignment_id);
2195:
2196: CSM_UTIL_PKG.LOG('Leaving CSP_Inv_Loc_Assignmnt_Post_Ins for csp_inv_loc_assignment_id: ' || TO_CHAR(l_csp_inv_loc_assignment_id),

Line 2197: 'CSM_WF_PKG.CSP_Inv_Loc_Assignmnt_Post_Ins', FND_LOG.LEVEL_PROCEDURE );

2193:
2194: CSM_INV_LOC_ASS_EVENT_PKG.INV_LOC_ASSIGNMENT_INS_INIT(p_csp_inv_loc_assignment_id=>l_csp_inv_loc_assignment_id);
2195:
2196: CSM_UTIL_PKG.LOG('Leaving CSP_Inv_Loc_Assignmnt_Post_Ins for csp_inv_loc_assignment_id: ' || TO_CHAR(l_csp_inv_loc_assignment_id),
2197: 'CSM_WF_PKG.CSP_Inv_Loc_Assignmnt_Post_Ins', FND_LOG.LEVEL_PROCEDURE );
2198:
2199: EXCEPTION
2200: WHEN OTHERS THEN
2201: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2206: 'CSM_WF_PKG.CSP_Inv_Loc_Assignmnt_Post_Ins', FND_LOG.LEVEL_EXCEPTION);

2202: l_sqlerrno := to_char(SQLCODE);
2203: l_sqlerrmsg := substr(SQLERRM, 1,2000);
2204: CSM_UTIL_PKG.LOG('Exception in CSP_Inv_Loc_Assignmnt_Post_Ins for csp_inv_loc_assignment_id: ' || TO_CHAR(l_csp_inv_loc_assignment_id)
2205: || ':' || l_sqlerrno || ':' || l_sqlerrmsg,
2206: 'CSM_WF_PKG.CSP_Inv_Loc_Assignmnt_Post_Ins', FND_LOG.LEVEL_EXCEPTION);
2207: END CSP_Inv_Loc_Assignmnt_Post_Ins;
2208:
2209: PROCEDURE CSP_Inv_Loc_Assignmnt_Pre_Upd(x_return_status OUT NOCOPY VARCHAR2)
2210: IS

Line 2242: 'CSM_WF_PKG.CSP_Inv_Loc_Assignmnt_Pre_Upd', FND_LOG.LEVEL_PROCEDURE );

2238:
2239: l_csp_inv_loc_assignment_id := CSP_INV_LOC_ASSIGNMENTS_PKG.user_hooks_rec.CSP_INV_LOC_ASSIGNMENT_ID;
2240:
2241: CSM_UTIL_PKG.LOG('Entering CSP_Inv_Loc_Assignmnt_Pre_Upd for csp_inv_loc_assignment_id: ' || TO_CHAR(l_csp_inv_loc_assignment_id),
2242: 'CSM_WF_PKG.CSP_Inv_Loc_Assignmnt_Pre_Upd', FND_LOG.LEVEL_PROCEDURE );
2243:
2244: g_old_subinventory_code := NULL;
2245: g_old_organization_id := NULL;
2246: g_old_eff_date_start := NULL;

Line 2267: 'CSM_WF_PKG.CSP_Inv_Loc_Assignmnt_Pre_Upd', FND_LOG.LEVEL_PROCEDURE );

2263: END IF;
2264: CLOSE l_cila_pre_upd_csr;
2265:
2266: CSM_UTIL_PKG.LOG('Leaving CSP_Inv_Loc_Assignmnt_Pre_Upd for csp_inv_loc_assignment_id: ' || TO_CHAR(l_csp_inv_loc_assignment_id),
2267: 'CSM_WF_PKG.CSP_Inv_Loc_Assignmnt_Pre_Upd', FND_LOG.LEVEL_PROCEDURE );
2268: EXCEPTION
2269: WHEN OTHERS THEN
2270: x_return_status := FND_API.G_RET_STS_ERROR;
2271: l_sqlerrno := to_char(SQLCODE);

Line 2275: 'CSM_WF_PKG.CSP_Inv_Loc_Assignmnt_Pre_Upd', FND_LOG.LEVEL_EXCEPTION);

2271: l_sqlerrno := to_char(SQLCODE);
2272: l_sqlerrmsg := substr(SQLERRM, 1,2000);
2273: CSM_UTIL_PKG.LOG('Exception in CSP_Inv_Loc_Assignmnt_Pre_Upd for csp_inv_loc_assignment_id: ' || TO_CHAR(l_csp_inv_loc_assignment_id)
2274: || ':' || l_sqlerrno || ':' || l_sqlerrmsg,
2275: 'CSM_WF_PKG.CSP_Inv_Loc_Assignmnt_Pre_Upd', FND_LOG.LEVEL_EXCEPTION);
2276: END CSP_Inv_Loc_Assignmnt_Pre_Upd;
2277:
2278: PROCEDURE CSP_Inv_Loc_Assignmnt_Post_Upd(x_return_status OUT NOCOPY VARCHAR2)
2279: IS

Line 2348: 'CSM_WF_PKG.CSP_Inv_Loc_Assignmnt_Post_Upd', FND_LOG.LEVEL_EXCEPTION);

2344: l_sqlerrno := to_char(SQLCODE);
2345: l_sqlerrmsg := substr(SQLERRM, 1,2000);
2346: CSM_UTIL_PKG.LOG('Exception in CSP_Inv_Loc_Assignmnt_Post_Upd for csp_inv_loc_assignment_id: ' || TO_CHAR(l_csp_inv_loc_assignment_id)
2347: || ':' || l_sqlerrno || ':' || l_sqlerrmsg,
2348: 'CSM_WF_PKG.CSP_Inv_Loc_Assignmnt_Post_Upd', FND_LOG.LEVEL_EXCEPTION);
2349: END CSP_Inv_Loc_Assignmnt_Post_Upd;
2350:
2351: PROCEDURE CSP_Inv_Loc_Assg_Post_Del(x_return_status OUT NOCOPY VARCHAR2)
2352: IS

Line 2367: 'CSM_WF_PKG.CSP_Inv_Loc_Assg_Post_Del', FND_LOG.LEVEL_PROCEDURE );

2363:
2364: l_csp_inv_loc_assignment_id := CSP_INV_LOC_ASSIGNMENTS_PKG.user_hooks_rec.CSP_INV_LOC_ASSIGNMENT_ID;
2365:
2366: CSM_UTIL_PKG.LOG('Entering CSP_Inv_Loc_Assg_Post_Del for csp_inv_loc_assignment_id: ' || TO_CHAR(l_csp_inv_loc_assignment_id),
2367: 'CSM_WF_PKG.CSP_Inv_Loc_Assg_Post_Del', FND_LOG.LEVEL_PROCEDURE );
2368:
2369: CSM_INV_LOC_ASS_EVENT_PKG.INV_LOC_ASSIGNMENT_DEL_INIT(p_csp_inv_loc_assignment_id=>l_csp_inv_loc_assignment_id);
2370:
2371: CSM_UTIL_PKG.LOG('Leaving CSP_Inv_Loc_Assg_Post_Del for csp_inv_loc_assignment_id: ' || TO_CHAR(l_csp_inv_loc_assignment_id),

Line 2372: 'CSM_WF_PKG.CSP_Inv_Loc_Assg_Post_Del', FND_LOG.LEVEL_PROCEDURE );

2368:
2369: CSM_INV_LOC_ASS_EVENT_PKG.INV_LOC_ASSIGNMENT_DEL_INIT(p_csp_inv_loc_assignment_id=>l_csp_inv_loc_assignment_id);
2370:
2371: CSM_UTIL_PKG.LOG('Leaving CSP_Inv_Loc_Assg_Post_Del for csp_inv_loc_assignment_id: ' || TO_CHAR(l_csp_inv_loc_assignment_id),
2372: 'CSM_WF_PKG.CSP_Inv_Loc_Assg_Post_Del', FND_LOG.LEVEL_PROCEDURE );
2373:
2374: EXCEPTION
2375: WHEN OTHERS THEN
2376: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2381: 'CSM_WF_PKG.CSP_Inv_Loc_Assg_Post_Del', FND_LOG.LEVEL_EXCEPTION);

2377: l_sqlerrno := to_char(SQLCODE);
2378: l_sqlerrmsg := substr(SQLERRM, 1,2000);
2379: CSM_UTIL_PKG.LOG('Exception in CSP_Inv_Loc_Assg_Post_Del for csp_inv_loc_assignment_id: ' || TO_CHAR(l_csp_inv_loc_assignment_id)
2380: || ':' || l_sqlerrno || ':' || l_sqlerrmsg,
2381: 'CSM_WF_PKG.CSP_Inv_Loc_Assg_Post_Del', FND_LOG.LEVEL_EXCEPTION);
2382: END CSP_Inv_Loc_Assg_Post_Del;
2383:
2384: PROCEDURE CSP_SHIP_TO_ADDRESS_POST_INS(x_return_status OUT NOCOPY VARCHAR2)
2385: IS

Line 2445: FND_LOG.LEVEL_PROCEDURE );

2441: p_res_type=>r_ship_locations_ins_rec.resource_type,
2442: p_user_id=>r_ship_locations_ins_rec.user_id);
2443: END LOOP;
2444: CSM_UTIL_PKG.LOG('Leaving CSM_WF_PKG.CSP_SHIP_TO_ADDRESS_POST_INS', 'CSM_WF_PKG.CSP_SHIP_TO_ADDRESS_POST_INS',
2445: FND_LOG.LEVEL_PROCEDURE );
2446:
2447: EXCEPTION
2448: WHEN OTHERS THEN
2449: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2453: 'CSM_WF_PKG.CSP_SHIP_TO_ADDRESS_POST_INS', FND_LOG.LEVEL_EXCEPTION);

2449: x_return_status := FND_API.G_RET_STS_ERROR;
2450: l_sqlerrno := to_char(SQLCODE);
2451: l_sqlerrmsg := substr(SQLERRM, 1,2000);
2452: CSM_UTIL_PKG.LOG('Exception in CSM_WF_PKG.CSP_SHIP_TO_ADDRESS_POST_INS:' || l_sqlerrno || ':' || l_sqlerrmsg,
2453: 'CSM_WF_PKG.CSP_SHIP_TO_ADDRESS_POST_INS', FND_LOG.LEVEL_EXCEPTION);
2454: END CSP_SHIP_TO_ADDRESS_POST_INS;
2455:
2456: PROCEDURE CSP_SHIP_TO_ADDRESS_POST_UPD(x_return_status OUT NOCOPY varchar2)
2457: IS

Line 2482: FND_LOG.LEVEL_PROCEDURE );

2478:
2479: l_location_id := csp_ship_to_address_pvt.g_inv_loc_id;
2480:
2481: CSM_UTIL_PKG.LOG('Entering CSM_WF_PKG.CSP_SHIP_TO_ADDRESS_POST_INS', 'CSM_WF_PKG.CSP_SHIP_TO_ADDRESS_POST_UPD',
2482: FND_LOG.LEVEL_PROCEDURE );
2483:
2484: FOR r_ship_locations_upd_rec IN l_ship_locations_upd_csr(l_location_id) LOOP
2485:
2486: /* --Party Sites need not be updated

Line 2502: FND_LOG.LEVEL_PROCEDURE );

2498: p_user_id=>r_ship_locations_upd_rec.user_id);
2499: END LOOP;
2500:
2501: CSM_UTIL_PKG.LOG('Leaving CSM_WF_PKG.CSP_SHIP_TO_ADDRESS_POST_UPD', 'CSM_WF_PKG.CSP_SHIP_TO_ADDRESS_POST_UPD',
2502: FND_LOG.LEVEL_PROCEDURE );
2503:
2504: EXCEPTION
2505: WHEN OTHERS THEN
2506: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2510: 'CSM_WF_PKG.CSP_SHIP_TO_ADDRESS_POST_UPD', FND_LOG.LEVEL_EXCEPTION);

2506: x_return_status := FND_API.G_RET_STS_ERROR;
2507: l_sqlerrno := to_char(SQLCODE);
2508: l_sqlerrmsg := substr(SQLERRM, 1,2000);
2509: CSM_UTIL_PKG.LOG('Exception in CSM_WF_PKG.CSP_SHIP_TO_ADDRESS_POST_UPD:' || l_sqlerrno || ':' || l_sqlerrmsg,
2510: 'CSM_WF_PKG.CSP_SHIP_TO_ADDRESS_POST_UPD', FND_LOG.LEVEL_EXCEPTION);
2511: END CSP_SHIP_TO_ADDRESS_POST_UPD;
2512:
2513: PROCEDURE CSP_REQ_HEADERS_POST_INS(x_return_status OUT NOCOPY varchar2)
2514: IS

Line 2547: FND_LOG.LEVEL_PROCEDURE );

2543: RETURN;
2544: END IF;
2545:
2546: CSM_UTIL_PKG.LOG('Entering CSM_WF_PKG.CSP_REQ_HEADERS_POST_INS', 'CSM_WF_PKG.CSP_REQ_HEADERS_POST_INS',
2547: FND_LOG.LEVEL_PROCEDURE );
2548:
2549: l_req_header_id := CSP_REQUIREMENT_HEADERS_PKG.user_hooks_rec.REQUIREMENT_HEADER_ID;
2550:
2551: FOR r_req_hdr_rec IN l_req_hdr_csr(l_req_header_id) LOOP

Line 2557: 'CSM_WF_PKG.CSP_REQ_HEADERS_POST_INS', FND_LOG.LEVEL_ERROR );

2553: csm_csp_req_headers_event_pkg.csp_req_headers_mdirty_i(p_requirement_header_id=>l_req_header_id,
2554: p_user_id=>r_req_hdr_rec.user_id);
2555: ELSE
2556: CSM_UTIL_PKG.LOG('Resource:' || r_req_hdr_rec.resource_id || ' not a mobile resource',
2557: 'CSM_WF_PKG.CSP_REQ_HEADERS_POST_INS', FND_LOG.LEVEL_ERROR );
2558: END IF;
2559:
2560: END LOOP;
2561: CSM_UTIL_PKG.LOG('Leaving CSM_WF_PKG.CSP_REQ_HEADERS_POST_INS', 'CSM_WF_PKG.CSP_REQ_HEADERS_POST_INS',

Line 2562: FND_LOG.LEVEL_PROCEDURE );

2558: END IF;
2559:
2560: END LOOP;
2561: CSM_UTIL_PKG.LOG('Leaving CSM_WF_PKG.CSP_REQ_HEADERS_POST_INS', 'CSM_WF_PKG.CSP_REQ_HEADERS_POST_INS',
2562: FND_LOG.LEVEL_PROCEDURE );
2563:
2564: EXCEPTION
2565: WHEN OTHERS THEN
2566: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2570: 'CSM_WF_PKG.CSP_REQ_HEADERS_POST_INS', FND_LOG.LEVEL_EXCEPTION);

2566: x_return_status := FND_API.G_RET_STS_ERROR;
2567: l_sqlerrno := to_char(SQLCODE);
2568: l_sqlerrmsg := substr(SQLERRM, 1,2000);
2569: CSM_UTIL_PKG.LOG('Exception in CSM_WF_PKG.CSP_REQ_HEADERS_POST_INS:' || l_sqlerrno || ':' || l_sqlerrmsg,
2570: 'CSM_WF_PKG.CSP_REQ_HEADERS_POST_INS', FND_LOG.LEVEL_EXCEPTION);
2571: END CSP_REQ_HEADERS_POST_INS;
2572:
2573: PROCEDURE CSP_REQ_HEADERS_POST_UPD(x_return_status OUT NOCOPY varchar2)
2574: IS

Line 2594: FND_LOG.LEVEL_PROCEDURE );

2590: RETURN;
2591: END IF;
2592:
2593: CSM_UTIL_PKG.LOG('Entering CSM_WF_PKG.CSP_REQ_HEADERS_POST_UPD', 'CSM_WF_PKG.CSP_REQ_HEADERS_POST_UPD',
2594: FND_LOG.LEVEL_PROCEDURE );
2595:
2596: l_req_header_id := CSP_REQUIREMENT_HEADERS_PKG.user_hooks_rec.REQUIREMENT_HEADER_ID;
2597:
2598: FOR r_req_hdr_rec IN l_req_hdr_csr(l_req_header_id) LOOP

Line 2604: FND_LOG.LEVEL_PROCEDURE );

2600: p_user_id=>r_req_hdr_rec.user_id);
2601:
2602: END LOOP;
2603: CSM_UTIL_PKG.LOG('Leaving CSM_WF_PKG.CSP_REQ_HEADERS_POST_UPD', 'CSM_WF_PKG.CSP_REQ_HEADERS_POST_UPD',
2604: FND_LOG.LEVEL_PROCEDURE );
2605:
2606: EXCEPTION
2607: WHEN OTHERS THEN
2608: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2612: 'CSM_WF_PKG.CSP_REQ_HEADERS_POST_UPD', FND_LOG.LEVEL_EXCEPTION);

2608: x_return_status := FND_API.G_RET_STS_ERROR;
2609: l_sqlerrno := to_char(SQLCODE);
2610: l_sqlerrmsg := substr(SQLERRM, 1,2000);
2611: CSM_UTIL_PKG.LOG('Exception in CSM_WF_PKG.CSP_REQ_HEADERS_POST_UPD:' || l_sqlerrno || ':' || l_sqlerrmsg,
2612: 'CSM_WF_PKG.CSP_REQ_HEADERS_POST_UPD', FND_LOG.LEVEL_EXCEPTION);
2613: END CSP_REQ_HEADERS_POST_UPD;
2614:
2615: PROCEDURE CSP_REQ_HEADERS_POST_DEL(x_return_status OUT NOCOPY varchar2)
2616: IS

Line 2635: FND_LOG.LEVEL_PROCEDURE );

2631: RETURN;
2632: END IF;
2633:
2634: CSM_UTIL_PKG.LOG('Entering CSM_WF_PKG.CSP_REQ_HEADERS_POST_DEL', 'CSM_WF_PKG.CSP_REQ_HEADERS_POST_DEL',
2635: FND_LOG.LEVEL_PROCEDURE );
2636:
2637: l_req_header_id := CSP_REQUIREMENT_HEADERS_PKG.user_hooks_rec.REQUIREMENT_HEADER_ID;
2638:
2639: FOR r_req_hdr_acc_rec IN l_req_hdr_acc_csr(l_req_header_id) LOOP

Line 2645: FND_LOG.LEVEL_PROCEDURE );

2641: p_user_id=>r_req_hdr_acc_rec.user_id);
2642:
2643: END LOOP;
2644: CSM_UTIL_PKG.LOG('Leaving CSM_WF_PKG.CSP_REQ_HEADERS_POST_DEL', 'CSM_WF_PKG.CSP_REQ_HEADERS_POST_DEL',
2645: FND_LOG.LEVEL_PROCEDURE );
2646:
2647: EXCEPTION
2648: WHEN OTHERS THEN
2649: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2653: 'CSM_WF_PKG.CSP_REQ_HEADERS_POST_DEL', FND_LOG.LEVEL_EXCEPTION);

2649: x_return_status := FND_API.G_RET_STS_ERROR;
2650: l_sqlerrno := to_char(SQLCODE);
2651: l_sqlerrmsg := substr(SQLERRM, 1,2000);
2652: CSM_UTIL_PKG.LOG('Exception in CSM_WF_PKG.CSP_REQ_HEADERS_POST_DEL:' || l_sqlerrno || ':' || l_sqlerrmsg,
2653: 'CSM_WF_PKG.CSP_REQ_HEADERS_POST_DEL', FND_LOG.LEVEL_EXCEPTION);
2654: END CSP_REQ_HEADERS_POST_DEL;
2655:
2656: PROCEDURE CSP_REQ_LINES_POST_INS(x_return_status OUT NOCOPY varchar2)
2657: IS

Line 2696: FND_LOG.LEVEL_PROCEDURE );

2692: RETURN;
2693: END IF;
2694:
2695: CSM_UTIL_PKG.LOG('Entering CSM_WF_PKG.CSP_REQ_LINES_POST_INS', 'CSM_WF_PKG.CSP_REQ_LINES_POST_INS',
2696: FND_LOG.LEVEL_PROCEDURE );
2697:
2698: l_req_line_id := CSP_REQUIREMENT_LINES_PKG.user_hook_rec.REQUIREMENT_LINE_ID;
2699:
2700: FOR r_req_line_rec IN l_req_line_csr(l_req_line_id) LOOP

Line 2706: 'CSM_WF_PKG.CSP_REQ_LINES_POST_INS', FND_LOG.LEVEL_ERROR );

2702: csm_csp_req_lines_event_pkg.csp_req_lines_mdirty_i(p_requirement_line_id=>l_req_line_id,
2703: p_user_id=>r_req_line_rec.user_id);
2704: ELSE
2705: CSM_UTIL_PKG.LOG('Resource:' || r_req_line_rec.resource_id || ' not a mobile resource',
2706: 'CSM_WF_PKG.CSP_REQ_LINES_POST_INS', FND_LOG.LEVEL_ERROR );
2707: END IF;
2708:
2709: END LOOP;
2710: CSM_UTIL_PKG.LOG('Leaving CSM_WF_PKG.CSP_REQ_LINES_POST_INS', 'CSM_WF_PKG.CSP_REQ_LINES_POST_INS',

Line 2711: FND_LOG.LEVEL_PROCEDURE );

2707: END IF;
2708:
2709: END LOOP;
2710: CSM_UTIL_PKG.LOG('Leaving CSM_WF_PKG.CSP_REQ_LINES_POST_INS', 'CSM_WF_PKG.CSP_REQ_LINES_POST_INS',
2711: FND_LOG.LEVEL_PROCEDURE );
2712:
2713: EXCEPTION
2714: WHEN OTHERS THEN
2715: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2719: 'CSM_WF_PKG.CSP_REQ_LINES_POST_INS', FND_LOG.LEVEL_EXCEPTION);

2715: x_return_status := FND_API.G_RET_STS_ERROR;
2716: l_sqlerrno := to_char(SQLCODE);
2717: l_sqlerrmsg := substr(SQLERRM, 1,2000);
2718: CSM_UTIL_PKG.LOG('Exception in CSM_WF_PKG.CSP_REQ_LINES_POST_INS:' || l_sqlerrno || ':' || l_sqlerrmsg,
2719: 'CSM_WF_PKG.CSP_REQ_LINES_POST_INS', FND_LOG.LEVEL_EXCEPTION);
2720: END CSP_REQ_LINES_POST_INS;
2721:
2722: PROCEDURE CSP_REQ_LINES_POST_UPD(x_return_status OUT NOCOPY varchar2)
2723: IS

Line 2742: FND_LOG.LEVEL_PROCEDURE );

2738: RETURN;
2739: END IF;
2740:
2741: CSM_UTIL_PKG.LOG('Entering CSM_WF_PKG.CSP_REQ_LINES_POST_UPD', 'CSM_WF_PKG.CSP_REQ_LINES_POST_UPD',
2742: FND_LOG.LEVEL_PROCEDURE );
2743:
2744: l_req_line_id := CSP_REQUIREMENT_LINES_PKG.user_hook_rec.REQUIREMENT_LINE_ID;
2745:
2746: FOR r_req_line_rec IN l_req_line_csr(l_req_line_id) LOOP

Line 2752: FND_LOG.LEVEL_PROCEDURE );

2748: p_user_id=>r_req_line_rec.user_id);
2749: END LOOP;
2750:
2751: CSM_UTIL_PKG.LOG('Leaving CSM_WF_PKG.CSP_REQ_LINES_POST_UPD', 'CSM_WF_PKG.CSP_REQ_LINES_POST_UPD',
2752: FND_LOG.LEVEL_PROCEDURE );
2753:
2754: EXCEPTION
2755: WHEN OTHERS THEN
2756: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2760: 'CSM_WF_PKG.CSP_REQ_LINES_POST_UPD', FND_LOG.LEVEL_EXCEPTION);

2756: x_return_status := FND_API.G_RET_STS_ERROR;
2757: l_sqlerrno := to_char(SQLCODE);
2758: l_sqlerrmsg := substr(SQLERRM, 1,2000);
2759: CSM_UTIL_PKG.LOG('Exception in CSM_WF_PKG.CSP_REQ_LINES_POST_UPD:' || l_sqlerrno || ':' || l_sqlerrmsg,
2760: 'CSM_WF_PKG.CSP_REQ_LINES_POST_UPD', FND_LOG.LEVEL_EXCEPTION);
2761: END CSP_REQ_LINES_POST_UPD;
2762:
2763: PROCEDURE CSP_REQ_LINES_POST_DEL(x_return_status OUT NOCOPY varchar2)
2764: IS

Line 2783: FND_LOG.LEVEL_PROCEDURE );

2779: RETURN;
2780: END IF;
2781:
2782: CSM_UTIL_PKG.LOG('Entering CSM_WF_PKG.CSP_REQ_LINES_POST_DEL', 'CSM_WF_PKG.CSP_REQ_LINES_POST_DEL',
2783: FND_LOG.LEVEL_PROCEDURE );
2784:
2785: l_req_line_id := CSP_REQUIREMENT_LINES_PKG.user_hook_rec.REQUIREMENT_LINE_ID;
2786:
2787: FOR r_req_line_acc_rec IN l_req_line_acc_csr(l_req_line_id) LOOP

Line 2794: FND_LOG.LEVEL_PROCEDURE );

2790:
2791: END LOOP;
2792:
2793: CSM_UTIL_PKG.LOG('Leaving CSM_WF_PKG.CSP_REQ_LINES_POST_DEL', 'CSM_WF_PKG.CSP_REQ_LINES_POST_DEL',
2794: FND_LOG.LEVEL_PROCEDURE );
2795: EXCEPTION
2796: WHEN OTHERS THEN
2797: x_return_status := FND_API.G_RET_STS_ERROR;
2798: l_sqlerrno := to_char(SQLCODE);

Line 2801: 'CSM_WF_PKG.CSP_REQ_LINES_POST_DEL', FND_LOG.LEVEL_EXCEPTION);

2797: x_return_status := FND_API.G_RET_STS_ERROR;
2798: l_sqlerrno := to_char(SQLCODE);
2799: l_sqlerrmsg := substr(SQLERRM, 1,2000);
2800: CSM_UTIL_PKG.LOG('Exception in CSM_WF_PKG.CSP_REQ_LINES_POST_DEL:' || l_sqlerrno || ':' || l_sqlerrmsg,
2801: 'CSM_WF_PKG.CSP_REQ_LINES_POST_DEL', FND_LOG.LEVEL_EXCEPTION);
2802: END CSP_REQ_LINES_POST_DEL;
2803:
2804: PROCEDURE CSP_REQ_LINE_DETAILS_POST_INS(x_return_status OUT NOCOPY varchar2)
2805: IS

Line 2819: FND_LOG.LEVEL_PROCEDURE );

2815: RETURN;
2816: END IF;
2817:
2818: CSM_UTIL_PKG.LOG('Entering CSM_WF_PKG.CSP_REQ_LINE_DETAILS_POST_INS', 'CSM_WF_PKG.CSP_REQ_LINE_DETAILS_POST_INS',
2819: FND_LOG.LEVEL_PROCEDURE );
2820:
2821: l_req_line_id :=CSP_REQ_LINE_DETAILS_PKG.user_hook_rec.REQUIREMENT_LINE_ID; --CSF tech portal seems to pass this wrongly
2822: l_req_line_detail_id := CSP_REQ_LINE_DETAILS_PKG.user_hook_rec.req_line_detail_id; --only this is passed correctly from all src
2823:

Line 2833: FND_LOG.LEVEL_PROCEDURE );

2829: --Notify User of new Order placed
2830: RAISE_START_AUTO_SYNC_EVENT('CSM_REQ_LINE_DETAILS',to_char(l_req_line_detail_id),'NEW');
2831:
2832: CSM_UTIL_PKG.LOG('Leaving CSM_WF_PKG.CSP_REQ_LINE_DETAILS_POST_INS', 'CSM_WF_PKG.CSP_REQ_LINE_DETAILS_POST_INS',
2833: FND_LOG.LEVEL_PROCEDURE );
2834:
2835: EXCEPTION
2836: WHEN OTHERS THEN
2837: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2841: 'CSM_WF_PKG.CSP_REQ_LINE_DETAILS_POST_INS', FND_LOG.LEVEL_EXCEPTION);

2837: x_return_status := FND_API.G_RET_STS_ERROR;
2838: l_sqlerrno := to_char(SQLCODE);
2839: l_sqlerrmsg := substr(SQLERRM, 1,2000);
2840: CSM_UTIL_PKG.LOG('Exception in CSM_WF_PKG.CSP_REQ_LINE_DETAILS_POST_INS:' || l_sqlerrno || ':' || l_sqlerrmsg,
2841: 'CSM_WF_PKG.CSP_REQ_LINE_DETAILS_POST_INS', FND_LOG.LEVEL_EXCEPTION);
2842: x_return_status := FND_API.G_RET_STS_ERROR;
2843: END CSP_REQ_LINE_DETAILS_POST_INS;
2844:
2845: PROCEDURE CSP_REQ_LINE_DETAILS_POST_UPD(x_return_status OUT NOCOPY varchar2)

Line 2860: FND_LOG.LEVEL_PROCEDURE );

2856: RETURN;
2857: END IF;
2858:
2859: CSM_UTIL_PKG.LOG('Entering CSM_WF_PKG.CSP_REQ_LINE_DETAILS_POST_UPD', 'CSM_WF_PKG.CSP_REQ_LINE_DETAILS_POST_UPD',
2860: FND_LOG.LEVEL_PROCEDURE );
2861:
2862: l_req_line_id :=CSP_REQ_LINE_DETAILS_PKG.user_hook_rec.REQUIREMENT_LINE_ID; --CSF tech portal seems to pass this wrongly
2863: l_req_line_detail_id := CSP_REQ_LINE_DETAILS_PKG.user_hook_rec.req_line_detail_id; --only this is passed correctly from all src
2864:

Line 2868: FND_LOG.LEVEL_PROCEDURE );

2864:
2865: csm_csp_req_lines_event_pkg.REQ_LINE_DTL_IUD(l_req_line_detail_id,'U');
2866:
2867: CSM_UTIL_PKG.LOG('Leaving CSM_WF_PKG.CSP_REQ_LINE_DETAILS_POST_UPD', 'CSM_WF_PKG.CSP_REQ_LINE_DETAILS_POST_UPD',
2868: FND_LOG.LEVEL_PROCEDURE );
2869:
2870: EXCEPTION
2871: WHEN OTHERS THEN
2872: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2876: 'CSM_WF_PKG.CSP_REQ_LINE_DETAILS_POST_UPD', FND_LOG.LEVEL_EXCEPTION);

2872: x_return_status := FND_API.G_RET_STS_ERROR;
2873: l_sqlerrno := to_char(SQLCODE);
2874: l_sqlerrmsg := substr(SQLERRM, 1,2000);
2875: CSM_UTIL_PKG.LOG('Exception in CSM_WF_PKG.CSP_REQ_LINE_DETAILS_POST_UPD:' || l_sqlerrno || ':' || l_sqlerrmsg,
2876: 'CSM_WF_PKG.CSP_REQ_LINE_DETAILS_POST_UPD', FND_LOG.LEVEL_EXCEPTION);
2877: x_return_status := FND_API.G_RET_STS_ERROR;
2878: END CSP_REQ_LINE_DETAILS_POST_UPD;
2879:
2880: PROCEDURE CSP_REQ_LINE_DETAILS_PRE_DEL(x_return_status OUT NOCOPY varchar2)

Line 2895: FND_LOG.LEVEL_PROCEDURE );

2891: RETURN;
2892: END IF;
2893:
2894: CSM_UTIL_PKG.LOG('Entering CSM_WF_PKG.CSP_REQ_LINE_DETAILS_PRE_DEL', 'CSM_WF_PKG.CSP_REQ_LINE_DETAILS_PRE_DEL',
2895: FND_LOG.LEVEL_PROCEDURE );
2896:
2897: l_req_line_id :=CSP_REQ_LINE_DETAILS_PKG.user_hook_rec.REQUIREMENT_LINE_ID; --CSF tech portal seems to pass this wrongly
2898: l_req_line_detail_id := CSP_REQ_LINE_DETAILS_PKG.user_hook_rec.req_line_detail_id; --only this is passed correctly from all src
2899:

Line 2903: FND_LOG.LEVEL_PROCEDURE );

2899:
2900: csm_csp_req_lines_event_pkg.REQ_LINE_DTL_IUD(l_req_line_detail_id,'D');
2901:
2902: CSM_UTIL_PKG.LOG('Leaving CSM_WF_PKG.CSP_REQ_LINE_DETAILS_PRE_DEL', 'CSM_WF_PKG.CSP_REQ_LINE_DETAILS_PRE_DEL',
2903: FND_LOG.LEVEL_PROCEDURE );
2904:
2905: EXCEPTION
2906: WHEN OTHERS THEN
2907: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2911: 'CSM_WF_PKG.CSP_REQ_LINE_DETAILS_PRE_DEL', FND_LOG.LEVEL_EXCEPTION);

2907: x_return_status := FND_API.G_RET_STS_ERROR;
2908: l_sqlerrno := to_char(SQLCODE);
2909: l_sqlerrmsg := substr(SQLERRM, 1,2000);
2910: CSM_UTIL_PKG.LOG('Exception in CSM_WF_PKG.CSP_REQ_LINE_DETAILS_PRE_DEL:' || l_sqlerrno || ':' || l_sqlerrmsg,
2911: 'CSM_WF_PKG.CSP_REQ_LINE_DETAILS_PRE_DEL', FND_LOG.LEVEL_EXCEPTION);
2912: END CSP_REQ_LINE_DETAILS_PRE_DEL;
2913:
2914: /*--------------------------------------------------
2915: Description:

Line 2952: csm_util_pkg.LOG(l_error_msg, 'CSM_WF_PKG.JTF_Note_Post_Ins', FND_LOG.LEVEL_ERROR);

2948: END IF;
2949:
2950: csm_notes_event_pkg.notes_make_dirty_i_foreachuser(p_jtf_note_id,l_error_msg,l_return_status);
2951: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2952: csm_util_pkg.LOG(l_error_msg, 'CSM_WF_PKG.JTF_Note_Post_Ins', FND_LOG.LEVEL_ERROR);
2953: END IF;
2954:
2955: EXCEPTION
2956: WHEN OTHERS THEN

Line 2962: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_WF_PKG.JTF_Note_Post_Ins',FND_LOG.LEVEL_EXCEPTION);

2958: l_sqlerrno := to_char(SQLCODE);
2959: l_sqlerrmsg := substr(SQLERRM, 1,2000);
2960: l_error_msg := l_error_msg || '- Exception in JTF_Note_Post_Ins for note_id:'
2961: || TO_CHAR(p_jtf_note_id) || l_sqlerrno || ':' || l_sqlerrmsg;
2962: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_WF_PKG.JTF_Note_Post_Ins',FND_LOG.LEVEL_EXCEPTION);
2963: END JTF_Note_Post_Ins;
2964:
2965: /*--------------------------------------------------
2966: Description:

Line 3003: csm_util_pkg.LOG(l_error_msg, 'CSM_WF_PKG.JTF_Note_Pre_Upd', FND_LOG.LEVEL_ERROR);

2999: END IF;
3000:
3001: csm_notes_event_pkg.notes_make_dirty_i_foreachuser(p_jtf_note_id, l_error_msg, l_return_status);
3002: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3003: csm_util_pkg.LOG(l_error_msg, 'CSM_WF_PKG.JTF_Note_Pre_Upd', FND_LOG.LEVEL_ERROR);
3004: END IF;
3005:
3006: EXCEPTION
3007: WHEN OTHERS THEN

Line 3013: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_WF_PKG.JTF_Note_PRE_Upd',FND_LOG.LEVEL_EXCEPTION);

3009: l_sqlerrno := to_char(SQLCODE);
3010: l_sqlerrmsg := substr(SQLERRM, 1,2000);
3011: l_error_msg := l_error_msg || '- Exception in JTF_Note_PRE_Upd for note_id:'
3012: || TO_CHAR(p_jtf_note_id) || l_sqlerrno || ':' || l_sqlerrmsg;
3013: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_WF_PKG.JTF_Note_PRE_Upd',FND_LOG.LEVEL_EXCEPTION);
3014: END JTF_Note_PRE_Upd;
3015:
3016: PROCEDURE JTF_Note_POST_Upd(p_api_version IN NUMBER
3017: , p_init_msg_list IN VARCHAR2

Line 3038: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_WF_PKG.JTF_Note_POST_Upd',FND_LOG.LEVEL_EXCEPTION);

3034: l_sqlerrno := to_char(SQLCODE);
3035: l_sqlerrmsg := substr(SQLERRM, 1,2000);
3036: l_error_msg := l_error_msg || '- Exception in JTF_Note_POST_Upd for note_id:'
3037: || TO_CHAR(p_jtf_note_id) || l_sqlerrno || ':' || l_sqlerrmsg;
3038: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_WF_PKG.JTF_Note_POST_Upd',FND_LOG.LEVEL_EXCEPTION);
3039: END JTF_Note_POST_Upd;
3040:
3041: Procedure CSI_Item_Instance_Post_Ins(p_api_version IN NUMBER
3042: , p_init_msg_list IN VARCHAR2

Line 3118: csm_util_pkg.LOG(l_error_msg, 'CSM_WF_PKG.CSI_Item_Instance_Pre_Upd', FND_LOG.LEVEL_ERROR);

3114: END IF;
3115:
3116: CSM_ITEM_INSTANCE_EVENT_PKG.ITEM_INSTANCE_MDIRTY_U_ECHUSER(p_instance_id, l_error_msg, l_return_status);
3117: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3118: csm_util_pkg.LOG(l_error_msg, 'CSM_WF_PKG.CSI_Item_Instance_Pre_Upd', FND_LOG.LEVEL_ERROR);
3119: END IF;
3120:
3121: EXCEPTION
3122: WHEN OTHERS THEN

Line 3128: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_WF_PKG.CSI_Item_Instance_Pre_Upd',FND_LOG.LEVEL_EXCEPTION);

3124: l_sqlerrno := to_char(SQLCODE);
3125: l_sqlerrmsg := substr(SQLERRM, 1,2000);
3126: l_error_msg := 'Exception in CSI_Item_Instance_Pre_Upd for instance_id:' || TO_CHAR(p_instance_id)
3127: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
3128: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_WF_PKG.CSI_Item_Instance_Pre_Upd',FND_LOG.LEVEL_EXCEPTION);
3129: END CSI_Item_Instance_Pre_Upd;
3130:
3131: Procedure CS_Counter_Post_Ins(
3132: P_Api_Version IN NUMBER,

Line 3158: csm_util_pkg.LOG(l_error_msg, 'CSM_WF_PKG.CS_Counter_Post_Ins', FND_LOG.LEVEL_ERROR);

3154: END IF;
3155:
3156: csm_counter_event_pkg.CTR_MAKE_DIRTY_I_FOREACHUSER(p_counter_id, l_error_msg, l_return_status);
3157: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3158: csm_util_pkg.LOG(l_error_msg, 'CSM_WF_PKG.CS_Counter_Post_Ins', FND_LOG.LEVEL_ERROR);
3159: END IF;
3160:
3161: EXCEPTION
3162: WHEN OTHERS THEN

Line 3168: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_WF_PKG.CS_Counter_Post_Ins',FND_LOG.LEVEL_EXCEPTION);

3164: l_sqlerrno := to_char(SQLCODE);
3165: l_sqlerrmsg := substr(SQLERRM, 1,2000);
3166: l_error_msg := 'Exception in CS_Counter_Post_Ins for counter_id:' || TO_CHAR(p_counter_id)
3167: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
3168: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_WF_PKG.CS_Counter_Post_Ins',FND_LOG.LEVEL_EXCEPTION);
3169: END CS_Counter_Post_Ins;
3170:
3171: Procedure CS_Counter_Pre_Del(
3172: P_Api_Version IN NUMBER,

Line 3195: csm_util_pkg.LOG(l_error_msg, 'CSM_WF_PKG.CS_Counter_Pre_Del', FND_LOG.LEVEL_ERROR);

3191: END IF;
3192:
3193: csm_counter_event_pkg.COUNTER_MDIRTY_D(p_counter_id, l_error_msg, l_return_status);
3194: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3195: csm_util_pkg.LOG(l_error_msg, 'CSM_WF_PKG.CS_Counter_Pre_Del', FND_LOG.LEVEL_ERROR);
3196: END IF;
3197:
3198: EXCEPTION
3199: WHEN OTHERS THEN

Line 3205: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_WF_PKG.CS_Counter_Pre_Del',FND_LOG.LEVEL_EXCEPTION);

3201: l_sqlerrno := to_char(SQLCODE);
3202: l_sqlerrmsg := substr(SQLERRM, 1,2000);
3203: l_error_msg := 'Exception in CS_Counter_Pre_Del for counter_id:' || TO_CHAR(p_counter_id)
3204: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
3205: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_WF_PKG.CS_Counter_Pre_Del',FND_LOG.LEVEL_EXCEPTION);
3206: END CS_Counter_Pre_Del;
3207:
3208: PROCEDURE CS_CTR_GRP_INSTANCE_CRE_POST(
3209: P_Api_Version IN NUMBER,

Line 3293: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_WF_PKG.CS_CTR_GRP_INSTANCE_CRE_POST',FND_LOG.LEVEL_EXCEPTION);

3289: l_sqlerrno := to_char(SQLCODE);
3290: l_sqlerrmsg := substr(SQLERRM, 1,2000);
3291: l_error_msg := 'Exception in CS_CTR_GRP_INSTANCE_CRE_POST for COUNTER_GROUP_ID:' || TO_CHAR(p_ctr_grp_id)
3292: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
3293: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_WF_PKG.CS_CTR_GRP_INSTANCE_CRE_POST',FND_LOG.LEVEL_EXCEPTION);
3294: END CS_CTR_GRP_INSTANCE_CRE_POST;
3295:
3296: PROCEDURE CS_CTR_GRP_INSTANCE_PRE_DEL(
3297: P_Api_Version IN NUMBER,

Line 3355: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_WF_PKG.CS_CTR_GRP_INSTANCE_PRE_DEL',FND_LOG.LEVEL_EXCEPTION);

3351: l_sqlerrno := to_char(SQLCODE);
3352: l_sqlerrmsg := substr(SQLERRM, 1,2000);
3353: l_error_msg := 'Exception in CS_CTR_GRP_INSTANCE_PRE_DEL for source_object_id:' || TO_CHAR(p_source_object_id)
3354: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
3355: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_WF_PKG.CS_CTR_GRP_INSTANCE_PRE_DEL',FND_LOG.LEVEL_EXCEPTION);
3356: END CS_CTR_GRP_INSTANCE_PRE_DEL;
3357:
3358: PROCEDURE CS_COUNTER_GRP_Post_Upd( P_Api_Version IN NUMBER
3359: , P_Init_Msg_List IN VARCHAR2

Line 3413: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_WF_PKG.CS_COUNTER_GRP_Post_Upd',FND_LOG.LEVEL_EXCEPTION);

3409: l_sqlerrno := to_char(SQLCODE);
3410: l_sqlerrmsg := substr(SQLERRM, 1,2000);
3411: l_error_msg := 'Exception in CS_COUNTER_GRP_Post_Upd for counter_grp_id:' || TO_CHAR(p_ctr_grp_id)
3412: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
3413: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_WF_PKG.CS_COUNTER_GRP_Post_Upd',FND_LOG.LEVEL_EXCEPTION);
3414: END CS_COUNTER_GRP_Post_Upd;
3415:
3416: PROCEDURE CS_COUNTERS_INSTANTIATE_POST(
3417: P_Api_Version IN NUMBER,

Line 3560: csm_util_pkg.LOG(l_error_msg, 'CSM_WF_PKG.CS_Counter_Post_Upd', FND_LOG.LEVEL_ERROR);

3556: CLOSE l_acc_csr;
3557:
3558: csm_counter_event_pkg.CTR_MAKE_DIRTY_U_FOREACHUSER(p_counter_id, l_error_msg, l_return_status);
3559: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3560: csm_util_pkg.LOG(l_error_msg, 'CSM_WF_PKG.CS_Counter_Post_Upd', FND_LOG.LEVEL_ERROR);
3561: END IF;
3562:
3563: EXCEPTION
3564: WHEN OTHERS THEN

Line 3570: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_WF_PKG.CS_Counter_Post_Upd',FND_LOG.LEVEL_EXCEPTION);

3566: l_sqlerrno := to_char(SQLCODE);
3567: l_sqlerrmsg := substr(SQLERRM, 1,2000);
3568: l_error_msg := 'Exception in CS_Counter_Post_Upd for counter_id:' || TO_CHAR(p_counter_id)
3569: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
3570: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_WF_PKG.CS_Counter_Post_Upd',FND_LOG.LEVEL_EXCEPTION);
3571: END CS_Counter_Post_Upd;
3572:
3573:
3574: /********************************************************

Line 3608: csm_util_pkg.LOG(l_error_msg, 'CSM_WF_PKG.CS_Counter_Value_Post_Ins', FND_LOG.LEVEL_ERROR);

3604: l_counter_grp_log_id := p_counter_grp_log_id;
3605:
3606: csm_counter_event_pkg.CTR_VAL_MAKE_DIRTY_FOREACHUSER(l_counter_grp_log_id, l_error_msg, l_return_status);
3607: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3608: csm_util_pkg.LOG(l_error_msg, 'CSM_WF_PKG.CS_Counter_Value_Post_Ins', FND_LOG.LEVEL_ERROR);
3609: END IF;
3610:
3611: EXCEPTION
3612: WHEN OTHERS THEN

Line 3618: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_WF_PKG.CS_Counter_Value_Post_Ins',FND_LOG.LEVEL_EXCEPTION);

3614: l_sqlerrno := to_char(SQLCODE);
3615: l_sqlerrmsg := substr(SQLERRM, 1,2000);
3616: l_error_msg := 'Exception in CS_Counter_Value_Post_Ins for counter_grp_log_id:' || TO_CHAR(l_counter_grp_log_id)
3617: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
3618: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_WF_PKG.CS_Counter_Value_Post_Ins',FND_LOG.LEVEL_EXCEPTION);
3619: END CS_Counter_Value_Post_Ins;
3620:
3621: /********************************************************
3622: Starts the COUNTER_VALUE_UPD_USERLOOP workflow. Should be called when new

Line 3654: csm_util_pkg.LOG(l_error_msg, 'CSM_WF_PKG.CS_Counter_Value_Pre_Upd', FND_LOG.LEVEL_ERROR);

3650: l_counter_grp_log_id := p_counter_grp_log_id;
3651:
3652: csm_counter_event_pkg.CTR_VAL_MAKE_DIRTY_FOREACHUSER(l_counter_grp_log_id, l_error_msg, l_return_status);
3653: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3654: csm_util_pkg.LOG(l_error_msg, 'CSM_WF_PKG.CS_Counter_Value_Pre_Upd', FND_LOG.LEVEL_ERROR);
3655: END IF;
3656:
3657: EXCEPTION
3658: WHEN OTHERS THEN

Line 3664: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_WF_PKG.CS_Counter_Value_Pre_Upd',FND_LOG.LEVEL_EXCEPTION);

3660: l_sqlerrno := to_char(SQLCODE);
3661: l_sqlerrmsg := substr(SQLERRM, 1,2000);
3662: l_error_msg := 'Exception in CS_Counter_Value_Pre_Upd for counter_grp_log_id:' || TO_CHAR(l_counter_grp_log_id)
3663: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
3664: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_WF_PKG.CS_Counter_Value_Pre_Upd',FND_LOG.LEVEL_EXCEPTION);
3665: END CS_Counter_Value_Pre_Upd;
3666:
3667: Procedure CS_Counter_Property_Post_Ins(p_user_id in number,
3668: p_cs_counter_prop cs_counter_properties%rowtype)

Line 3710: CSM_UTIL_PKG.LOG('Entering User_Del for user_id: ' || p_user_id, 'csm_wf_pkg.User_Del',FND_LOG.LEVEL_PROCEDURE);

3706: l_error_msg VARCHAR2(4000);
3707: l_return_status VARCHAR2(2000);
3708:
3709: BEGIN
3710: CSM_UTIL_PKG.LOG('Entering User_Del for user_id: ' || p_user_id, 'csm_wf_pkg.User_Del',FND_LOG.LEVEL_PROCEDURE);
3711:
3712: csm_user_event_pkg.user_del_init(p_user_id=>p_user_id);
3713:
3714: CSM_UTIL_PKG.LOG('Leaving User_Del for user_id: ' || p_user_id, 'csm_wf_pkg.User_Del',FND_LOG.LEVEL_PROCEDURE);

Line 3714: CSM_UTIL_PKG.LOG('Leaving User_Del for user_id: ' || p_user_id, 'csm_wf_pkg.User_Del',FND_LOG.LEVEL_PROCEDURE);

3710: CSM_UTIL_PKG.LOG('Entering User_Del for user_id: ' || p_user_id, 'csm_wf_pkg.User_Del',FND_LOG.LEVEL_PROCEDURE);
3711:
3712: csm_user_event_pkg.user_del_init(p_user_id=>p_user_id);
3713:
3714: CSM_UTIL_PKG.LOG('Leaving User_Del for user_id: ' || p_user_id, 'csm_wf_pkg.User_Del',FND_LOG.LEVEL_PROCEDURE);
3715: EXCEPTION
3716: WHEN OTHERS THEN
3717: l_sqlerrno := to_char(SQLCODE);
3718: l_sqlerrmsg := substr(SQLERRM, 1,2000);

Line 3721: CSM_UTIL_PKG.LOG(l_error_msg, 'csm_wf_pkg.User_Del',FND_LOG.LEVEL_EXCEPTION);

3717: l_sqlerrno := to_char(SQLCODE);
3718: l_sqlerrmsg := substr(SQLERRM, 1,2000);
3719: l_error_msg := ' Exception in User_Del for user_id:'
3720: || to_char(p_user_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
3721: CSM_UTIL_PKG.LOG(l_error_msg, 'csm_wf_pkg.User_Del',FND_LOG.LEVEL_EXCEPTION);
3722: RAISE;
3723: END User_Del;
3724:
3725: PROCEDURE RAISE_START_AUTO_SYNC_EVENT(l_entity VARCHAR2 , l_pk_value VARCHAR2, l_mode VARCHAR2)

Line 3746: 'CSM_WF_PKG.RAISE_START_AUTO_SYNC_EVENT',FND_LOG.LEVEL_PROCEDURE);

3742: close c_access;
3743:
3744: IF l_e is NULL OR (l_e < 0) THEN
3745: CSM_UTIL_PKG.LOG('Returning since Task Assignment Id '||l_pk_value ||' is not downloaded to any mfs user',
3746: 'CSM_WF_PKG.RAISE_START_AUTO_SYNC_EVENT',FND_LOG.LEVEL_PROCEDURE);
3747: RETURN;
3748: END IF;
3749: END IF;
3750:

Line 3761: CSM_UTIL_PKG.LOG('Raised auto sync event for : '||l_entity||'-'||l_pk_value||'-'||l_mode, 'CSM_WF_PKG.RAISE_START_AUTO_SYNC_EVENT',FND_LOG.LEVEL_PROCEDURE);

3757: wf_event.raise(p_event_name=>'oracle.apps.csm.download.startsync',
3758: p_event_key=>l_pk_value,p_parameters=>l_wf_param.getParameterList,
3759: p_event_data=>null,p_send_date=>null);
3760:
3761: CSM_UTIL_PKG.LOG('Raised auto sync event for : '||l_entity||'-'||l_pk_value||'-'||l_mode, 'CSM_WF_PKG.RAISE_START_AUTO_SYNC_EVENT',FND_LOG.LEVEL_PROCEDURE);
3762: EXCEPTION
3763: WHEN Others THEN
3764: CSM_UTIL_PKG.LOG('Returning with exception:'||substr(SQLERRM, 1,2000),'CSM_WF_PKG.RAISE_START_AUTO_SYNC_EVENT',FND_LOG.LEVEL_PROCEDURE);
3765: END RAISE_START_AUTO_SYNC_EVENT;

Line 3764: CSM_UTIL_PKG.LOG('Returning with exception:'||substr(SQLERRM, 1,2000),'CSM_WF_PKG.RAISE_START_AUTO_SYNC_EVENT',FND_LOG.LEVEL_PROCEDURE);

3760:
3761: CSM_UTIL_PKG.LOG('Raised auto sync event for : '||l_entity||'-'||l_pk_value||'-'||l_mode, 'CSM_WF_PKG.RAISE_START_AUTO_SYNC_EVENT',FND_LOG.LEVEL_PROCEDURE);
3762: EXCEPTION
3763: WHEN Others THEN
3764: CSM_UTIL_PKG.LOG('Returning with exception:'||substr(SQLERRM, 1,2000),'CSM_WF_PKG.RAISE_START_AUTO_SYNC_EVENT',FND_LOG.LEVEL_PROCEDURE);
3765: END RAISE_START_AUTO_SYNC_EVENT;
3766:
3767: END CSM_WF_PKG;