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.CSP_REQ_LINE_DETAILS_PKG dependencies on FND_API

Line 47: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

43:
44: csp_req_line_details_iuhk.Create_req_line_detail_Pre
45: ( x_return_status => l_return_status
46: ) ;
47: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
48: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
49: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_INT_CUST_USR_HK');
50: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
51: FND_MSG_PUB.Add;

Line 52: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

48: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
49: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_INT_CUST_USR_HK');
50: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
51: FND_MSG_PUB.Add;
52: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
53: END IF;
54:
55:
56:

Line 57: If (l_req_line_details.REQ_LINE_DETAIL_ID IS NULL) OR (l_req_line_details.REQ_LINE_DETAIL_ID = FND_API.G_MISS_NUM) then

53: END IF;
54:
55:
56:
57: If (l_req_line_details.REQ_LINE_DETAIL_ID IS NULL) OR (l_req_line_details.REQ_LINE_DETAIL_ID = FND_API.G_MISS_NUM) then
58: OPEN C2;
59: FETCH C2 INTO px_REQ_LINE_DETAIL_ID;
60: CLOSE C2;
61: End If;

Line 78: decode( l_req_line_details.REQUIREMENT_LINE_ID, FND_API.G_MISS_NUM, NULL, l_req_line_details.REQUIREMENT_LINE_ID),

74: SOURCE_ID
75: )
76: VALUES (
77: px_REQ_LINE_DETAIL_ID,
78: decode( l_req_line_details.REQUIREMENT_LINE_ID, FND_API.G_MISS_NUM, NULL, l_req_line_details.REQUIREMENT_LINE_ID),
79: decode( l_req_line_details.CREATED_BY, FND_API.G_MISS_NUM, NULL, l_req_line_details.CREATED_BY),
80: decode( l_req_line_details.CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), l_req_line_details.CREATION_DATE),
81: decode( l_req_line_details.LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, l_req_line_details.LAST_UPDATED_BY),
82: decode( l_req_line_details.LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), l_req_line_details.LAST_UPDATE_DATE),

Line 79: decode( l_req_line_details.CREATED_BY, FND_API.G_MISS_NUM, NULL, l_req_line_details.CREATED_BY),

75: )
76: VALUES (
77: px_REQ_LINE_DETAIL_ID,
78: decode( l_req_line_details.REQUIREMENT_LINE_ID, FND_API.G_MISS_NUM, NULL, l_req_line_details.REQUIREMENT_LINE_ID),
79: decode( l_req_line_details.CREATED_BY, FND_API.G_MISS_NUM, NULL, l_req_line_details.CREATED_BY),
80: decode( l_req_line_details.CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), l_req_line_details.CREATION_DATE),
81: decode( l_req_line_details.LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, l_req_line_details.LAST_UPDATED_BY),
82: decode( l_req_line_details.LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), l_req_line_details.LAST_UPDATE_DATE),
83: decode( l_req_line_details.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, l_req_line_details.LAST_UPDATE_LOGIN),

Line 80: decode( l_req_line_details.CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), l_req_line_details.CREATION_DATE),

76: VALUES (
77: px_REQ_LINE_DETAIL_ID,
78: decode( l_req_line_details.REQUIREMENT_LINE_ID, FND_API.G_MISS_NUM, NULL, l_req_line_details.REQUIREMENT_LINE_ID),
79: decode( l_req_line_details.CREATED_BY, FND_API.G_MISS_NUM, NULL, l_req_line_details.CREATED_BY),
80: decode( l_req_line_details.CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), l_req_line_details.CREATION_DATE),
81: decode( l_req_line_details.LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, l_req_line_details.LAST_UPDATED_BY),
82: decode( l_req_line_details.LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), l_req_line_details.LAST_UPDATE_DATE),
83: decode( l_req_line_details.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, l_req_line_details.LAST_UPDATE_LOGIN),
84: decode( l_req_line_details.SOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, l_req_line_details.SOURCE_TYPE),

Line 81: decode( l_req_line_details.LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, l_req_line_details.LAST_UPDATED_BY),

77: px_REQ_LINE_DETAIL_ID,
78: decode( l_req_line_details.REQUIREMENT_LINE_ID, FND_API.G_MISS_NUM, NULL, l_req_line_details.REQUIREMENT_LINE_ID),
79: decode( l_req_line_details.CREATED_BY, FND_API.G_MISS_NUM, NULL, l_req_line_details.CREATED_BY),
80: decode( l_req_line_details.CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), l_req_line_details.CREATION_DATE),
81: decode( l_req_line_details.LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, l_req_line_details.LAST_UPDATED_BY),
82: decode( l_req_line_details.LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), l_req_line_details.LAST_UPDATE_DATE),
83: decode( l_req_line_details.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, l_req_line_details.LAST_UPDATE_LOGIN),
84: decode( l_req_line_details.SOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, l_req_line_details.SOURCE_TYPE),
85: decode( l_req_line_details.SOURCE_ID, FND_API.G_MISS_NUM, NULL, l_req_line_details.SOURCE_ID)

Line 82: decode( l_req_line_details.LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), l_req_line_details.LAST_UPDATE_DATE),

78: decode( l_req_line_details.REQUIREMENT_LINE_ID, FND_API.G_MISS_NUM, NULL, l_req_line_details.REQUIREMENT_LINE_ID),
79: decode( l_req_line_details.CREATED_BY, FND_API.G_MISS_NUM, NULL, l_req_line_details.CREATED_BY),
80: decode( l_req_line_details.CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), l_req_line_details.CREATION_DATE),
81: decode( l_req_line_details.LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, l_req_line_details.LAST_UPDATED_BY),
82: decode( l_req_line_details.LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), l_req_line_details.LAST_UPDATE_DATE),
83: decode( l_req_line_details.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, l_req_line_details.LAST_UPDATE_LOGIN),
84: decode( l_req_line_details.SOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, l_req_line_details.SOURCE_TYPE),
85: decode( l_req_line_details.SOURCE_ID, FND_API.G_MISS_NUM, NULL, l_req_line_details.SOURCE_ID)
86: );

Line 83: decode( l_req_line_details.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, l_req_line_details.LAST_UPDATE_LOGIN),

79: decode( l_req_line_details.CREATED_BY, FND_API.G_MISS_NUM, NULL, l_req_line_details.CREATED_BY),
80: decode( l_req_line_details.CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), l_req_line_details.CREATION_DATE),
81: decode( l_req_line_details.LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, l_req_line_details.LAST_UPDATED_BY),
82: decode( l_req_line_details.LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), l_req_line_details.LAST_UPDATE_DATE),
83: decode( l_req_line_details.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, l_req_line_details.LAST_UPDATE_LOGIN),
84: decode( l_req_line_details.SOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, l_req_line_details.SOURCE_TYPE),
85: decode( l_req_line_details.SOURCE_ID, FND_API.G_MISS_NUM, NULL, l_req_line_details.SOURCE_ID)
86: );
87:

Line 84: decode( l_req_line_details.SOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, l_req_line_details.SOURCE_TYPE),

80: decode( l_req_line_details.CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), l_req_line_details.CREATION_DATE),
81: decode( l_req_line_details.LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, l_req_line_details.LAST_UPDATED_BY),
82: decode( l_req_line_details.LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), l_req_line_details.LAST_UPDATE_DATE),
83: decode( l_req_line_details.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, l_req_line_details.LAST_UPDATE_LOGIN),
84: decode( l_req_line_details.SOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, l_req_line_details.SOURCE_TYPE),
85: decode( l_req_line_details.SOURCE_ID, FND_API.G_MISS_NUM, NULL, l_req_line_details.SOURCE_ID)
86: );
87:
88: user_hook_rec.REQUIREMENT_LINE_ID := l_req_line_details.REQUIREMENT_LINE_ID;

Line 85: decode( l_req_line_details.SOURCE_ID, FND_API.G_MISS_NUM, NULL, l_req_line_details.SOURCE_ID)

81: decode( l_req_line_details.LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, l_req_line_details.LAST_UPDATED_BY),
82: decode( l_req_line_details.LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), l_req_line_details.LAST_UPDATE_DATE),
83: decode( l_req_line_details.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, l_req_line_details.LAST_UPDATE_LOGIN),
84: decode( l_req_line_details.SOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, l_req_line_details.SOURCE_TYPE),
85: decode( l_req_line_details.SOURCE_ID, FND_API.G_MISS_NUM, NULL, l_req_line_details.SOURCE_ID)
86: );
87:
88: user_hook_rec.REQUIREMENT_LINE_ID := l_req_line_details.REQUIREMENT_LINE_ID;
89: csp_req_line_details_iuhk.Create_req_line_detail_Post

Line 92: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

88: user_hook_rec.REQUIREMENT_LINE_ID := l_req_line_details.REQUIREMENT_LINE_ID;
89: csp_req_line_details_iuhk.Create_req_line_detail_Post
90: ( x_return_status => l_return_status
91: ) ;
92: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
93: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
94: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_INT_USR_HK');
95: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
96: FND_MSG_PUB.Add;

Line 97: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

93: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
94: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_INT_USR_HK');
95: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
96: FND_MSG_PUB.Add;
97: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
98: END IF;
99:
100: End Insert_Row;
101:

Line 133: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

129: user_hook_rec.REQ_LINE_DETAIL_ID := l_req_line_details.REQ_LINE_DETAIL_ID;
130: csp_req_line_details_iuhk.Update_req_line_detail_Pre
131: ( x_return_status => l_return_status
132: ) ;
133: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
134: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
135: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_INT_CUST_USR_HK');
136: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
137: FND_MSG_PUB.Add;

Line 138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

134: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
135: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_INT_CUST_USR_HK');
136: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
137: FND_MSG_PUB.Add;
138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
139: END IF;
140:
141:
142: Update CSP_REQ_LINE_DETAILS

Line 144: REQUIREMENT_LINE_ID = decode( l_req_line_details.REQUIREMENT_LINE_ID, FND_API.G_MISS_NUM, REQUIREMENT_LINE_ID, l_req_line_details.REQUIREMENT_LINE_ID),

140:
141:
142: Update CSP_REQ_LINE_DETAILS
143: SET
144: REQUIREMENT_LINE_ID = decode( l_req_line_details.REQUIREMENT_LINE_ID, FND_API.G_MISS_NUM, REQUIREMENT_LINE_ID, l_req_line_details.REQUIREMENT_LINE_ID),
145: CREATED_BY = decode( l_req_line_details.CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, l_req_line_details.CREATED_BY),
146: CREATION_DATE = decode( l_req_line_details.CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, l_req_line_details.CREATION_DATE),
147: LAST_UPDATED_BY = decode( l_req_line_details.LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, l_req_line_details.LAST_UPDATED_BY),
148: LAST_UPDATE_DATE = decode( l_req_line_details.LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, l_req_line_details.LAST_UPDATE_DATE),

Line 145: CREATED_BY = decode( l_req_line_details.CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, l_req_line_details.CREATED_BY),

141:
142: Update CSP_REQ_LINE_DETAILS
143: SET
144: REQUIREMENT_LINE_ID = decode( l_req_line_details.REQUIREMENT_LINE_ID, FND_API.G_MISS_NUM, REQUIREMENT_LINE_ID, l_req_line_details.REQUIREMENT_LINE_ID),
145: CREATED_BY = decode( l_req_line_details.CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, l_req_line_details.CREATED_BY),
146: CREATION_DATE = decode( l_req_line_details.CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, l_req_line_details.CREATION_DATE),
147: LAST_UPDATED_BY = decode( l_req_line_details.LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, l_req_line_details.LAST_UPDATED_BY),
148: LAST_UPDATE_DATE = decode( l_req_line_details.LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, l_req_line_details.LAST_UPDATE_DATE),
149: LAST_UPDATE_LOGIN = decode( l_req_line_details.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, l_req_line_details.LAST_UPDATE_LOGIN),

Line 146: CREATION_DATE = decode( l_req_line_details.CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, l_req_line_details.CREATION_DATE),

142: Update CSP_REQ_LINE_DETAILS
143: SET
144: REQUIREMENT_LINE_ID = decode( l_req_line_details.REQUIREMENT_LINE_ID, FND_API.G_MISS_NUM, REQUIREMENT_LINE_ID, l_req_line_details.REQUIREMENT_LINE_ID),
145: CREATED_BY = decode( l_req_line_details.CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, l_req_line_details.CREATED_BY),
146: CREATION_DATE = decode( l_req_line_details.CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, l_req_line_details.CREATION_DATE),
147: LAST_UPDATED_BY = decode( l_req_line_details.LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, l_req_line_details.LAST_UPDATED_BY),
148: LAST_UPDATE_DATE = decode( l_req_line_details.LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, l_req_line_details.LAST_UPDATE_DATE),
149: LAST_UPDATE_LOGIN = decode( l_req_line_details.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, l_req_line_details.LAST_UPDATE_LOGIN),
150: SOURCE_TYPE = decode( l_req_line_details.SOURCE_TYPE, FND_API.G_MISS_CHAR, SOURCE_TYPE, l_req_line_details.SOURCE_TYPE),

Line 147: LAST_UPDATED_BY = decode( l_req_line_details.LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, l_req_line_details.LAST_UPDATED_BY),

143: SET
144: REQUIREMENT_LINE_ID = decode( l_req_line_details.REQUIREMENT_LINE_ID, FND_API.G_MISS_NUM, REQUIREMENT_LINE_ID, l_req_line_details.REQUIREMENT_LINE_ID),
145: CREATED_BY = decode( l_req_line_details.CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, l_req_line_details.CREATED_BY),
146: CREATION_DATE = decode( l_req_line_details.CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, l_req_line_details.CREATION_DATE),
147: LAST_UPDATED_BY = decode( l_req_line_details.LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, l_req_line_details.LAST_UPDATED_BY),
148: LAST_UPDATE_DATE = decode( l_req_line_details.LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, l_req_line_details.LAST_UPDATE_DATE),
149: LAST_UPDATE_LOGIN = decode( l_req_line_details.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, l_req_line_details.LAST_UPDATE_LOGIN),
150: SOURCE_TYPE = decode( l_req_line_details.SOURCE_TYPE, FND_API.G_MISS_CHAR, SOURCE_TYPE, l_req_line_details.SOURCE_TYPE),
151: SOURCE_ID = decode( l_req_line_details.SOURCE_ID, FND_API.G_MISS_NUM, SOURCE_ID, l_req_line_details.SOURCE_ID)

Line 148: LAST_UPDATE_DATE = decode( l_req_line_details.LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, l_req_line_details.LAST_UPDATE_DATE),

144: REQUIREMENT_LINE_ID = decode( l_req_line_details.REQUIREMENT_LINE_ID, FND_API.G_MISS_NUM, REQUIREMENT_LINE_ID, l_req_line_details.REQUIREMENT_LINE_ID),
145: CREATED_BY = decode( l_req_line_details.CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, l_req_line_details.CREATED_BY),
146: CREATION_DATE = decode( l_req_line_details.CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, l_req_line_details.CREATION_DATE),
147: LAST_UPDATED_BY = decode( l_req_line_details.LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, l_req_line_details.LAST_UPDATED_BY),
148: LAST_UPDATE_DATE = decode( l_req_line_details.LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, l_req_line_details.LAST_UPDATE_DATE),
149: LAST_UPDATE_LOGIN = decode( l_req_line_details.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, l_req_line_details.LAST_UPDATE_LOGIN),
150: SOURCE_TYPE = decode( l_req_line_details.SOURCE_TYPE, FND_API.G_MISS_CHAR, SOURCE_TYPE, l_req_line_details.SOURCE_TYPE),
151: SOURCE_ID = decode( l_req_line_details.SOURCE_ID, FND_API.G_MISS_NUM, SOURCE_ID, l_req_line_details.SOURCE_ID)
152: where REQ_LINE_DETAIL_ID = l_req_line_details.REQ_LINE_DETAIL_ID;

Line 149: LAST_UPDATE_LOGIN = decode( l_req_line_details.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, l_req_line_details.LAST_UPDATE_LOGIN),

145: CREATED_BY = decode( l_req_line_details.CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, l_req_line_details.CREATED_BY),
146: CREATION_DATE = decode( l_req_line_details.CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, l_req_line_details.CREATION_DATE),
147: LAST_UPDATED_BY = decode( l_req_line_details.LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, l_req_line_details.LAST_UPDATED_BY),
148: LAST_UPDATE_DATE = decode( l_req_line_details.LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, l_req_line_details.LAST_UPDATE_DATE),
149: LAST_UPDATE_LOGIN = decode( l_req_line_details.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, l_req_line_details.LAST_UPDATE_LOGIN),
150: SOURCE_TYPE = decode( l_req_line_details.SOURCE_TYPE, FND_API.G_MISS_CHAR, SOURCE_TYPE, l_req_line_details.SOURCE_TYPE),
151: SOURCE_ID = decode( l_req_line_details.SOURCE_ID, FND_API.G_MISS_NUM, SOURCE_ID, l_req_line_details.SOURCE_ID)
152: where REQ_LINE_DETAIL_ID = l_req_line_details.REQ_LINE_DETAIL_ID;
153:

Line 150: SOURCE_TYPE = decode( l_req_line_details.SOURCE_TYPE, FND_API.G_MISS_CHAR, SOURCE_TYPE, l_req_line_details.SOURCE_TYPE),

146: CREATION_DATE = decode( l_req_line_details.CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, l_req_line_details.CREATION_DATE),
147: LAST_UPDATED_BY = decode( l_req_line_details.LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, l_req_line_details.LAST_UPDATED_BY),
148: LAST_UPDATE_DATE = decode( l_req_line_details.LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, l_req_line_details.LAST_UPDATE_DATE),
149: LAST_UPDATE_LOGIN = decode( l_req_line_details.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, l_req_line_details.LAST_UPDATE_LOGIN),
150: SOURCE_TYPE = decode( l_req_line_details.SOURCE_TYPE, FND_API.G_MISS_CHAR, SOURCE_TYPE, l_req_line_details.SOURCE_TYPE),
151: SOURCE_ID = decode( l_req_line_details.SOURCE_ID, FND_API.G_MISS_NUM, SOURCE_ID, l_req_line_details.SOURCE_ID)
152: where REQ_LINE_DETAIL_ID = l_req_line_details.REQ_LINE_DETAIL_ID;
153:
154: csp_req_line_details_iuhk.Update_req_line_detail_post

Line 151: SOURCE_ID = decode( l_req_line_details.SOURCE_ID, FND_API.G_MISS_NUM, SOURCE_ID, l_req_line_details.SOURCE_ID)

147: LAST_UPDATED_BY = decode( l_req_line_details.LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, l_req_line_details.LAST_UPDATED_BY),
148: LAST_UPDATE_DATE = decode( l_req_line_details.LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, l_req_line_details.LAST_UPDATE_DATE),
149: LAST_UPDATE_LOGIN = decode( l_req_line_details.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, l_req_line_details.LAST_UPDATE_LOGIN),
150: SOURCE_TYPE = decode( l_req_line_details.SOURCE_TYPE, FND_API.G_MISS_CHAR, SOURCE_TYPE, l_req_line_details.SOURCE_TYPE),
151: SOURCE_ID = decode( l_req_line_details.SOURCE_ID, FND_API.G_MISS_NUM, SOURCE_ID, l_req_line_details.SOURCE_ID)
152: where REQ_LINE_DETAIL_ID = l_req_line_details.REQ_LINE_DETAIL_ID;
153:
154: csp_req_line_details_iuhk.Update_req_line_detail_post
155: ( x_return_status => l_return_status

Line 157: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

153:
154: csp_req_line_details_iuhk.Update_req_line_detail_post
155: ( x_return_status => l_return_status
156: ) ;
157: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
158: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
159: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_INT_CUST_USR_HK');
160: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
161: FND_MSG_PUB.Add;

Line 162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

158: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
159: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_INT_CUST_USR_HK');
160: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
161: FND_MSG_PUB.Add;
162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
163: END IF;
164:
165: If (SQL%NOTFOUND) then
166: RAISE NO_DATA_FOUND;

Line 184: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

180: user_hook_rec.REQ_LINE_DETAIL_ID := px_REQ_LINE_DETAIL_ID;
181: csp_req_line_details_iuhk.delete_req_line_detail_Pre
182: ( x_return_status => l_return_status
183: ) ;
184: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
185: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
186: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_INT_CUST_USR_HK');
187: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
188: FND_MSG_PUB.Add;

Line 189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

185: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
186: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_INT_CUST_USR_HK');
187: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
188: FND_MSG_PUB.Add;
189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
190: END IF;
191: DELETE FROM CSP_REQ_LINE_DETAILS
192: WHERE REQ_LINE_DETAIL_ID = px_REQ_LINE_DETAIL_ID;
193: csp_req_line_details_iuhk.delete_req_line_detail_Post

Line 196: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

192: WHERE REQ_LINE_DETAIL_ID = px_REQ_LINE_DETAIL_ID;
193: csp_req_line_details_iuhk.delete_req_line_detail_Post
194: ( x_return_status => l_return_status
195: ) ;
196: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
197: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
198: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_INT_CUST_USR_HK');
199: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
200: FND_MSG_PUB.Add;

Line 201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

197: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
198: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_INT_CUST_USR_HK');
199: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
200: FND_MSG_PUB.Add;
201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
202: END IF;
203: If (SQL%NOTFOUND) then
204: RAISE NO_DATA_FOUND;
205: End If;