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 CSP_REQ_LINE_DETAILS

Line 2804: PROCEDURE CSP_REQ_LINE_DETAILS_POST_INS(x_return_status OUT NOCOPY varchar2)

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
2806: l_req_line_id csp_requirement_lines.requirement_line_id%TYPE;
2807: l_req_line_detail_id csp_req_line_details.req_line_detail_id%TYPE;
2808: l_sqlerrno varchar2(20);

Line 2807: l_req_line_detail_id csp_req_line_details.req_line_detail_id%TYPE;

2803:
2804: PROCEDURE CSP_REQ_LINE_DETAILS_POST_INS(x_return_status OUT NOCOPY varchar2)
2805: IS
2806: l_req_line_id csp_requirement_lines.requirement_line_id%TYPE;
2807: l_req_line_detail_id csp_req_line_details.req_line_detail_id%TYPE;
2808: l_sqlerrno varchar2(20);
2809: l_sqlerrmsg varchar2(2000);
2810:
2811: BEGIN

Line 2818: CSM_UTIL_PKG.LOG('Entering CSM_WF_PKG.CSP_REQ_LINE_DETAILS_POST_INS', 'CSM_WF_PKG.CSP_REQ_LINE_DETAILS_POST_INS',

2814: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
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

Line 2821: l_req_line_id :=CSP_REQ_LINE_DETAILS_PKG.user_hook_rec.REQUIREMENT_LINE_ID; --CSF tech portal seems to pass this wrongly

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:
2824: -- l_src:=CSP_REQ_LINE_DETAILS_PKG.user_hook_rec.source_type; --remains NULL thru iUhk
2825: -- l_src_id:=CSP_REQ_LINE_DETAILS_PKG.user_hook_rec.source_id;

Line 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

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:
2824: -- l_src:=CSP_REQ_LINE_DETAILS_PKG.user_hook_rec.source_type; --remains NULL thru iUhk
2825: -- l_src_id:=CSP_REQ_LINE_DETAILS_PKG.user_hook_rec.source_id;
2826:

Line 2824: -- l_src:=CSP_REQ_LINE_DETAILS_PKG.user_hook_rec.source_type; --remains NULL thru iUhk

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:
2824: -- l_src:=CSP_REQ_LINE_DETAILS_PKG.user_hook_rec.source_type; --remains NULL thru iUhk
2825: -- l_src_id:=CSP_REQ_LINE_DETAILS_PKG.user_hook_rec.source_id;
2826:
2827: csm_csp_req_lines_event_pkg.REQ_LINE_DTL_IUD(l_req_line_detail_id,'I');
2828:

Line 2825: -- l_src_id:=CSP_REQ_LINE_DETAILS_PKG.user_hook_rec.source_id;

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:
2824: -- l_src:=CSP_REQ_LINE_DETAILS_PKG.user_hook_rec.source_type; --remains NULL thru iUhk
2825: -- l_src_id:=CSP_REQ_LINE_DETAILS_PKG.user_hook_rec.source_id;
2826:
2827: csm_csp_req_lines_event_pkg.REQ_LINE_DTL_IUD(l_req_line_detail_id,'I');
2828:
2829: --Notify User of new Order placed

Line 2832: CSM_UTIL_PKG.LOG('Leaving CSM_WF_PKG.CSP_REQ_LINE_DETAILS_POST_INS', 'CSM_WF_PKG.CSP_REQ_LINE_DETAILS_POST_INS',

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

Line 2840: CSM_UTIL_PKG.LOG('Exception in CSM_WF_PKG.CSP_REQ_LINE_DETAILS_POST_INS:' || l_sqlerrno || ':' || l_sqlerrmsg,

2836: WHEN OTHERS THEN
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:

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 2843: END CSP_REQ_LINE_DETAILS_POST_INS;

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)
2846: IS
2847: l_req_line_id csp_requirement_lines.requirement_line_id%TYPE;

Line 2845: PROCEDURE CSP_REQ_LINE_DETAILS_POST_UPD(x_return_status OUT NOCOPY varchar2)

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)
2846: IS
2847: l_req_line_id csp_requirement_lines.requirement_line_id%TYPE;
2848: l_req_line_detail_id csp_req_line_details.req_line_detail_id%TYPE;
2849: l_sqlerrno varchar2(20);

Line 2848: l_req_line_detail_id csp_req_line_details.req_line_detail_id%TYPE;

2844:
2845: PROCEDURE CSP_REQ_LINE_DETAILS_POST_UPD(x_return_status OUT NOCOPY varchar2)
2846: IS
2847: l_req_line_id csp_requirement_lines.requirement_line_id%TYPE;
2848: l_req_line_detail_id csp_req_line_details.req_line_detail_id%TYPE;
2849: l_sqlerrno varchar2(20);
2850: l_sqlerrmsg varchar2(2000);
2851:
2852: BEGIN

Line 2859: CSM_UTIL_PKG.LOG('Entering CSM_WF_PKG.CSP_REQ_LINE_DETAILS_POST_UPD', 'CSM_WF_PKG.CSP_REQ_LINE_DETAILS_POST_UPD',

2855: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
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

Line 2862: l_req_line_id :=CSP_REQ_LINE_DETAILS_PKG.user_hook_rec.REQUIREMENT_LINE_ID; --CSF tech portal seems to pass this wrongly

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:
2865: csm_csp_req_lines_event_pkg.REQ_LINE_DTL_IUD(l_req_line_detail_id,'U');
2866:

Line 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

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:
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',

Line 2867: CSM_UTIL_PKG.LOG('Leaving CSM_WF_PKG.CSP_REQ_LINE_DETAILS_POST_UPD', 'CSM_WF_PKG.CSP_REQ_LINE_DETAILS_POST_UPD',

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

Line 2875: CSM_UTIL_PKG.LOG('Exception in CSM_WF_PKG.CSP_REQ_LINE_DETAILS_POST_UPD:' || l_sqlerrno || ':' || l_sqlerrmsg,

2871: WHEN OTHERS THEN
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:

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 2878: END CSP_REQ_LINE_DETAILS_POST_UPD;

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)
2881: IS
2882: l_req_line_id csp_requirement_lines.requirement_line_id%TYPE;

Line 2880: PROCEDURE CSP_REQ_LINE_DETAILS_PRE_DEL(x_return_status OUT NOCOPY varchar2)

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)
2881: IS
2882: l_req_line_id csp_requirement_lines.requirement_line_id%TYPE;
2883: l_req_line_detail_id csp_req_line_details.req_line_detail_id%TYPE;
2884: l_sqlerrno varchar2(20);

Line 2883: l_req_line_detail_id csp_req_line_details.req_line_detail_id%TYPE;

2879:
2880: PROCEDURE CSP_REQ_LINE_DETAILS_PRE_DEL(x_return_status OUT NOCOPY varchar2)
2881: IS
2882: l_req_line_id csp_requirement_lines.requirement_line_id%TYPE;
2883: l_req_line_detail_id csp_req_line_details.req_line_detail_id%TYPE;
2884: l_sqlerrno varchar2(20);
2885: l_sqlerrmsg varchar2(2000);
2886:
2887: BEGIN

Line 2894: CSM_UTIL_PKG.LOG('Entering CSM_WF_PKG.CSP_REQ_LINE_DETAILS_PRE_DEL', 'CSM_WF_PKG.CSP_REQ_LINE_DETAILS_PRE_DEL',

2890: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
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

Line 2897: l_req_line_id :=CSP_REQ_LINE_DETAILS_PKG.user_hook_rec.REQUIREMENT_LINE_ID; --CSF tech portal seems to pass this wrongly

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:
2900: csm_csp_req_lines_event_pkg.REQ_LINE_DTL_IUD(l_req_line_detail_id,'D');
2901:

Line 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

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:
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',

Line 2902: CSM_UTIL_PKG.LOG('Leaving CSM_WF_PKG.CSP_REQ_LINE_DETAILS_PRE_DEL', 'CSM_WF_PKG.CSP_REQ_LINE_DETAILS_PRE_DEL',

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

Line 2910: CSM_UTIL_PKG.LOG('Exception in CSM_WF_PKG.CSP_REQ_LINE_DETAILS_PRE_DEL:' || l_sqlerrno || ':' || l_sqlerrmsg,

2906: WHEN OTHERS THEN
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: /*--------------------------------------------------

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 2912: END CSP_REQ_LINE_DETAILS_PRE_DEL;

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:
2916: Starts the NOTES_INS_USERLOOP workflow. Should be called when new