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

Line 16: -- Default = FND_API.G_FALSE

12: -- Pre-reqs : None.
13: -- Parameters :
14: -- IN : p_api_version IN NUMBER Required
15: -- p_init_msg_list IN VARCHAR2 Optional
16: -- Default = FND_API.G_FALSE
17: -- p_commit IN VARCHAR2 Optional
18: -- Default = FND_API.G_FALSE
19: -- p_validation_level IN NUMBER Optional
20: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 18: -- Default = FND_API.G_FALSE

14: -- IN : p_api_version IN NUMBER Required
15: -- p_init_msg_list IN VARCHAR2 Optional
16: -- Default = FND_API.G_FALSE
17: -- p_commit IN VARCHAR2 Optional
18: -- Default = FND_API.G_FALSE
19: -- p_validation_level IN NUMBER Optional
20: -- Default = FND_API.G_VALID_LEVEL_FULL
21: -- OUT : p_sf_repositories_rec OUT cn_sf_repositories_rec_type
22: -- x_return_status OUT VARCHAR2(1)

Line 20: -- Default = FND_API.G_VALID_LEVEL_FULL

16: -- Default = FND_API.G_FALSE
17: -- p_commit IN VARCHAR2 Optional
18: -- Default = FND_API.G_FALSE
19: -- p_validation_level IN NUMBER Optional
20: -- Default = FND_API.G_VALID_LEVEL_FULL
21: -- OUT : p_sf_repositories_rec OUT cn_sf_repositories_rec_type
22: -- x_return_status OUT VARCHAR2(1)
23: -- x_msg_count OUT NUMBER
24: -- x_msg_data OUT VARCHAR2(2000)

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

34:
35: PROCEDURE Get_SF_Parameters
36: (
37: p_api_version IN NUMBER,
38: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
39: p_commit IN VARCHAR2 := FND_API.G_FALSE,
40: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
41: p_sf_param_rec OUT NOCOPY cn_sf_repositories_rec_type,
42: x_return_status OUT NOCOPY VARCHAR2,

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

35: PROCEDURE Get_SF_Parameters
36: (
37: p_api_version IN NUMBER,
38: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
39: p_commit IN VARCHAR2 := FND_API.G_FALSE,
40: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
41: p_sf_param_rec OUT NOCOPY cn_sf_repositories_rec_type,
42: x_return_status OUT NOCOPY VARCHAR2,
43: x_msg_count OUT NOCOPY NUMBER,

Line 40: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

36: (
37: p_api_version IN NUMBER,
38: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
39: p_commit IN VARCHAR2 := FND_API.G_FALSE,
40: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
41: p_sf_param_rec OUT NOCOPY cn_sf_repositories_rec_type,
42: x_return_status OUT NOCOPY VARCHAR2,
43: x_msg_count OUT NOCOPY NUMBER,
44: x_msg_data OUT NOCOPY VARCHAR2

Line 62: IF NOT FND_API.compatible_api_call

58: -- start of the API savepoint
59: SAVEPOINT Get_SF_Parameters_svp ;
60:
61: -- Standard call to check for call compatibility.
62: IF NOT FND_API.compatible_api_call
63: ( l_api_version ,p_api_version ,l_api_name ,G_PKG_NAME )
64: THEN
65: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
66: END IF;

Line 65: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

61: -- Standard call to check for call compatibility.
62: IF NOT FND_API.compatible_api_call
63: ( l_api_version ,p_api_version ,l_api_name ,G_PKG_NAME )
64: THEN
65: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
66: END IF;
67:
68: -- Initialize message list if p_init_msg_list is set to TRUE.
69: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 69: IF FND_API.to_Boolean( p_init_msg_list ) THEN

65: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
66: END IF;
67:
68: -- Initialize message list if p_init_msg_list is set to TRUE.
69: IF FND_API.to_Boolean( p_init_msg_list ) THEN
70: FND_MSG_PUB.initialize;
71: END IF;
72:
73: -- Initialize API return status to success

Line 74: x_return_status := FND_API.G_RET_STS_SUCCESS;

70: FND_MSG_PUB.initialize;
71: END IF;
72:
73: -- Initialize API return status to success
74: x_return_status := FND_API.G_RET_STS_SUCCESS;
75: l_validation_status := 'INVALID';
76:
77: -- BEGINING OF API BODY ----
78:

Line 102: IF FND_API.To_Boolean( p_commit ) THEN

98: << end_Get_SF_Parameters >>
99: NULL;
100:
101: -- Standard check of p_commit.
102: IF FND_API.To_Boolean( p_commit ) THEN
103: COMMIT WORK;
104: END IF;
105:
106: -- Standard call to get message count and if count is 1, get message info.

Line 111: p_encoded => FND_API.G_FALSE

107: FND_MSG_PUB.Count_And_Get
108: (
109: p_count => x_msg_count ,
110: p_data => x_msg_data ,
111: p_encoded => FND_API.G_FALSE
112: );
113:
114: EXCEPTION
115: WHEN FND_API.G_EXC_ERROR THEN

Line 115: WHEN FND_API.G_EXC_ERROR THEN

111: p_encoded => FND_API.G_FALSE
112: );
113:
114: EXCEPTION
115: WHEN FND_API.G_EXC_ERROR THEN
116: ROLLBACK TO Get_SF_Parameters_svp ;
117: x_return_status := FND_API.G_RET_STS_ERROR ;
118: FND_MSG_PUB.Count_And_Get
119: (

Line 117: x_return_status := FND_API.G_RET_STS_ERROR ;

113:
114: EXCEPTION
115: WHEN FND_API.G_EXC_ERROR THEN
116: ROLLBACK TO Get_SF_Parameters_svp ;
117: x_return_status := FND_API.G_RET_STS_ERROR ;
118: FND_MSG_PUB.Count_And_Get
119: (
120: p_count => x_msg_count ,
121: p_data => x_msg_data ,

Line 122: p_encoded => FND_API.G_FALSE

118: FND_MSG_PUB.Count_And_Get
119: (
120: p_count => x_msg_count ,
121: p_data => x_msg_data ,
122: p_encoded => FND_API.G_FALSE
123: );
124:
125: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
126: ROLLBACK TO Get_SF_Parameters_svp ;

Line 125: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

121: p_data => x_msg_data ,
122: p_encoded => FND_API.G_FALSE
123: );
124:
125: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
126: ROLLBACK TO Get_SF_Parameters_svp ;
127: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
128: FND_MSG_PUB.Count_And_Get
129: (

Line 127: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

123: );
124:
125: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
126: ROLLBACK TO Get_SF_Parameters_svp ;
127: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
128: FND_MSG_PUB.Count_And_Get
129: (
130: p_count => x_msg_count ,
131: p_data => x_msg_data ,

Line 132: p_encoded => FND_API.G_FALSE

128: FND_MSG_PUB.Count_And_Get
129: (
130: p_count => x_msg_count ,
131: p_data => x_msg_data ,
132: p_encoded => FND_API.G_FALSE
133: );
134:
135: WHEN OTHERS THEN
136: ROLLBACK TO Get_SF_Parameters_svp ;

Line 137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

133: );
134:
135: WHEN OTHERS THEN
136: ROLLBACK TO Get_SF_Parameters_svp ;
137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
138: l_error_code := SQLCODE;
139: IF l_error_code = -54 THEN
140: x_return_status := FND_API.G_RET_STS_ERROR ;
141: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

Line 140: x_return_status := FND_API.G_RET_STS_ERROR ;

136: ROLLBACK TO Get_SF_Parameters_svp ;
137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
138: l_error_code := SQLCODE;
139: IF l_error_code = -54 THEN
140: x_return_status := FND_API.G_RET_STS_ERROR ;
141: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
142: THEN
143: FND_MESSAGE.SET_NAME ('CN' , 'CN_LOCK_FAIL');
144: FND_MSG_PUB.Add;

Line 156: p_encoded => FND_API.G_FALSE

152: FND_MSG_PUB.Count_And_Get
153: (
154: p_count => x_msg_count ,
155: p_data => x_msg_data ,
156: p_encoded => FND_API.G_FALSE
157: );
158:
159: END Get_SF_Parameters ;
160:

Line 171: -- Default = FND_API.G_FALSE

167: -- Pre-reqs : None.
168: -- Parameters :
169: -- IN : p_api_version IN NUMBER Required
170: -- p_init_msg_list IN VARCHAR2 Optional
171: -- Default = FND_API.G_FALSE
172: -- p_commit IN VARCHAR2 Optional
173: -- Default = FND_API.G_FALSE
174: -- p_validation_level IN NUMBER Optional
175: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 173: -- Default = FND_API.G_FALSE

169: -- IN : p_api_version IN NUMBER Required
170: -- p_init_msg_list IN VARCHAR2 Optional
171: -- Default = FND_API.G_FALSE
172: -- p_commit IN VARCHAR2 Optional
173: -- Default = FND_API.G_FALSE
174: -- p_validation_level IN NUMBER Optional
175: -- Default = FND_API.G_VALID_LEVEL_FULL
176: -- p_seasonalities_rec_type IN seasonalities_rec_type
177: -- OUT : x_return_status OUT VARCHAR2(1)

Line 175: -- Default = FND_API.G_VALID_LEVEL_FULL

171: -- Default = FND_API.G_FALSE
172: -- p_commit IN VARCHAR2 Optional
173: -- Default = FND_API.G_FALSE
174: -- p_validation_level IN NUMBER Optional
175: -- Default = FND_API.G_VALID_LEVEL_FULL
176: -- p_seasonalities_rec_type IN seasonalities_rec_type
177: -- OUT : x_return_status OUT VARCHAR2(1)
178: -- x_msg_count OUT NUMBER
179: -- x_msg_data OUT VARCHAR2(2000)

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

190:
191: PROCEDURE Update_SF_Parameters
192: (
193: p_api_version IN NUMBER,
194: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
195: p_commit IN VARCHAR2 := FND_API.G_FALSE,
196: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
197: p_sf_repositories_rec IN cn_sf_repositories_rec_type,
198: x_return_status OUT NOCOPY VARCHAR2,

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

191: PROCEDURE Update_SF_Parameters
192: (
193: p_api_version IN NUMBER,
194: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
195: p_commit IN VARCHAR2 := FND_API.G_FALSE,
196: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
197: p_sf_repositories_rec IN cn_sf_repositories_rec_type,
198: x_return_status OUT NOCOPY VARCHAR2,
199: x_msg_count OUT NOCOPY NUMBER,

Line 196: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

192: (
193: p_api_version IN NUMBER,
194: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
195: p_commit IN VARCHAR2 := FND_API.G_FALSE,
196: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
197: p_sf_repositories_rec IN cn_sf_repositories_rec_type,
198: x_return_status OUT NOCOPY VARCHAR2,
199: x_msg_count OUT NOCOPY NUMBER,
200: x_msg_data OUT NOCOPY VARCHAR2

Line 220: IF NOT FND_API.compatible_api_call

216: -- start of the API savepoint
217: SAVEPOINT Update_SF_Parameters_svp ;
218:
219: -- Standard call to check for call compatibility.
220: IF NOT FND_API.compatible_api_call
221: ( l_api_version ,p_api_version ,l_api_name ,G_PKG_NAME )
222: THEN
223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
224: END IF;

Line 223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

219: -- Standard call to check for call compatibility.
220: IF NOT FND_API.compatible_api_call
221: ( l_api_version ,p_api_version ,l_api_name ,G_PKG_NAME )
222: THEN
223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
224: END IF;
225:
226: -- Initialize message list if p_init_msg_list is set to TRUE.
227: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 227: IF FND_API.to_Boolean( p_init_msg_list ) THEN

223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
224: END IF;
225:
226: -- Initialize message list if p_init_msg_list is set to TRUE.
227: IF FND_API.to_Boolean( p_init_msg_list ) THEN
228: FND_MSG_PUB.initialize;
229: END IF;
230:
231: -- Initialize API return status to success

Line 232: x_return_status := FND_API.G_RET_STS_SUCCESS;

228: FND_MSG_PUB.initialize;
229: END IF;
230:
231: -- Initialize API return status to success
232: x_return_status := FND_API.G_RET_STS_SUCCESS;
233: l_validation_status := 'INVALID';
234: /*
235: SELECT Count(*)
236: INTO l_count

Line 242: RAISE fnd_api.g_exc_error ;

238:
239: IF l_count > 0 THEN
240: FND_MESSAGE.SET_NAME ('CN' , 'CN_RECORD_CHANGED');
241: FND_MSG_PUB.Add;
242: RAISE fnd_api.g_exc_error ;
243: END IF;
244: */
245: -- BEGINING OF API BODY ----
246:

Line 274: IF FND_API.To_Boolean( p_commit ) THEN

270: << end_Update_SF_Parameters >>
271: NULL;
272:
273: -- Standard check of p_commit.
274: IF FND_API.To_Boolean( p_commit ) THEN
275: COMMIT WORK;
276: END IF;
277:
278: -- Standard call to get message count and if count is 1, get message info.

Line 283: p_encoded => FND_API.G_FALSE

279: FND_MSG_PUB.Count_And_Get
280: (
281: p_count => x_msg_count ,
282: p_data => x_msg_data ,
283: p_encoded => FND_API.G_FALSE
284: );
285:
286: EXCEPTION
287: WHEN FND_API.G_EXC_ERROR THEN

Line 287: WHEN FND_API.G_EXC_ERROR THEN

283: p_encoded => FND_API.G_FALSE
284: );
285:
286: EXCEPTION
287: WHEN FND_API.G_EXC_ERROR THEN
288: ROLLBACK TO Update_SF_Parameters_svp ;
289: x_return_status := FND_API.G_RET_STS_ERROR ;
290: FND_MSG_PUB.Count_And_Get
291: (

Line 289: x_return_status := FND_API.G_RET_STS_ERROR ;

285:
286: EXCEPTION
287: WHEN FND_API.G_EXC_ERROR THEN
288: ROLLBACK TO Update_SF_Parameters_svp ;
289: x_return_status := FND_API.G_RET_STS_ERROR ;
290: FND_MSG_PUB.Count_And_Get
291: (
292: p_count => x_msg_count ,
293: p_data => x_msg_data ,

Line 294: p_encoded => FND_API.G_FALSE

290: FND_MSG_PUB.Count_And_Get
291: (
292: p_count => x_msg_count ,
293: p_data => x_msg_data ,
294: p_encoded => FND_API.G_FALSE
295: );
296:
297: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
298: ROLLBACK TO Update_SF_Parameters_svp ;

Line 297: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

293: p_data => x_msg_data ,
294: p_encoded => FND_API.G_FALSE
295: );
296:
297: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
298: ROLLBACK TO Update_SF_Parameters_svp ;
299: --DBMS_OUTPUT.PUT_LINE('Update Error : Unexpected ');
300: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
301: FND_MSG_PUB.Count_And_Get

Line 300: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

296:
297: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
298: ROLLBACK TO Update_SF_Parameters_svp ;
299: --DBMS_OUTPUT.PUT_LINE('Update Error : Unexpected ');
300: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
301: FND_MSG_PUB.Count_And_Get
302: (
303: p_count => x_msg_count ,
304: p_data => x_msg_data ,

Line 305: p_encoded => FND_API.G_FALSE

301: FND_MSG_PUB.Count_And_Get
302: (
303: p_count => x_msg_count ,
304: p_data => x_msg_data ,
305: p_encoded => FND_API.G_FALSE
306: );
307:
308: WHEN OTHERS THEN
309: ROLLBACK TO Update_SF_Parameters_svp ;

Line 311: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

307:
308: WHEN OTHERS THEN
309: ROLLBACK TO Update_SF_Parameters_svp ;
310: --DBMS_OUTPUT.PUT_LINE('Update Error : Unexpected Others.');
311: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
312:
313: l_error_code := SQLCODE;
314: IF l_error_code = -54 THEN
315: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 315: x_return_status := FND_API.G_RET_STS_ERROR ;

311: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
312:
313: l_error_code := SQLCODE;
314: IF l_error_code = -54 THEN
315: x_return_status := FND_API.G_RET_STS_ERROR ;
316: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
317: THEN
318: FND_MESSAGE.SET_NAME ('CN' , 'CN_LOCK_FAIL');
319: FND_MSG_PUB.Add;

Line 331: p_encoded => FND_API.G_FALSE

327: FND_MSG_PUB.Count_And_Get
328: (
329: p_count => x_msg_count ,
330: p_data => x_msg_data ,
331: p_encoded => FND_API.G_FALSE
332: );
333:
334: END Update_SF_Parameters ;
335:

Line 350: -- Default = FND_API.G_FALSE

346: -- Pre-reqs : None.
347: -- Parameters :
348: -- IN : p_api_version IN NUMBER Required
349: -- p_init_msg_list IN VARCHAR2 Optional
350: -- Default = FND_API.G_FALSE
351: -- p_commit IN VARCHAR2 Optional
352: -- Default = FND_API.G_FALSE
353: -- p_validation_level IN NUMBER Optional
354: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 352: -- Default = FND_API.G_FALSE

348: -- IN : p_api_version IN NUMBER Required
349: -- p_init_msg_list IN VARCHAR2 Optional
350: -- Default = FND_API.G_FALSE
351: -- p_commit IN VARCHAR2 Optional
352: -- Default = FND_API.G_FALSE
353: -- p_validation_level IN NUMBER Optional
354: -- Default = FND_API.G_VALID_LEVEL_FULL
355: -- p_sf_repositories_rec IN cn_sf_repositories_rec_type
356: -- OUT : x_return_status OUT VARCHAR2(1)

Line 354: -- Default = FND_API.G_VALID_LEVEL_FULL

350: -- Default = FND_API.G_FALSE
351: -- p_commit IN VARCHAR2 Optional
352: -- Default = FND_API.G_FALSE
353: -- p_validation_level IN NUMBER Optional
354: -- Default = FND_API.G_VALID_LEVEL_FULL
355: -- p_sf_repositories_rec IN cn_sf_repositories_rec_type
356: -- OUT : x_return_status OUT VARCHAR2(1)
357: -- x_msg_count OUT NUMBER
358: -- x_msg_data OUT VARCHAR2(2000)

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

368:
369: PROCEDURE Insert_SF_Parameters
370: (
371: p_api_version IN NUMBER,
372: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
373: p_commit IN VARCHAR2 := FND_API.G_FALSE,
374: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
375: p_sf_repositories_rec IN cn_sf_repositories_rec_type,
376: x_return_status OUT NOCOPY VARCHAR2,

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

369: PROCEDURE Insert_SF_Parameters
370: (
371: p_api_version IN NUMBER,
372: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
373: p_commit IN VARCHAR2 := FND_API.G_FALSE,
374: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
375: p_sf_repositories_rec IN cn_sf_repositories_rec_type,
376: x_return_status OUT NOCOPY VARCHAR2,
377: x_msg_count OUT NOCOPY NUMBER,

Line 374: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

370: (
371: p_api_version IN NUMBER,
372: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
373: p_commit IN VARCHAR2 := FND_API.G_FALSE,
374: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
375: p_sf_repositories_rec IN cn_sf_repositories_rec_type,
376: x_return_status OUT NOCOPY VARCHAR2,
377: x_msg_count OUT NOCOPY NUMBER,
378: x_msg_data OUT NOCOPY VARCHAR2

Line 396: IF NOT FND_API.compatible_api_call

392: -- start of the API savepoint
393: SAVEPOINT Insert_SF_Parameters_svp ;
394:
395: -- Standard call to check for call compatibility.
396: IF NOT FND_API.compatible_api_call
397: ( l_api_version ,p_api_version ,l_api_name ,G_PKG_NAME )
398: THEN
399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
400: END IF;

Line 399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

395: -- Standard call to check for call compatibility.
396: IF NOT FND_API.compatible_api_call
397: ( l_api_version ,p_api_version ,l_api_name ,G_PKG_NAME )
398: THEN
399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
400: END IF;
401:
402: -- Initialize message list if p_init_msg_list is set to TRUE.
403: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 403: IF FND_API.to_Boolean( p_init_msg_list ) THEN

399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
400: END IF;
401:
402: -- Initialize message list if p_init_msg_list is set to TRUE.
403: IF FND_API.to_Boolean( p_init_msg_list ) THEN
404: FND_MSG_PUB.initialize;
405: END IF;
406:
407: -- Initialize API return status to success

Line 408: x_return_status := FND_API.G_RET_STS_SUCCESS;

404: FND_MSG_PUB.initialize;
405: END IF;
406:
407: -- Initialize API return status to success
408: x_return_status := FND_API.G_RET_STS_SUCCESS;
409: l_validation_status := 'INVALID';
410:
411: -- BEGINING OF API BODY ----
412:

Line 422: RAISE fnd_api.g_exc_error ;

418:
419: IF l_count > 0 THEN
420: FND_MESSAGE.SET_NAME ('CN' , 'CN_SF_RECORD_EXISTS');
421: FND_MSG_PUB.Add;
422: RAISE fnd_api.g_exc_error ;
423: END IF;
424:
425:
426: -- End of validation code -----

Line 449: IF FND_API.To_Boolean( p_commit ) THEN

445: << end_Insert_SF_Parameters >>
446: NULL;
447:
448: -- Standard check of p_commit.
449: IF FND_API.To_Boolean( p_commit ) THEN
450: COMMIT WORK;
451: END IF;
452:
453: -- Standard call to get message count and if count is 1, get message info.

Line 458: p_encoded => FND_API.G_FALSE

454: FND_MSG_PUB.Count_And_Get
455: (
456: p_count => x_msg_count ,
457: p_data => x_msg_data ,
458: p_encoded => FND_API.G_FALSE
459: );
460:
461: EXCEPTION
462: WHEN FND_API.G_EXC_ERROR THEN

Line 462: WHEN FND_API.G_EXC_ERROR THEN

458: p_encoded => FND_API.G_FALSE
459: );
460:
461: EXCEPTION
462: WHEN FND_API.G_EXC_ERROR THEN
463: ROLLBACK TO Insert_SF_Parameters_svp ;
464: x_return_status := FND_API.G_RET_STS_ERROR ;
465: FND_MSG_PUB.Count_And_Get
466: (

Line 464: x_return_status := FND_API.G_RET_STS_ERROR ;

460:
461: EXCEPTION
462: WHEN FND_API.G_EXC_ERROR THEN
463: ROLLBACK TO Insert_SF_Parameters_svp ;
464: x_return_status := FND_API.G_RET_STS_ERROR ;
465: FND_MSG_PUB.Count_And_Get
466: (
467: p_count => x_msg_count ,
468: p_data => x_msg_data ,

Line 469: p_encoded => FND_API.G_FALSE

465: FND_MSG_PUB.Count_And_Get
466: (
467: p_count => x_msg_count ,
468: p_data => x_msg_data ,
469: p_encoded => FND_API.G_FALSE
470: );
471:
472: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
473: ROLLBACK TO Insert_SF_Parameters_svp ;

Line 472: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

468: p_data => x_msg_data ,
469: p_encoded => FND_API.G_FALSE
470: );
471:
472: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
473: ROLLBACK TO Insert_SF_Parameters_svp ;
474: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
475: FND_MSG_PUB.Count_And_Get
476: (

Line 474: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

470: );
471:
472: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
473: ROLLBACK TO Insert_SF_Parameters_svp ;
474: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
475: FND_MSG_PUB.Count_And_Get
476: (
477: p_count => x_msg_count ,
478: p_data => x_msg_data ,

Line 479: p_encoded => FND_API.G_FALSE

475: FND_MSG_PUB.Count_And_Get
476: (
477: p_count => x_msg_count ,
478: p_data => x_msg_data ,
479: p_encoded => FND_API.G_FALSE
480: );
481:
482: WHEN OTHERS THEN
483: ROLLBACK TO Insert_SF_Parameters_svp ;

Line 484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

480: );
481:
482: WHEN OTHERS THEN
483: ROLLBACK TO Insert_SF_Parameters_svp ;
484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
485: l_error_code := SQLCODE;
486: IF l_error_code = -54 THEN
487: x_return_status := FND_API.G_RET_STS_ERROR ;
488: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

Line 487: x_return_status := FND_API.G_RET_STS_ERROR ;

483: ROLLBACK TO Insert_SF_Parameters_svp ;
484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
485: l_error_code := SQLCODE;
486: IF l_error_code = -54 THEN
487: x_return_status := FND_API.G_RET_STS_ERROR ;
488: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
489: THEN
490: FND_MESSAGE.SET_NAME ('CN' , 'CN_LOCK_FAIL');
491: FND_MSG_PUB.Add;

Line 503: p_encoded => FND_API.G_FALSE

499: FND_MSG_PUB.Count_And_Get
500: (
501: p_count => x_msg_count ,
502: p_data => x_msg_data ,
503: p_encoded => FND_API.G_FALSE
504: );
505:
506: END Insert_SF_Parameters ;
507: