APPS.GMD_CUSTOMER_TESTS_GRP dependencies on GMD_API_PUB

Line 22: GMD_API_PUB.log_message('GMD','GMD_TEST_ID_CODE_NULL');

18: BEGIN
19: l_progress := '010';
20:
21: IF p_test_id IS NULL THEN
22: GMD_API_PUB.log_message('GMD','GMD_TEST_ID_CODE_NULL');
23: RETURN FALSE;
24: END IF;
25:
26: IF p_cust_id is NULL THEN

Line 27: GMD_API_PUB.log_message('GMD_API_CUST_ID_NULL');

23: RETURN FALSE;
24: END IF;
25:
26: IF p_cust_id is NULL THEN
27: GMD_API_PUB.log_message('GMD_API_CUST_ID_NULL');
28: RETURN FALSE;
29: END IF;
30:
31: l_progress := '020';

Line 103: GMD_API_PUB.log_message('GMD_TEST_ID_CODE_NULL');

99:
100: -- Validate that required Fields are populated.
101:
102: IF p_customer_tests_rec.test_id is NULL THEN
103: GMD_API_PUB.log_message('GMD_TEST_ID_CODE_NULL');
104: RAISE FND_API.G_EXC_ERROR;
105: ELSE
106: -- Check Test is Valid
107: OPEN c_check_test (p_customer_tests_rec.test_id);

Line 112: GMD_API_PUB.log_message('GMD_INVALID_TEST_ID',

108: FETCH c_check_test INTO l_display_precision,
109: l_test_type,l_delete_mark;
110: IF c_check_test%NOTFOUND THEN
111: CLOSE c_check_test;
112: GMD_API_PUB.log_message('GMD_INVALID_TEST_ID',
113: 'TEST_ID',p_customer_tests_rec.test_id);
114: RAISE FND_API.G_EXC_ERROR;
115: END IF;
116: CLOSE c_check_test;

Line 121: GMD_API_PUB.log_message('GMD_API_CUST_ID_NULL');

117: END IF;
118:
119:
120: IF p_customer_tests_rec.cust_id is NULL THEN
121: GMD_API_PUB.log_message('GMD_API_CUST_ID_NULL');
122: RAISE FND_API.G_EXC_ERROR;
123: ELSE
124: -- Check Customer is Valid
125: OPEN c_check_cust (p_customer_tests_rec.cust_id);

Line 129: GMD_API_PUB.log_message('GMD_INVALID_CUST_ID',

125: OPEN c_check_cust (p_customer_tests_rec.cust_id);
126: FETCH c_check_cust INTO l_dummy;
127: IF c_check_cust%NOTFOUND THEN
128: CLOSE c_check_cust;
129: GMD_API_PUB.log_message('GMD_INVALID_CUST_ID',
130: 'CUST_ID',p_customer_tests_rec.cust_id);
131: RAISE FND_API.G_EXC_ERROR;
132: END IF;
133: CLOSE c_check_cust;

Line 140: GMD_API_PUB.log_message('GMD_TEST_DELETED',

136:
137: -- Validate that header record is not delete Marked.
138:
139: IF l_delete_mark = 1 THEN
140: GMD_API_PUB.log_message('GMD_TEST_DELETED',
141: 'TEST',p_customer_tests_rec.test_id);
142: RAISE FND_API.G_EXC_ERROR;
143: END IF;
144:

Line 152: GMD_API_PUB.log_message('GMD_CUST_TESTS_EXISTS',

148:
149: IF CHECK_EXISTS ( p_test_id => p_customer_tests_rec.test_id,
150: p_cust_id => p_customer_tests_rec.cust_id) THEN
151:
152: GMD_API_PUB.log_message('GMD_CUST_TESTS_EXISTS',
153: 'CUST_ID',p_customer_tests_rec.cust_id,
154: 'TEST_ID',p_customer_tests_rec.test_id);
155: RAISE FND_API.G_EXC_ERROR;
156: END IF;

Line 163: GMD_API_PUB.log_message('GMD','GMD_CUST_TEST_REQ');

159: -- Validate Report Precison and Display
160:
161: IF p_customer_tests_rec.cust_test_display IS NULL AND
162: p_customer_tests_rec.report_precision IS NULL THEN
163: GMD_API_PUB.log_message('GMD','GMD_CUST_TEST_REQ');
164: RAISE FND_API.G_EXC_ERROR;
165: END IF;
166:
167: l_progress := '030';

Line 175: GMD_API_PUB.log_message('GMD_REP_GRTR_DIS_PRCSN',

171: IF l_test_type in ('L','N','E') THEN
172:
173: IF p_customer_tests_rec.report_precision is NOT NULL AND
174: p_customer_tests_rec.report_precision > l_display_precision THEN
175: GMD_API_PUB.log_message('GMD_REP_GRTR_DIS_PRCSN',
176: 'DISPLAY_PRECISION', l_display_precision);
177: RAISE FND_API.G_EXC_ERROR;
178:
179: END IF;

Line 183: GMD_API_PUB.log_message('GMD_REP_PRCSN_INVALID',

179: END IF;
180: ELSE
181:
182: IF p_customer_tests_rec.report_precision is NOT NULL THEN
183: GMD_API_PUB.log_message('GMD_REP_PRCSN_INVALID',
184: 'TEST_TYPE',l_test_type);
185: RAISE FND_API.G_EXC_ERROR;
186: END IF;
187:

Line 189: GMD_API_PUB.log_message('GMD_CUST_DISPLAY_REQ');

185: RAISE FND_API.G_EXC_ERROR;
186: END IF;
187:
188: IF p_customer_tests_rec.cust_test_display IS NULL THEN
189: GMD_API_PUB.log_message('GMD_CUST_DISPLAY_REQ');
190: RAISE FND_API.G_EXC_ERROR;
191: END IF;
192:
193: END IF;

Line 201: GMD_API_PUB.log_message('GMD_API_ERROR',

197: WHEN FND_API.G_EXC_ERROR THEN
198: x_return_status := FND_API.G_RET_STS_ERROR;
199: WHEN OTHERS THEN
200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
201: GMD_API_PUB.log_message('GMD_API_ERROR',
202: 'PACKAGE' , 'GMD_CUSTOMER_TESTS_GRP',
203: 'ERROR' , substr(sqlerrm,1,100),
204: 'POSITION' , l_progress);
205:

Line 235: GMD_API_PUB.log_message('GMD_TEST_ID_CODE_NULL');

231:
232: -- Validate that test_id and cust_id are populated.
233:
234: IF p_test_id is NULL THEN
235: GMD_API_PUB.log_message('GMD_TEST_ID_CODE_NULL');
236: RAISE FND_API.G_EXC_ERROR;
237: END IF;
238:
239: IF p_cust_id is NULL THEN

Line 240: GMD_API_PUB.log_message('GMD_API_CUST_ID_NULL');

236: RAISE FND_API.G_EXC_ERROR;
237: END IF;
238:
239: IF p_cust_id is NULL THEN
240: GMD_API_PUB.log_message('GMD_API_CUST_ID_NULL');
241: RAISE FND_API.G_EXC_ERROR;
242: END IF;
243:
244: -- Validate that record Exists

Line 249: GMD_API_PUB.log_message('GMD_CUST_TESTS_NOTEXISTS',

245:
246: IF NOT CHECK_EXISTS ( p_test_id => p_test_id,
247: p_cust_id => p_cust_id) THEN
248:
249: GMD_API_PUB.log_message('GMD_CUST_TESTS_NOTEXISTS',
250: 'CUST_ID',p_cust_id,
251: 'TEST_ID',p_test_id);
252: RAISE FND_API.G_EXC_ERROR;
253: END IF;

Line 265: GMD_API_PUB.log_message('GMD_TEST_DELETED',

261: CLOSE c_check_deleted;
262:
263: -- BUG 3554590 Check if the TEST is already deleted!
264: IF l_delete_mark = 1 THEN
265: GMD_API_PUB.log_message('GMD_TEST_DELETED',
266: 'TEST',p_test_id);
267: RAISE FND_API.G_EXC_ERROR;
268: END IF;
269:

Line 276: GMD_API_PUB.log_message('GMD_API_ERROR',

272: WHEN FND_API.G_EXC_ERROR THEN
273: x_return_status := FND_API.G_RET_STS_ERROR ;
274: WHEN OTHERS THEN
275: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
276: GMD_API_PUB.log_message('GMD_API_ERROR',
277: 'PACKAGE' , 'GMD_CUSTOMER_TESTS_GRP',
278: 'ERROR' , substr(sqlerrm,1,100),
279: 'POSITION' , l_progress);
280: