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 2812: PROCEDURE CSP_REQ_LINE_DETAILS_POST_INS(x_return_status OUT NOCOPY varchar2)

2808: CSM_UTIL_PKG.LOG('Exception in CSM_WF_PKG.CSP_REQ_LINES_POST_DEL:' || l_sqlerrno || ':' || l_sqlerrmsg,
2809: 'CSM_WF_PKG.CSP_REQ_LINES_POST_DEL', FND_LOG.LEVEL_EXCEPTION);
2810: END CSP_REQ_LINES_POST_DEL;
2811:
2812: PROCEDURE CSP_REQ_LINE_DETAILS_POST_INS(x_return_status OUT NOCOPY varchar2)
2813: IS
2814: l_req_line_id csp_requirement_lines.requirement_line_id%TYPE;
2815: l_req_line_detail_id csp_req_line_details.req_line_detail_id%TYPE;
2816: l_sqlerrno varchar2(20);

Line 2815: l_req_line_detail_id csp_req_line_details.req_line_detail_id%TYPE;

2811:
2812: PROCEDURE CSP_REQ_LINE_DETAILS_POST_INS(x_return_status OUT NOCOPY varchar2)
2813: IS
2814: l_req_line_id csp_requirement_lines.requirement_line_id%TYPE;
2815: l_req_line_detail_id csp_req_line_details.req_line_detail_id%TYPE;
2816: l_sqlerrno varchar2(20);
2817: l_sqlerrmsg varchar2(2000);
2818:
2819: CURSOR l_req_line_csr(p_req_line_id IN NUMBER )

Line 2828: FROM csp_req_line_details

2824: WHERE acc.requirement_line_id = p_req_line_id;
2825:
2826: CURSOR l_req_line_id_csr(p_req_line_detail_id IN number) IS
2827: SELECT requirement_line_id
2828: FROM csp_req_line_details
2829: WHERE req_line_detail_id = p_req_line_detail_id;
2830:
2831: BEGIN
2832: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

2834: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
2835: RETURN;
2836: END IF;
2837:
2838: CSM_UTIL_PKG.LOG('Entering CSM_WF_PKG.CSP_REQ_LINE_DETAILS_POST_INS', 'CSM_WF_PKG.CSP_REQ_LINE_DETAILS_POST_INS',
2839: FND_LOG.LEVEL_PROCEDURE );
2840:
2841: l_req_line_detail_id := CSP_REQ_LINE_DETAILS_PKG.user_hook_rec.req_line_detail_id;
2842:

Line 2841: l_req_line_detail_id := CSP_REQ_LINE_DETAILS_PKG.user_hook_rec.req_line_detail_id;

2837:
2838: CSM_UTIL_PKG.LOG('Entering CSM_WF_PKG.CSP_REQ_LINE_DETAILS_POST_INS', 'CSM_WF_PKG.CSP_REQ_LINE_DETAILS_POST_INS',
2839: FND_LOG.LEVEL_PROCEDURE );
2840:
2841: l_req_line_detail_id := CSP_REQ_LINE_DETAILS_PKG.user_hook_rec.req_line_detail_id;
2842:
2843: OPEN l_req_line_id_csr(l_req_line_detail_id);
2844: FETCH l_req_line_id_csr INTO l_req_line_id;
2845: CLOSE l_req_line_id_csr;

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

2847: FOR r_req_line_rec IN l_req_line_csr(l_req_line_id) LOOP
2848: csm_csp_req_lines_event_pkg.csp_req_lines_mdirty_u(p_requirement_line_id=>l_req_line_id,
2849: p_user_id=>r_req_line_rec.user_id);
2850: END LOOP;
2851: CSM_UTIL_PKG.LOG('Leaving CSM_WF_PKG.CSP_REQ_LINE_DETAILS_POST_INS', 'CSM_WF_PKG.CSP_REQ_LINE_DETAILS_POST_INS',
2852: FND_LOG.LEVEL_PROCEDURE );
2853:
2854: EXCEPTION
2855: WHEN OTHERS THEN

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

2855: WHEN OTHERS THEN
2856: x_return_status := FND_API.G_RET_STS_ERROR;
2857: l_sqlerrno := to_char(SQLCODE);
2858: l_sqlerrmsg := substr(SQLERRM, 1,2000);
2859: CSM_UTIL_PKG.LOG('Exception in CSM_WF_PKG.CSP_REQ_LINE_DETAILS_POST_INS:' || l_sqlerrno || ':' || l_sqlerrmsg,
2860: 'CSM_WF_PKG.CSP_REQ_LINE_DETAILS_POST_INS', FND_LOG.LEVEL_EXCEPTION);
2861: x_return_status := FND_API.G_RET_STS_ERROR;
2862: END CSP_REQ_LINE_DETAILS_POST_INS;
2863:

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

2856: x_return_status := FND_API.G_RET_STS_ERROR;
2857: l_sqlerrno := to_char(SQLCODE);
2858: l_sqlerrmsg := substr(SQLERRM, 1,2000);
2859: CSM_UTIL_PKG.LOG('Exception in CSM_WF_PKG.CSP_REQ_LINE_DETAILS_POST_INS:' || l_sqlerrno || ':' || l_sqlerrmsg,
2860: 'CSM_WF_PKG.CSP_REQ_LINE_DETAILS_POST_INS', FND_LOG.LEVEL_EXCEPTION);
2861: x_return_status := FND_API.G_RET_STS_ERROR;
2862: END CSP_REQ_LINE_DETAILS_POST_INS;
2863:
2864: PROCEDURE CSP_REQ_LINE_DETAILS_POST_UPD(x_return_status OUT NOCOPY varchar2)

Line 2862: END CSP_REQ_LINE_DETAILS_POST_INS;

2858: l_sqlerrmsg := substr(SQLERRM, 1,2000);
2859: CSM_UTIL_PKG.LOG('Exception in CSM_WF_PKG.CSP_REQ_LINE_DETAILS_POST_INS:' || l_sqlerrno || ':' || l_sqlerrmsg,
2860: 'CSM_WF_PKG.CSP_REQ_LINE_DETAILS_POST_INS', FND_LOG.LEVEL_EXCEPTION);
2861: x_return_status := FND_API.G_RET_STS_ERROR;
2862: END CSP_REQ_LINE_DETAILS_POST_INS;
2863:
2864: PROCEDURE CSP_REQ_LINE_DETAILS_POST_UPD(x_return_status OUT NOCOPY varchar2)
2865: IS
2866: l_req_line_id csp_requirement_lines.requirement_line_id%TYPE;

Line 2864: PROCEDURE CSP_REQ_LINE_DETAILS_POST_UPD(x_return_status OUT NOCOPY varchar2)

2860: 'CSM_WF_PKG.CSP_REQ_LINE_DETAILS_POST_INS', FND_LOG.LEVEL_EXCEPTION);
2861: x_return_status := FND_API.G_RET_STS_ERROR;
2862: END CSP_REQ_LINE_DETAILS_POST_INS;
2863:
2864: PROCEDURE CSP_REQ_LINE_DETAILS_POST_UPD(x_return_status OUT NOCOPY varchar2)
2865: IS
2866: l_req_line_id csp_requirement_lines.requirement_line_id%TYPE;
2867: l_req_line_detail_id csp_req_line_details.req_line_detail_id%TYPE;
2868: l_sqlerrno varchar2(20);

Line 2867: l_req_line_detail_id csp_req_line_details.req_line_detail_id%TYPE;

2863:
2864: PROCEDURE CSP_REQ_LINE_DETAILS_POST_UPD(x_return_status OUT NOCOPY varchar2)
2865: IS
2866: l_req_line_id csp_requirement_lines.requirement_line_id%TYPE;
2867: l_req_line_detail_id csp_req_line_details.req_line_detail_id%TYPE;
2868: l_sqlerrno varchar2(20);
2869: l_sqlerrmsg varchar2(2000);
2870:
2871: CURSOR l_req_line_csr(p_req_line_id IN NUMBER )

Line 2880: FROM csp_req_line_details

2876: WHERE acc.requirement_line_id = p_req_line_id;
2877:
2878: CURSOR l_req_line_id_csr(p_req_line_detail_id IN number) IS
2879: SELECT requirement_line_id
2880: FROM csp_req_line_details
2881: WHERE req_line_detail_id = p_req_line_detail_id;
2882:
2883: BEGIN
2884: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

2886: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
2887: RETURN;
2888: END IF;
2889:
2890: CSM_UTIL_PKG.LOG('Entering CSM_WF_PKG.CSP_REQ_LINE_DETAILS_POST_UPD', 'CSM_WF_PKG.CSP_REQ_LINE_DETAILS_POST_UPD',
2891: FND_LOG.LEVEL_PROCEDURE );
2892:
2893: l_req_line_detail_id := CSP_REQ_LINE_DETAILS_PKG.user_hook_rec.req_line_detail_id;
2894:

Line 2893: l_req_line_detail_id := CSP_REQ_LINE_DETAILS_PKG.user_hook_rec.req_line_detail_id;

2889:
2890: CSM_UTIL_PKG.LOG('Entering CSM_WF_PKG.CSP_REQ_LINE_DETAILS_POST_UPD', 'CSM_WF_PKG.CSP_REQ_LINE_DETAILS_POST_UPD',
2891: FND_LOG.LEVEL_PROCEDURE );
2892:
2893: l_req_line_detail_id := CSP_REQ_LINE_DETAILS_PKG.user_hook_rec.req_line_detail_id;
2894:
2895: OPEN l_req_line_id_csr(l_req_line_detail_id);
2896: FETCH l_req_line_id_csr INTO l_req_line_id;
2897: CLOSE l_req_line_id_csr;

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

2900: csm_csp_req_lines_event_pkg.csp_req_lines_mdirty_u(p_requirement_line_id=>l_req_line_id,
2901: p_user_id=>r_req_line_rec.user_id);
2902: END LOOP;
2903:
2904: CSM_UTIL_PKG.LOG('Leaving CSM_WF_PKG.CSP_REQ_LINE_DETAILS_POST_UPD', 'CSM_WF_PKG.CSP_REQ_LINE_DETAILS_POST_UPD',
2905: FND_LOG.LEVEL_PROCEDURE );
2906:
2907: EXCEPTION
2908: WHEN OTHERS THEN

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

2908: WHEN OTHERS THEN
2909: x_return_status := FND_API.G_RET_STS_ERROR;
2910: l_sqlerrno := to_char(SQLCODE);
2911: l_sqlerrmsg := substr(SQLERRM, 1,2000);
2912: CSM_UTIL_PKG.LOG('Exception in CSM_WF_PKG.CSP_REQ_LINE_DETAILS_POST_UPD:' || l_sqlerrno || ':' || l_sqlerrmsg,
2913: 'CSM_WF_PKG.CSP_REQ_LINE_DETAILS_POST_UPD', FND_LOG.LEVEL_EXCEPTION);
2914: x_return_status := FND_API.G_RET_STS_ERROR;
2915: END CSP_REQ_LINE_DETAILS_POST_UPD;
2916:

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

2909: x_return_status := FND_API.G_RET_STS_ERROR;
2910: l_sqlerrno := to_char(SQLCODE);
2911: l_sqlerrmsg := substr(SQLERRM, 1,2000);
2912: CSM_UTIL_PKG.LOG('Exception in CSM_WF_PKG.CSP_REQ_LINE_DETAILS_POST_UPD:' || l_sqlerrno || ':' || l_sqlerrmsg,
2913: 'CSM_WF_PKG.CSP_REQ_LINE_DETAILS_POST_UPD', FND_LOG.LEVEL_EXCEPTION);
2914: x_return_status := FND_API.G_RET_STS_ERROR;
2915: END CSP_REQ_LINE_DETAILS_POST_UPD;
2916:
2917: PROCEDURE CSP_REQ_LINE_DETAILS_PRE_DEL(x_return_status OUT NOCOPY varchar2)

Line 2915: END CSP_REQ_LINE_DETAILS_POST_UPD;

2911: l_sqlerrmsg := substr(SQLERRM, 1,2000);
2912: CSM_UTIL_PKG.LOG('Exception in CSM_WF_PKG.CSP_REQ_LINE_DETAILS_POST_UPD:' || l_sqlerrno || ':' || l_sqlerrmsg,
2913: 'CSM_WF_PKG.CSP_REQ_LINE_DETAILS_POST_UPD', FND_LOG.LEVEL_EXCEPTION);
2914: x_return_status := FND_API.G_RET_STS_ERROR;
2915: END CSP_REQ_LINE_DETAILS_POST_UPD;
2916:
2917: PROCEDURE CSP_REQ_LINE_DETAILS_PRE_DEL(x_return_status OUT NOCOPY varchar2)
2918: IS
2919: l_req_line_id csp_requirement_lines.requirement_line_id%TYPE;

Line 2917: PROCEDURE CSP_REQ_LINE_DETAILS_PRE_DEL(x_return_status OUT NOCOPY varchar2)

2913: 'CSM_WF_PKG.CSP_REQ_LINE_DETAILS_POST_UPD', FND_LOG.LEVEL_EXCEPTION);
2914: x_return_status := FND_API.G_RET_STS_ERROR;
2915: END CSP_REQ_LINE_DETAILS_POST_UPD;
2916:
2917: PROCEDURE CSP_REQ_LINE_DETAILS_PRE_DEL(x_return_status OUT NOCOPY varchar2)
2918: IS
2919: l_req_line_id csp_requirement_lines.requirement_line_id%TYPE;
2920: l_req_line_detail_id csp_req_line_details.req_line_detail_id%TYPE;
2921: l_sqlerrno varchar2(20);

Line 2920: l_req_line_detail_id csp_req_line_details.req_line_detail_id%TYPE;

2916:
2917: PROCEDURE CSP_REQ_LINE_DETAILS_PRE_DEL(x_return_status OUT NOCOPY varchar2)
2918: IS
2919: l_req_line_id csp_requirement_lines.requirement_line_id%TYPE;
2920: l_req_line_detail_id csp_req_line_details.req_line_detail_id%TYPE;
2921: l_sqlerrno varchar2(20);
2922: l_sqlerrmsg varchar2(2000);
2923:
2924: CURSOR l_req_line_csr(p_req_line_id IN NUMBER )

Line 2933: FROM csp_req_line_details

2929: WHERE acc.requirement_line_id = p_req_line_id;
2930:
2931: CURSOR l_req_line_id_csr(p_req_line_detail_id IN number) IS
2932: SELECT requirement_line_id
2933: FROM csp_req_line_details
2934: WHERE req_line_detail_id = p_req_line_detail_id;
2935:
2936: BEGIN
2937: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

2939: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
2940: RETURN;
2941: END IF;
2942:
2943: CSM_UTIL_PKG.LOG('Entering CSM_WF_PKG.CSP_REQ_LINE_DETAILS_PRE_DEL', 'CSM_WF_PKG.CSP_REQ_LINE_DETAILS_PRE_DEL',
2944: FND_LOG.LEVEL_PROCEDURE );
2945:
2946: l_req_line_detail_id := CSP_REQ_LINE_DETAILS_PKG.user_hook_rec.req_line_detail_id;
2947:

Line 2946: l_req_line_detail_id := CSP_REQ_LINE_DETAILS_PKG.user_hook_rec.req_line_detail_id;

2942:
2943: CSM_UTIL_PKG.LOG('Entering CSM_WF_PKG.CSP_REQ_LINE_DETAILS_PRE_DEL', 'CSM_WF_PKG.CSP_REQ_LINE_DETAILS_PRE_DEL',
2944: FND_LOG.LEVEL_PROCEDURE );
2945:
2946: l_req_line_detail_id := CSP_REQ_LINE_DETAILS_PKG.user_hook_rec.req_line_detail_id;
2947:
2948: OPEN l_req_line_id_csr(l_req_line_detail_id);
2949: FETCH l_req_line_id_csr INTO l_req_line_id;
2950: CLOSE l_req_line_id_csr;

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

2953: csm_csp_req_lines_event_pkg.csp_req_lines_mdirty_u(p_requirement_line_id=>l_req_line_id,
2954: p_user_id=>r_req_line_rec.user_id);
2955: END LOOP;
2956:
2957: CSM_UTIL_PKG.LOG('Leaving CSM_WF_PKG.CSP_REQ_LINE_DETAILS_PRE_DEL', 'CSM_WF_PKG.CSP_REQ_LINE_DETAILS_PRE_DEL',
2958: FND_LOG.LEVEL_PROCEDURE );
2959:
2960: EXCEPTION
2961: WHEN OTHERS THEN

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

2961: WHEN OTHERS THEN
2962: x_return_status := FND_API.G_RET_STS_ERROR;
2963: l_sqlerrno := to_char(SQLCODE);
2964: l_sqlerrmsg := substr(SQLERRM, 1,2000);
2965: CSM_UTIL_PKG.LOG('Exception in CSM_WF_PKG.CSP_REQ_LINE_DETAILS_PRE_DEL:' || l_sqlerrno || ':' || l_sqlerrmsg,
2966: 'CSM_WF_PKG.CSP_REQ_LINE_DETAILS_PRE_DEL', FND_LOG.LEVEL_EXCEPTION);
2967: END CSP_REQ_LINE_DETAILS_PRE_DEL;
2968:
2969: /*--------------------------------------------------

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

2962: x_return_status := FND_API.G_RET_STS_ERROR;
2963: l_sqlerrno := to_char(SQLCODE);
2964: l_sqlerrmsg := substr(SQLERRM, 1,2000);
2965: CSM_UTIL_PKG.LOG('Exception in CSM_WF_PKG.CSP_REQ_LINE_DETAILS_PRE_DEL:' || l_sqlerrno || ':' || l_sqlerrmsg,
2966: 'CSM_WF_PKG.CSP_REQ_LINE_DETAILS_PRE_DEL', FND_LOG.LEVEL_EXCEPTION);
2967: END CSP_REQ_LINE_DETAILS_PRE_DEL;
2968:
2969: /*--------------------------------------------------
2970: Description:

Line 2967: END CSP_REQ_LINE_DETAILS_PRE_DEL;

2963: l_sqlerrno := to_char(SQLCODE);
2964: l_sqlerrmsg := substr(SQLERRM, 1,2000);
2965: CSM_UTIL_PKG.LOG('Exception in CSM_WF_PKG.CSP_REQ_LINE_DETAILS_PRE_DEL:' || l_sqlerrno || ':' || l_sqlerrmsg,
2966: 'CSM_WF_PKG.CSP_REQ_LINE_DETAILS_PRE_DEL', FND_LOG.LEVEL_EXCEPTION);
2967: END CSP_REQ_LINE_DETAILS_PRE_DEL;
2968:
2969: /*--------------------------------------------------
2970: Description:
2971: Starts the NOTES_INS_USERLOOP workflow. Should be called when new