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

Line 63: RAISE FND_API.G_EXC_ERROR;

59: FND_MESSAGE.SET_TOKEN(p_token4_name, p_token4_val);
60: end if;
61: --
62: FND_MSG_PUB.Add;
63: RAISE FND_API.G_EXC_ERROR;
64: end ExitWithErrMsg;
65:
66: PROCEDURE Initialize_Desc_Flex
67: (

Line 73: IF p_desc_flex.context = FND_API.G_MISS_CHAR THEN

69: l_desc_flex OUT NOCOPY DFF_Rec_Type
70: ) IS
71:
72: BEGIN
73: IF p_desc_flex.context = FND_API.G_MISS_CHAR THEN
74: l_desc_flex.context := NULL;
75: ELSE
76: l_desc_flex.context := p_desc_flex.context;
77: END IF;

Line 78: IF p_desc_flex.attribute1 = FND_API.G_MISS_CHAR THEN

74: l_desc_flex.context := NULL;
75: ELSE
76: l_desc_flex.context := p_desc_flex.context;
77: END IF;
78: IF p_desc_flex.attribute1 = FND_API.G_MISS_CHAR THEN
79: l_desc_flex.attribute1 := NULL;
80: ELSE
81: l_desc_flex.attribute1 := p_desc_flex.attribute1;
82: END IF;

Line 83: IF p_desc_flex.attribute2 = FND_API.G_MISS_CHAR THEN

79: l_desc_flex.attribute1 := NULL;
80: ELSE
81: l_desc_flex.attribute1 := p_desc_flex.attribute1;
82: END IF;
83: IF p_desc_flex.attribute2 = FND_API.G_MISS_CHAR THEN
84: l_desc_flex.attribute2 := NULL;
85: ELSE
86: l_desc_flex.attribute2 := p_desc_flex.attribute2;
87: END IF;

Line 88: IF p_desc_flex.attribute3 = FND_API.G_MISS_CHAR THEN

84: l_desc_flex.attribute2 := NULL;
85: ELSE
86: l_desc_flex.attribute2 := p_desc_flex.attribute2;
87: END IF;
88: IF p_desc_flex.attribute3 = FND_API.G_MISS_CHAR THEN
89: l_desc_flex.attribute3 := NULL;
90: ELSE
91: l_desc_flex.attribute3 := p_desc_flex.attribute3;
92: END IF;

Line 93: IF p_desc_flex.attribute4 = FND_API.G_MISS_CHAR THEN

89: l_desc_flex.attribute3 := NULL;
90: ELSE
91: l_desc_flex.attribute3 := p_desc_flex.attribute3;
92: END IF;
93: IF p_desc_flex.attribute4 = FND_API.G_MISS_CHAR THEN
94: l_desc_flex.attribute4 := NULL;
95: ELSE
96: l_desc_flex.attribute4 := p_desc_flex.attribute4;
97: END IF;

Line 98: IF p_desc_flex.attribute5 = FND_API.G_MISS_CHAR THEN

94: l_desc_flex.attribute4 := NULL;
95: ELSE
96: l_desc_flex.attribute4 := p_desc_flex.attribute4;
97: END IF;
98: IF p_desc_flex.attribute5 = FND_API.G_MISS_CHAR THEN
99: l_desc_flex.attribute5 := NULL;
100: ELSE
101: l_desc_flex.attribute5 := p_desc_flex.attribute5;
102: END IF;

Line 103: IF p_desc_flex.attribute6 = FND_API.G_MISS_CHAR THEN

99: l_desc_flex.attribute5 := NULL;
100: ELSE
101: l_desc_flex.attribute5 := p_desc_flex.attribute5;
102: END IF;
103: IF p_desc_flex.attribute6 = FND_API.G_MISS_CHAR THEN
104: l_desc_flex.attribute6 := NULL;
105: ELSE
106: l_desc_flex.attribute6 := p_desc_flex.attribute6;
107: END IF;

Line 108: IF p_desc_flex.attribute7 = FND_API.G_MISS_CHAR THEN

104: l_desc_flex.attribute6 := NULL;
105: ELSE
106: l_desc_flex.attribute6 := p_desc_flex.attribute6;
107: END IF;
108: IF p_desc_flex.attribute7 = FND_API.G_MISS_CHAR THEN
109: l_desc_flex.attribute7 := NULL;
110: ELSE
111: l_desc_flex.attribute7 := p_desc_flex.attribute7;
112: END IF;

Line 113: IF p_desc_flex.attribute8 = FND_API.G_MISS_CHAR THEN

109: l_desc_flex.attribute7 := NULL;
110: ELSE
111: l_desc_flex.attribute7 := p_desc_flex.attribute7;
112: END IF;
113: IF p_desc_flex.attribute8 = FND_API.G_MISS_CHAR THEN
114: l_desc_flex.attribute8 := NULL;
115: ELSE
116: l_desc_flex.attribute8 := p_desc_flex.attribute8;
117: END IF;

Line 118: IF p_desc_flex.attribute9 = FND_API.G_MISS_CHAR THEN

114: l_desc_flex.attribute8 := NULL;
115: ELSE
116: l_desc_flex.attribute8 := p_desc_flex.attribute8;
117: END IF;
118: IF p_desc_flex.attribute9 = FND_API.G_MISS_CHAR THEN
119: l_desc_flex.attribute9 := NULL;
120: ELSE
121: l_desc_flex.attribute9 := p_desc_flex.attribute9;
122: END IF;

Line 123: IF p_desc_flex.attribute10 = FND_API.G_MISS_CHAR THEN

119: l_desc_flex.attribute9 := NULL;
120: ELSE
121: l_desc_flex.attribute9 := p_desc_flex.attribute9;
122: END IF;
123: IF p_desc_flex.attribute10 = FND_API.G_MISS_CHAR THEN
124: l_desc_flex.attribute10 := NULL;
125: ELSE
126: l_desc_flex.attribute10 := p_desc_flex.attribute10;
127: END IF;

Line 128: IF p_desc_flex.attribute11 = FND_API.G_MISS_CHAR THEN

124: l_desc_flex.attribute10 := NULL;
125: ELSE
126: l_desc_flex.attribute10 := p_desc_flex.attribute10;
127: END IF;
128: IF p_desc_flex.attribute11 = FND_API.G_MISS_CHAR THEN
129: l_desc_flex.attribute11 := NULL;
130: ELSE
131: l_desc_flex.attribute11 := p_desc_flex.attribute11;
132: END IF;

Line 133: IF p_desc_flex.attribute12 = FND_API.G_MISS_CHAR THEN

129: l_desc_flex.attribute11 := NULL;
130: ELSE
131: l_desc_flex.attribute11 := p_desc_flex.attribute11;
132: END IF;
133: IF p_desc_flex.attribute12 = FND_API.G_MISS_CHAR THEN
134: l_desc_flex.attribute12 := NULL;
135: ELSE
136: l_desc_flex.attribute12 := p_desc_flex.attribute12;
137: END IF;

Line 138: IF p_desc_flex.attribute13 = FND_API.G_MISS_CHAR THEN

134: l_desc_flex.attribute12 := NULL;
135: ELSE
136: l_desc_flex.attribute12 := p_desc_flex.attribute12;
137: END IF;
138: IF p_desc_flex.attribute13 = FND_API.G_MISS_CHAR THEN
139: l_desc_flex.attribute13 := NULL;
140: ELSE
141: l_desc_flex.attribute13 := p_desc_flex.attribute13;
142: END IF;

Line 143: IF p_desc_flex.attribute14 = FND_API.G_MISS_CHAR THEN

139: l_desc_flex.attribute13 := NULL;
140: ELSE
141: l_desc_flex.attribute13 := p_desc_flex.attribute13;
142: END IF;
143: IF p_desc_flex.attribute14 = FND_API.G_MISS_CHAR THEN
144: l_desc_flex.attribute14 := NULL;
145: ELSE
146: l_desc_flex.attribute14 := p_desc_flex.attribute14;
147: END IF;

Line 148: IF p_desc_flex.attribute15 = FND_API.G_MISS_CHAR THEN

144: l_desc_flex.attribute14 := NULL;
145: ELSE
146: l_desc_flex.attribute14 := p_desc_flex.attribute14;
147: END IF;
148: IF p_desc_flex.attribute15 = FND_API.G_MISS_CHAR THEN
149: l_desc_flex.attribute15 := NULL;
150: ELSE
151: l_desc_flex.attribute15 := p_desc_flex.attribute15;
152: END IF;

Line 168: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

164: --
165: PROCEDURE VALIDATE_FORMULA_CTR
166: (
167: p_api_version IN NUMBER,
168: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
169: p_commit IN VARCHAR2 := FND_API.G_FALSE,
170: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
171: x_return_status OUT NOCOPY VARCHAR2,
172: x_msg_count OUT NOCOPY NUMBER,

Line 169: p_commit IN VARCHAR2 := FND_API.G_FALSE,

165: PROCEDURE VALIDATE_FORMULA_CTR
166: (
167: p_api_version IN NUMBER,
168: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
169: p_commit IN VARCHAR2 := FND_API.G_FALSE,
170: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
171: x_return_status OUT NOCOPY VARCHAR2,
172: x_msg_count OUT NOCOPY NUMBER,
173: x_msg_data OUT NOCOPY VARCHAR2,

Line 170: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,

166: (
167: p_api_version IN NUMBER,
168: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
169: p_commit IN VARCHAR2 := FND_API.G_FALSE,
170: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
171: x_return_status OUT NOCOPY VARCHAR2,
172: x_msg_count OUT NOCOPY NUMBER,
173: x_msg_data OUT NOCOPY VARCHAR2,
174: p_counter_id IN NUMBER,

Line 197: IF NOT FND_API.Compatible_API_Call ( l_api_version,

193: BEGIN
194: -- Standard Start of API savepoint
195: SAVEPOINT CS_COUNTERS_EXT_PVT;
196: -- Standard call to check for call compatibility.
197: IF NOT FND_API.Compatible_API_Call ( l_api_version,
198: p_api_version,
199: l_api_name,
200: G_PKG_NAME)
201: THEN

Line 202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

198: p_api_version,
199: l_api_name,
200: G_PKG_NAME)
201: THEN
202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
203: END IF;
204: -- Initialize message list if p_init_msg_list is set to TRUE.
205: IF FND_API.to_Boolean( p_init_msg_list )
206: THEN

Line 205: IF FND_API.to_Boolean( p_init_msg_list )

201: THEN
202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
203: END IF;
204: -- Initialize message list if p_init_msg_list is set to TRUE.
205: IF FND_API.to_Boolean( p_init_msg_list )
206: THEN
207: FND_MSG_PUB.initialize;
208: END IF;
209: -- Initialize API return status to SUCCESS

Line 210: x_return_status := FND_API.G_RET_STS_SUCCESS;

206: THEN
207: FND_MSG_PUB.initialize;
208: END IF;
209: -- Initialize API return status to SUCCESS
210: x_return_status := FND_API.G_RET_STS_SUCCESS;
211: --
212: -- API body
213: --
214: -- ******************************************************************

Line 217: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

213: --
214: -- ******************************************************************
215: -- Validate Environment
216: -- ******************************************************************
217: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
218: THEN
219: -- Debug message
220: -- Invoke validation procedures
221: null;

Line 224: IF ( P_validation_level > FND_API.G_VALID_LEVEL_NONE)

220: -- Invoke validation procedures
221: null;
222: END IF;
223: --Validate counter group id only when validation level is not none
224: IF ( P_validation_level > FND_API.G_VALID_LEVEL_NONE)
225: THEN
226: null;
227: END IF;
228: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

Line 228: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

224: IF ( P_validation_level > FND_API.G_VALID_LEVEL_NONE)
225: THEN
226: null;
227: END IF;
228: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
229: RAISE FND_API.G_EXC_ERROR;
230: END IF;
231: --Parameter Validations and initialization
232: x_valid_flag := 'N';

Line 229: RAISE FND_API.G_EXC_ERROR;

225: THEN
226: null;
227: END IF;
228: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
229: RAISE FND_API.G_EXC_ERROR;
230: END IF;
231: --Parameter Validations and initialization
232: x_valid_flag := 'N';
233: BEGIN

Line 279: x_return_status := FND_API.G_RET_STS_SUCCESS;

275: x_valid_flag := 'N';
276: end if;
277: END;
278: disp('formula validation done...');
279: x_return_status := FND_API.G_RET_STS_SUCCESS;
280: --
281: -- End of API body
282: --
283: -- Standard check for p_commit

Line 284: IF FND_API.to_Boolean( p_commit )

280: --
281: -- End of API body
282: --
283: -- Standard check for p_commit
284: IF FND_API.to_Boolean( p_commit )
285: THEN
286: COMMIT WORK;
287: END IF;
288: -- Standard call to get message count and if count is 1, get message info.

Line 294: WHEN FND_API.G_EXC_ERROR THEN

290: ( p_count => x_msg_count,
291: p_data => x_msg_data
292: );
293: EXCEPTION
294: WHEN FND_API.G_EXC_ERROR THEN
295: disp('4');
296: ROLLBACK TO CS_COUNTERS_EXT_PVT;
297: x_return_status := FND_API.G_RET_STS_ERROR ;
298: FND_MSG_PUB.Count_And_Get

Line 297: x_return_status := FND_API.G_RET_STS_ERROR ;

293: EXCEPTION
294: WHEN FND_API.G_EXC_ERROR THEN
295: disp('4');
296: ROLLBACK TO CS_COUNTERS_EXT_PVT;
297: x_return_status := FND_API.G_RET_STS_ERROR ;
298: FND_MSG_PUB.Count_And_Get
299: (p_count => x_msg_count,
300: p_data => x_msg_data
301: );

Line 302: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

298: FND_MSG_PUB.Count_And_Get
299: (p_count => x_msg_count,
300: p_data => x_msg_data
301: );
302: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
303: disp('5');
304: ROLLBACK TO CS_COUNTERS_EXT_PVT;
305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
306: FND_MSG_PUB.Count_And_Get

Line 305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

301: );
302: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
303: disp('5');
304: ROLLBACK TO CS_COUNTERS_EXT_PVT;
305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
306: FND_MSG_PUB.Count_And_Get
307: (
308: p_count => x_msg_count,
309: p_data => x_msg_data

Line 314: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

310: );
311: WHEN OTHERS THEN
312: disp('6'||sqlerrm);
313: ROLLBACK TO CS_COUNTERS_EXT_PVT;
314: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
315: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
316: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
317: END IF;
318: FND_MSG_PUB.Count_And_Get

Line 327: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

323:
324: PROCEDURE VALIDATE_GRPOP_CTR
325: (
326: p_api_version IN NUMBER,
327: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
328: p_commit IN VARCHAR2 := FND_API.G_FALSE,
329: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
330: x_return_status OUT NOCOPY VARCHAR2,
331: x_msg_count OUT NOCOPY NUMBER,

Line 328: p_commit IN VARCHAR2 := FND_API.G_FALSE,

324: PROCEDURE VALIDATE_GRPOP_CTR
325: (
326: p_api_version IN NUMBER,
327: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
328: p_commit IN VARCHAR2 := FND_API.G_FALSE,
329: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
330: x_return_status OUT NOCOPY VARCHAR2,
331: x_msg_count OUT NOCOPY NUMBER,
332: x_msg_data OUT NOCOPY VARCHAR2,

Line 329: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,

325: (
326: p_api_version IN NUMBER,
327: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
328: p_commit IN VARCHAR2 := FND_API.G_FALSE,
329: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
330: x_return_status OUT NOCOPY VARCHAR2,
331: x_msg_count OUT NOCOPY NUMBER,
332: x_msg_data OUT NOCOPY VARCHAR2,
333: p_counter_id IN NUMBER,

Line 385: IF NOT FND_API.Compatible_API_Call ( l_api_version,

381: BEGIN
382: -- Standard Start of API savepoint
383: SAVEPOINT CS_COUNTERS_EXT_PVT;
384: -- Standard call to check for call compatibility.
385: IF NOT FND_API.Compatible_API_Call ( l_api_version,
386: p_api_version,
387: l_api_name,
388: G_PKG_NAME)
389: THEN

Line 390: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

386: p_api_version,
387: l_api_name,
388: G_PKG_NAME)
389: THEN
390: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
391: END IF;
392: -- Initialize message list if p_init_msg_list is set to TRUE.
393: IF FND_API.to_Boolean( p_init_msg_list )
394: THEN

Line 393: IF FND_API.to_Boolean( p_init_msg_list )

389: THEN
390: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
391: END IF;
392: -- Initialize message list if p_init_msg_list is set to TRUE.
393: IF FND_API.to_Boolean( p_init_msg_list )
394: THEN
395: FND_MSG_PUB.initialize;
396: END IF;
397: -- Initialize API return status to SUCCESS

Line 398: x_return_status := FND_API.G_RET_STS_SUCCESS;

394: THEN
395: FND_MSG_PUB.initialize;
396: END IF;
397: -- Initialize API return status to SUCCESS
398: x_return_status := FND_API.G_RET_STS_SUCCESS;
399: --
400: -- API body
401: --
402: -- ******************************************************************

Line 406: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

402: -- ******************************************************************
403: -- Validate Environment
404: -- ******************************************************************
405: disp('1');
406: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
407: THEN
408: -- Debug message
409: -- Invoke validation procedures
410: null;

Line 414: IF ( P_validation_level > FND_API.G_VALID_LEVEL_NONE)

410: null;
411: END IF;
412: disp('12');
413: --Validate counter group id only when validation level is not none
414: IF ( P_validation_level > FND_API.G_VALID_LEVEL_NONE)
415: THEN
416: null;
417: END IF;
418: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

Line 418: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

414: IF ( P_validation_level > FND_API.G_VALID_LEVEL_NONE)
415: THEN
416: null;
417: END IF;
418: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
419: RAISE FND_API.G_EXC_ERROR;
420: END IF;
421: --Parameter Validations and initialization
422: x_valid_flag := 'N';

Line 419: RAISE FND_API.G_EXC_ERROR;

415: THEN
416: null;
417: END IF;
418: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
419: RAISE FND_API.G_EXC_ERROR;
420: END IF;
421: --Parameter Validations and initialization
422: x_valid_flag := 'N';
423: disp('2');

Line 528: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

524: END IF;
525: RAISE;
526: END;
527:
528: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
529: RAISE FND_API.G_EXC_ERROR;
530: END IF;
531: --
532: -- End of API body

Line 529: RAISE FND_API.G_EXC_ERROR;

525: RAISE;
526: END;
527:
528: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
529: RAISE FND_API.G_EXC_ERROR;
530: END IF;
531: --
532: -- End of API body
533: --

Line 535: IF FND_API.to_Boolean( p_commit )

531: --
532: -- End of API body
533: --
534: -- Standard check for p_commit
535: IF FND_API.to_Boolean( p_commit )
536: THEN
537: COMMIT WORK;
538: END IF;
539: -- Standard call to get message count and if count is 1, get message info.

Line 545: WHEN FND_API.G_EXC_ERROR THEN

541: ( p_count => x_msg_count,
542: p_data => x_msg_data
543: );
544: EXCEPTION
545: WHEN FND_API.G_EXC_ERROR THEN
546: disp('4');
547: ROLLBACK TO CS_COUNTERS_EXT_PVT;
548: x_return_status := FND_API.G_RET_STS_ERROR ;
549: FND_MSG_PUB.Count_And_Get

Line 548: x_return_status := FND_API.G_RET_STS_ERROR ;

544: EXCEPTION
545: WHEN FND_API.G_EXC_ERROR THEN
546: disp('4');
547: ROLLBACK TO CS_COUNTERS_EXT_PVT;
548: x_return_status := FND_API.G_RET_STS_ERROR ;
549: FND_MSG_PUB.Count_And_Get
550: (p_count => x_msg_count,
551: p_data => x_msg_data
552: );

Line 553: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

549: FND_MSG_PUB.Count_And_Get
550: (p_count => x_msg_count,
551: p_data => x_msg_data
552: );
553: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
554: disp('5');
555: ROLLBACK TO CS_COUNTERS_EXT_PVT;
556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
557: FND_MSG_PUB.Count_And_Get

Line 556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

552: );
553: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
554: disp('5');
555: ROLLBACK TO CS_COUNTERS_EXT_PVT;
556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
557: FND_MSG_PUB.Count_And_Get
558: (
559: p_count => x_msg_count,
560: p_data => x_msg_data

Line 565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

561: );
562: WHEN OTHERS THEN
563: disp('6'||sqlerrm);
564: ROLLBACK TO CS_COUNTERS_EXT_PVT;
565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
566: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
567: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
568: END IF;
569: FND_MSG_PUB.Count_And_Get

Line 582: IF (NVL(p_var1,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM) THEN

578: p_param_name IN VARCHAR2,
579: p_api_name IN VARCHAR2
580: ) IS
581: BEGIN
582: IF (NVL(p_var1,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM) THEN
583: FND_MESSAGE.SET_NAME('CS','CS_API_ALL_MISSING_PARAM');
584: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
585: FND_MESSAGE.SET_TOKEN('MISSING_PARAM',p_param_name);
586: FND_MSG_PUB.Add;

Line 587: RAISE FND_API.G_EXC_ERROR;

583: FND_MESSAGE.SET_NAME('CS','CS_API_ALL_MISSING_PARAM');
584: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
585: FND_MESSAGE.SET_TOKEN('MISSING_PARAM',p_param_name);
586: FND_MSG_PUB.Add;
587: RAISE FND_API.G_EXC_ERROR;
588: END IF;
589: END Check_Reqd_Param;
590:
591:

Line 599: IF (NVL(p_var1,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR) THEN

595: p_param_name IN VARCHAR2,
596: p_api_name IN VARCHAR2
597: ) IS
598: BEGIN
599: IF (NVL(p_var1,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR) THEN
600: FND_MESSAGE.SET_NAME('CS','CS_API_ALL_MISSING_PARAM');
601: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
602: FND_MESSAGE.SET_TOKEN('MISSING_PARAM',p_param_name);
603: FND_MSG_PUB.Add;

Line 604: RAISE FND_API.G_EXC_ERROR;

600: FND_MESSAGE.SET_NAME('CS','CS_API_ALL_MISSING_PARAM');
601: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
602: FND_MESSAGE.SET_TOKEN('MISSING_PARAM',p_param_name);
603: FND_MSG_PUB.Add;
604: RAISE FND_API.G_EXC_ERROR;
605: END IF;
606: END Check_Reqd_Param;
607:
608:

Line 616: IF (NVL(p_var1,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE) THEN

612: p_param_name IN VARCHAR2,
613: p_api_name IN VARCHAR2
614: ) IS
615: BEGIN
616: IF (NVL(p_var1,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE) THEN
617: FND_MESSAGE.SET_NAME('CS','CS_API_ALL_MISSING_PARAM');
618: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
619: FND_MESSAGE.SET_TOKEN('MISSING_PARAM',p_param_name);
620: FND_MSG_PUB.Add;

Line 621: RAISE FND_API.G_EXC_ERROR;

617: FND_MESSAGE.SET_NAME('CS','CS_API_ALL_MISSING_PARAM');
618: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
619: FND_MESSAGE.SET_TOKEN('MISSING_PARAM',p_param_name);
620: FND_MSG_PUB.Add;
621: RAISE FND_API.G_EXC_ERROR;
622: END IF;
623: END Check_Reqd_Param;
624:
625: FUNCTION Is_StartEndDate_Valid

Line 720: RAISE FND_API.G_EXC_ERROR;

716: /* More than 15 attributes not currently supported. Please contact developer. */
717: FND_MESSAGE.SET_NAME('CS','CS_API_NUM_OF_DESCFLEX_GT_MAX');
718: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
719: FND_MSG_PUB.Add;
720: RAISE FND_API.G_EXC_ERROR;
721: END IF;
722:
723: Validate_Desc_Flex
724: (

Line 763: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

759: l_resp_appl_id,
760: l_resp_id,
761: l_return_status );
762:
763: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
764: RAISE FND_API.G_EXC_ERROR;
765: end if;
766: END Is_DescFlex_Valid;
767:

Line 764: RAISE FND_API.G_EXC_ERROR;

760: l_resp_id,
761: l_return_status );
762:
763: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
764: RAISE FND_API.G_EXC_ERROR;
765: end if;
766: END Is_DescFlex_Valid;
767:
768: ------------------------------------------------------------------------------

Line 813: x_return_status := fnd_api.g_ret_sts_success;

809: x_return_status OUT NOCOPY VARCHAR2 )
810: IS
811: l_error_message VARCHAR2(2000);
812: BEGIN
813: x_return_status := fnd_api.g_ret_sts_success;
814:
815: fnd_flex_descval.set_column_value(p_column_name1, p_column_value1);
816: fnd_flex_descval.set_column_value(p_column_name2, p_column_value2);
817: fnd_flex_descval.set_column_value(p_column_name3, p_column_value3);

Line 838: x_return_status := fnd_api.g_ret_sts_error;

834: resp_appl_id => p_resp_appl_id,
835: resp_id => p_resp_id ) THEN
836: l_error_message := fnd_flex_descval.error_message;
837: add_desc_flex_msg(p_api_name, l_error_message);
838: x_return_status := fnd_api.g_ret_sts_error;
839: END IF;
840: END Validate_Desc_Flex;
841:
842: END CS_COUNTERS_EXT_PVT;