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.

[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 223: p_init_msg_list => FND_API.G_FALSE,

219: l_location_rec.timezone_id := p_address_rec.timezone_id;
220: l_location_rec.created_by_module := 'SR';
221:
222: HZ_LOCATION_V2PUB.create_location (
223: p_init_msg_list => FND_API.G_FALSE,
224: p_location_rec => l_location_rec,
225: p_do_addr_val => p_do_addr_val, -- 12.1.2 Address Validation
226: x_location_id => l_location_id,
227: x_return_status => l_return_status,

Line 300: p_init_msg_list => FND_API.G_FALSE,

296: l_location_rec.sales_tax_inside_city_limits := p_address_rec.sales_tax_inside_city_limits;
297: l_location_rec.timezone_id := p_address_rec.timezone_id;
298:
299: HZ_LOCATION_V2PUB.update_location (
300: p_init_msg_list => FND_API.G_FALSE,
301: p_location_rec => l_location_rec,
302: p_do_addr_val => p_do_addr_val, -- 12.1.2 Address Validation
303: p_object_version_number => x_object_version_number,
304: x_return_status => l_return_status,

Line 345: p_init_msg_list => FND_API.G_FALSE,

341: l_phone_number := p_phone_number;
342:
343: HZ_CONTACT_POINT_PUB.phone_format (
344: p_api_version => 1.0,
345: p_init_msg_list => FND_API.G_FALSE,
346: p_territory_code => l_territory_code,
347: x_formatted_phone_number => l_formatted_phone_number,
348: x_phone_country_code => l_phone_country_code,
349: x_phone_area_code => l_phone_area_code,

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

352: x_msg_count => l_msg_count,
353: x_msg_data => l_msg_data);
354:
355: -- If procedure does not return success then pass back null (since will be used in view definition)
356: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
357: -- return FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' );
358: return null;
359: else
360: return l_formatted_phone_number;

Line 379: RETURN FND_API.G_RET_STS_SUCCESS ;

375: END COMMIT_ROLLBACK;
376:
377: FUNCTION G_RET_STS_SUCCESS RETURN VARCHAR2 IS
378: BEGIN
379: RETURN FND_API.G_RET_STS_SUCCESS ;
380: END G_RET_STS_SUCCESS ;
381:
382:
383: FUNCTION G_RET_STS_ERROR RETURN VARCHAR2 IS

Line 385: RETURN FND_API.G_RET_STS_ERROR ;

381:
382:
383: FUNCTION G_RET_STS_ERROR RETURN VARCHAR2 IS
384: BEGIN
385: RETURN FND_API.G_RET_STS_ERROR ;
386: END G_RET_STS_ERROR ;
387:
388:
389: FUNCTION G_RET_STS_UNEXP_ERROR RETURN VARCHAR2 IS

Line 391: RETURN FND_API.G_RET_STS_UNEXP_ERROR ;

387:
388:
389: FUNCTION G_RET_STS_UNEXP_ERROR RETURN VARCHAR2 IS
390: BEGIN
391: RETURN FND_API.G_RET_STS_UNEXP_ERROR ;
392: END G_RET_STS_UNEXP_ERROR ;
393:
394:
395: FUNCTION G_VALID_LEVEL_NONE RETURN NUMBER IS

Line 397: RETURN FND_API.G_VALID_LEVEL_NONE ;

393:
394:
395: FUNCTION G_VALID_LEVEL_NONE RETURN NUMBER IS
396: BEGIN
397: RETURN FND_API.G_VALID_LEVEL_NONE ;
398: END;
399:
400:
401: FUNCTION G_VALID_LEVEL_FULL RETURN NUMBER IS

Line 403: RETURN FND_API.G_VALID_LEVEL_FULL ;

399:
400:
401: FUNCTION G_VALID_LEVEL_FULL RETURN NUMBER IS
402: BEGIN
403: RETURN FND_API.G_VALID_LEVEL_FULL ;
404: END;
405:
406:
407: FUNCTION G_VALID_LEVEL_INT RETURN NUMBER IS

Line 415: return FND_API.G_TRUE ;

411:
412:
413: FUNCTION G_TRUE RETURN VARCHAR2 IS
414: BEGIN
415: return FND_API.G_TRUE ;
416: END;
417:
418:
419: FUNCTION G_FALSE RETURN VARCHAR2 IS

Line 421: return FND_API.G_FALSE ;

417:
418:
419: FUNCTION G_FALSE RETURN VARCHAR2 IS
420: BEGIN
421: return FND_API.G_FALSE ;
422: END;
423: END CS_SR_CUST_CONT_MAINT_PVT;