DBA Data[Home] [Help]

APPS.CS_SR_CUST_CONT_MAINT_PVT dependencies on FND_API

Line 7: -- Local Function. Returns the Value of the Constant FND_API.G_MISS_NUM

3:
4: -- Constants used as tokens for unexpected error messages.
5: G_PVT_NAME CONSTANT VARCHAR2(25):= 'CS_SR_CUST_CONT_MAINT_PKG';
6:
7: -- Local Function. Returns the Value of the Constant FND_API.G_MISS_NUM
8: FUNCTION G_MISS_NUM RETURN NUMBER IS
9: BEGIN
10: RETURN FND_API.G_MISS_NUM ;
11: END G_MISS_NUM ;

Line 10: RETURN FND_API.G_MISS_NUM ;

6:
7: -- Local Function. Returns the Value of the Constant FND_API.G_MISS_NUM
8: FUNCTION G_MISS_NUM RETURN NUMBER IS
9: BEGIN
10: RETURN FND_API.G_MISS_NUM ;
11: END G_MISS_NUM ;
12:
13: -- Local Function. Returns the Value of the Constant FND_API.G_MISS_CHAR to the caller
14: FUNCTION G_MISS_CHAR RETURN VARCHAR2 IS

Line 13: -- Local Function. Returns the Value of the Constant FND_API.G_MISS_CHAR to the caller

9: BEGIN
10: RETURN FND_API.G_MISS_NUM ;
11: END G_MISS_NUM ;
12:
13: -- Local Function. Returns the Value of the Constant FND_API.G_MISS_CHAR to the caller
14: FUNCTION G_MISS_CHAR RETURN VARCHAR2 IS
15: BEGIN
16: RETURN FND_API.G_MISS_CHAR ;
17: END G_MISS_CHAR ;

Line 16: RETURN FND_API.G_MISS_CHAR ;

12:
13: -- Local Function. Returns the Value of the Constant FND_API.G_MISS_CHAR to the caller
14: FUNCTION G_MISS_CHAR RETURN VARCHAR2 IS
15: BEGIN
16: RETURN FND_API.G_MISS_CHAR ;
17: END G_MISS_CHAR ;
18:
19: -- Local Function. REturns the Value of the Constant FND_API.G_MISS_DATE to the caller
20: FUNCTION G_MISS_DATE RETURN DATE IS

Line 19: -- Local Function. REturns the Value of the Constant FND_API.G_MISS_DATE to the caller

15: BEGIN
16: RETURN FND_API.G_MISS_CHAR ;
17: END G_MISS_CHAR ;
18:
19: -- Local Function. REturns the Value of the Constant FND_API.G_MISS_DATE to the caller
20: FUNCTION G_MISS_DATE RETURN DATE IS
21: BEGIN
22: RETURN FND_API.G_MISS_DATE ;
23: END G_MISS_DATE ;

Line 22: RETURN FND_API.G_MISS_DATE ;

18:
19: -- Local Function. REturns the Value of the Constant FND_API.G_MISS_DATE to the caller
20: FUNCTION G_MISS_DATE RETURN DATE IS
21: BEGIN
22: RETURN FND_API.G_MISS_DATE ;
23: END G_MISS_DATE ;
24:
25: -- Local Function. REturns the Value of the Constants
26: -- FND_API.G_VALID_LEVEL_NONE , FND_API.G_VALID_LEVEL_FULL to the caller

Line 26: -- FND_API.G_VALID_LEVEL_NONE , FND_API.G_VALID_LEVEL_FULL to the caller

22: RETURN FND_API.G_MISS_DATE ;
23: END G_MISS_DATE ;
24:
25: -- Local Function. REturns the Value of the Constants
26: -- FND_API.G_VALID_LEVEL_NONE , FND_API.G_VALID_LEVEL_FULL to the caller
27: FUNCTION G_VALID_LEVEL(p_level varchar2) RETURN NUMBER IS
28: BEGIN
29: IF p_level = ('NONE') then
30: RETURN FND_API.G_VALID_LEVEL_NONE ;

Line 30: RETURN FND_API.G_VALID_LEVEL_NONE ;

26: -- FND_API.G_VALID_LEVEL_NONE , FND_API.G_VALID_LEVEL_FULL to the caller
27: FUNCTION G_VALID_LEVEL(p_level varchar2) RETURN NUMBER IS
28: BEGIN
29: IF p_level = ('NONE') then
30: RETURN FND_API.G_VALID_LEVEL_NONE ;
31: ELSIF p_level = ('FULL') then
32: RETURN FND_API.G_VALID_LEVEL_FULL ;
33: ELSE
34: -- Unrecognized parameter.

Line 32: RETURN FND_API.G_VALID_LEVEL_FULL ;

28: BEGIN
29: IF p_level = ('NONE') then
30: RETURN FND_API.G_VALID_LEVEL_NONE ;
31: ELSIF p_level = ('FULL') then
32: RETURN FND_API.G_VALID_LEVEL_FULL ;
33: ELSE
34: -- Unrecognized parameter.
35: FND_MSG_PUB.Add_Exc_Msg
36: ( p_pkg_name => G_PVT_NAME ,

Line 40: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

36: ( p_pkg_name => G_PVT_NAME ,
37: p_procedure_name => 'G_VALID_LEVEL' ,
38: p_error_text => 'Unrecognized Value : '||p_level
39: );
40: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
41: END IF;
42: END G_VALID_LEVEL ;
43:
44: -- Local Function. REturns the Value of the Constants

Line 45: -- FND_API.G_TRUE , FND_API.G_FALSE To the caller

41: END IF;
42: END G_VALID_LEVEL ;
43:
44: -- Local Function. REturns the Value of the Constants
45: -- FND_API.G_TRUE , FND_API.G_FALSE To the caller
46: FUNCTION G_BOOLEAN(p_FLAG varchar2) RETURN VARCHAR2 IS
47: BEGIN
48: if p_flag = 'TRUE' then
49: return FND_API.G_TRUE ;

Line 49: return FND_API.G_TRUE ;

45: -- FND_API.G_TRUE , FND_API.G_FALSE To the caller
46: FUNCTION G_BOOLEAN(p_FLAG varchar2) RETURN VARCHAR2 IS
47: BEGIN
48: if p_flag = 'TRUE' then
49: return FND_API.G_TRUE ;
50: elsif p_flag = 'FALSE' then
51: return FND_API.G_FALSE ;
52: ELSE
53: -- Unrecognized parameter.

Line 51: return FND_API.G_FALSE ;

47: BEGIN
48: if p_flag = 'TRUE' then
49: return FND_API.G_TRUE ;
50: elsif p_flag = 'FALSE' then
51: return FND_API.G_FALSE ;
52: ELSE
53: -- Unrecognized parameter.
54: FND_MSG_PUB.Add_Exc_Msg
55: ( p_pkg_name => G_PVT_NAME ,

Line 59: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

55: ( p_pkg_name => G_PVT_NAME ,
56: p_procedure_name => 'G_BOOLEAN' ,
57: p_error_text => 'Unrecognized Value : '||p_flag
58: );
59: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
60: END if;
61: END G_BOOLEAN;
62:
63: FUNCTION GET_ERROR_CONSTANT(err_msg VARCHAR2) RETURN VARCHAR2 IS

Line 67: RETURN FND_API.G_RET_STS_ERROR;

63: FUNCTION GET_ERROR_CONSTANT(err_msg VARCHAR2) RETURN VARCHAR2 IS
64:
65: BEGIN
66: IF err_msg = 'G_RET_STS_ERROR' THEN
67: RETURN FND_API.G_RET_STS_ERROR;
68: ELSIF err_msg = 'G_RET_STS_UNEXP_ERROR' THEN
69: RETURN FND_API.G_RET_STS_UNEXP_ERROR;
70: ELSIF err_msg = 'G_RET_STS_SUCCESS' THEN
71: RETURN FND_API.G_RET_STS_SUCCESS;

Line 69: RETURN FND_API.G_RET_STS_UNEXP_ERROR;

65: BEGIN
66: IF err_msg = 'G_RET_STS_ERROR' THEN
67: RETURN FND_API.G_RET_STS_ERROR;
68: ELSIF err_msg = 'G_RET_STS_UNEXP_ERROR' THEN
69: RETURN FND_API.G_RET_STS_UNEXP_ERROR;
70: ELSIF err_msg = 'G_RET_STS_SUCCESS' THEN
71: RETURN FND_API.G_RET_STS_SUCCESS;
72: END IF;
73:

Line 71: RETURN FND_API.G_RET_STS_SUCCESS;

67: RETURN FND_API.G_RET_STS_ERROR;
68: ELSIF err_msg = 'G_RET_STS_UNEXP_ERROR' THEN
69: RETURN FND_API.G_RET_STS_UNEXP_ERROR;
70: ELSIF err_msg = 'G_RET_STS_SUCCESS' THEN
71: RETURN FND_API.G_RET_STS_SUCCESS;
72: END IF;
73:
74: END GET_ERROR_CONSTANT;
75:

Line 217: p_init_msg_list => FND_API.G_FALSE,

213: l_location_rec.timezone_id := p_address_rec.timezone_id;
214: l_location_rec.created_by_module := 'SR';
215:
216: HZ_LOCATION_V2PUB.create_location (
217: p_init_msg_list => FND_API.G_FALSE,
218: p_location_rec => l_location_rec,
219: x_location_id => l_location_id,
220: x_return_status => l_return_status,
221: x_msg_count => l_msg_count,

Line 281: p_init_msg_list => FND_API.G_FALSE,

277: l_location_rec.sales_tax_inside_city_limits := p_address_rec.sales_tax_inside_city_limits;
278: l_location_rec.timezone_id := p_address_rec.timezone_id;
279:
280: HZ_LOCATION_V2PUB.update_location (
281: p_init_msg_list => FND_API.G_FALSE,
282: p_location_rec => l_location_rec,
283: p_object_version_number => x_object_version_number,
284: x_return_status => l_return_status,
285: x_msg_count => l_msg_count,

Line 321: p_init_msg_list => FND_API.G_FALSE,

317: l_phone_number := p_phone_number;
318:
319: HZ_CONTACT_POINT_PUB.phone_format (
320: p_api_version => 1.0,
321: p_init_msg_list => FND_API.G_FALSE,
322: p_territory_code => l_territory_code,
323: x_formatted_phone_number => l_formatted_phone_number,
324: x_phone_country_code => l_phone_country_code,
325: x_phone_area_code => l_phone_area_code,

Line 332: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

328: x_msg_count => l_msg_count,
329: x_msg_data => l_msg_data);
330:
331: -- If procedure does not return success then pass back null (since will be used in view definition)
332: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
333: -- return FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' );
334: return null;
335: else
336: return l_formatted_phone_number;

Line 355: RETURN FND_API.G_RET_STS_SUCCESS ;

351: END COMMIT_ROLLBACK;
352:
353: FUNCTION G_RET_STS_SUCCESS RETURN VARCHAR2 IS
354: BEGIN
355: RETURN FND_API.G_RET_STS_SUCCESS ;
356: END G_RET_STS_SUCCESS ;
357:
358:
359: FUNCTION G_RET_STS_ERROR RETURN VARCHAR2 IS

Line 361: RETURN FND_API.G_RET_STS_ERROR ;

357:
358:
359: FUNCTION G_RET_STS_ERROR RETURN VARCHAR2 IS
360: BEGIN
361: RETURN FND_API.G_RET_STS_ERROR ;
362: END G_RET_STS_ERROR ;
363:
364:
365: FUNCTION G_RET_STS_UNEXP_ERROR RETURN VARCHAR2 IS

Line 367: RETURN FND_API.G_RET_STS_UNEXP_ERROR ;

363:
364:
365: FUNCTION G_RET_STS_UNEXP_ERROR RETURN VARCHAR2 IS
366: BEGIN
367: RETURN FND_API.G_RET_STS_UNEXP_ERROR ;
368: END G_RET_STS_UNEXP_ERROR ;
369:
370:
371: FUNCTION G_VALID_LEVEL_NONE RETURN NUMBER IS

Line 373: RETURN FND_API.G_VALID_LEVEL_NONE ;

369:
370:
371: FUNCTION G_VALID_LEVEL_NONE RETURN NUMBER IS
372: BEGIN
373: RETURN FND_API.G_VALID_LEVEL_NONE ;
374: END;
375:
376:
377: FUNCTION G_VALID_LEVEL_FULL RETURN NUMBER IS

Line 379: RETURN FND_API.G_VALID_LEVEL_FULL ;

375:
376:
377: FUNCTION G_VALID_LEVEL_FULL RETURN NUMBER IS
378: BEGIN
379: RETURN FND_API.G_VALID_LEVEL_FULL ;
380: END;
381:
382:
383: FUNCTION G_VALID_LEVEL_INT RETURN NUMBER IS

Line 391: return FND_API.G_TRUE ;

387:
388:
389: FUNCTION G_TRUE RETURN VARCHAR2 IS
390: BEGIN
391: return FND_API.G_TRUE ;
392: END;
393:
394:
395: FUNCTION G_FALSE RETURN VARCHAR2 IS

Line 397: return FND_API.G_FALSE ;

393:
394:
395: FUNCTION G_FALSE RETURN VARCHAR2 IS
396: BEGIN
397: return FND_API.G_FALSE ;
398: END;
399: END CS_SR_CUST_CONT_MAINT_PVT;