APPS.AMS_UTILITY_PVT dependencies on FND_API

Line 110: -- 1. It will return FND_API.g_true/g_false.

106: -- PURPOSE
107: -- This function checks if a foreign key is valid.
108: --
109: -- NOTES
110: -- 1. It will return FND_API.g_true/g_false.
111: -- 2. Exception encountered will be raised to the caller.
112: -- 3. p_pk_data_type can be AMS_Global_PVT.g_number/g_varchar2.
113: -- 4. Please don't put 'AND' at the beginning of your additional
114: -- where clause.

Line 123: RETURN VARCHAR2; -- FND_API.g_true/g_false

119: p_pk_value IN VARCHAR2,
120: p_pk_data_type IN NUMBER := g_number,
121: p_additional_where_clause IN VARCHAR2 := NULL
122: )
123: RETURN VARCHAR2; -- FND_API.g_true/g_false
124:
125:
126: ---------------------------------------------------------------------
127: -- FUNCTION

Line 139: Return VARCHAR2; -- FND_API.g_true/g_false

135: p_lookup_table_name IN VARCHAR2 := g_ams_lookups,
136: p_lookup_type IN VARCHAR2,
137: p_lookup_code IN VARCHAR2
138: )
139: Return VARCHAR2; -- FND_API.g_true/g_false
140:
141: ---------------------------------------------------------------------
142: -- FUNCTION
143: -- check_lookup_exists

Line 154: Return VARCHAR2; -- FND_API.g_true/g_false

150: p_lookup_type IN VARCHAR2,
151: p_lookup_code IN VARCHAR2,
152: p_view_application_id IN NUMBER
153: )
154: Return VARCHAR2; -- FND_API.g_true/g_false
155:
156:
157: ---------------------------------------------------------------------
158: -- FUNCTION

Line 170: RETURN VARCHAR2; -- FND_API.g_true/g_false

166: FUNCTION check_uniqueness(
167: p_table_name IN VARCHAR2,
168: p_where_clause IN VARCHAR2
169: )
170: RETURN VARCHAR2; -- FND_API.g_true/g_false
171:
172:
173: ---------------------------------------------------------------------
174: -- FUNCTION

Line 178: -- Return FND_API.g_true if p_value='Y' or p_value='N';

174: -- FUNCTION
175: -- is_Y_or_N
176: --
177: -- PURPOSE
178: -- Return FND_API.g_true if p_value='Y' or p_value='N';
179: -- return FND_API.g_flase otherwise.
180: ---------------------------------------------------------------------
181: FUNCTION is_Y_or_N(
182: p_value IN VARCHAR2

Line 179: -- return FND_API.g_flase otherwise.

175: -- is_Y_or_N
176: --
177: -- PURPOSE
178: -- Return FND_API.g_true if p_value='Y' or p_value='N';
179: -- return FND_API.g_flase otherwise.
180: ---------------------------------------------------------------------
181: FUNCTION is_Y_or_N(
182: p_value IN VARCHAR2
183: )

Line 184: RETURN VARCHAR2; -- FND_API.g_true/g_false

180: ---------------------------------------------------------------------
181: FUNCTION is_Y_or_N(
182: p_value IN VARCHAR2
183: )
184: RETURN VARCHAR2; -- FND_API.g_true/g_false
185:
186:
187: ---------------------------------------------------------------------
188: -- PROCEDURE

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

368: -- converted to user timezone sent.
369: -- 06-sep-2001 choang set default for p_user_tz_id for bug 1857131.
370: ---------------------------------------------------------------------
371: PROCEDURE Convert_Timezone(
372: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
373: x_return_status OUT NOCOPY VARCHAR2,
374: x_msg_count OUT NOCOPY NUMBER,
375: x_msg_data OUT NOCOPY VARCHAR2,
376:

Line 705: ,p_conv_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR

701: ---------------------------------------------------------------------
702: PROCEDURE convert_currency(
703: p_from_currency IN VARCHAR2
704: ,p_to_currency IN VARCHAR2
705: ,p_conv_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
706: ,p_conv_rate IN NUMBER DEFAULT FND_API.G_MISS_NUM
707: ,p_conv_date IN DATE DEFAULT SYSDATE
708: ,p_from_amount IN NUMBER
709: ,x_return_status OUT NOCOPY VARCHAR2

Line 706: ,p_conv_rate IN NUMBER DEFAULT FND_API.G_MISS_NUM

702: PROCEDURE convert_currency(
703: p_from_currency IN VARCHAR2
704: ,p_to_currency IN VARCHAR2
705: ,p_conv_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
706: ,p_conv_rate IN NUMBER DEFAULT FND_API.G_MISS_NUM
707: ,p_conv_date IN DATE DEFAULT SYSDATE
708: ,p_from_amount IN NUMBER
709: ,x_return_status OUT NOCOPY VARCHAR2
710: ,x_to_amount OUT NOCOPY NUMBER

Line 784: -- Returns FND_API.G_TRUE if it is valid status change

780: -- Check_Status_Change
781: --
782: -- PURPOSE
783: -- Created to check if the status change is valid or not.
784: -- Returns FND_API.G_TRUE if it is valid status change
785: -- or will return FND_API.G_FALSE
786: --
787: -- HISTORY
788: -- 09-Jul-2001 ptendulk Create.

Line 785: -- or will return FND_API.G_FALSE

781: --
782: -- PURPOSE
783: -- Created to check if the status change is valid or not.
784: -- Returns FND_API.G_TRUE if it is valid status change
785: -- or will return FND_API.G_FALSE
786: --
787: -- HISTORY
788: -- 09-Jul-2001 ptendulk Create.
789: --======================================================================