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

Line 20: -- 12-03-2002 jamose Added function for Fnd_Api_G_Miss* Changes

16: -- 05-04-2000 dejoseph Included procedure to gather CBO statistics on a given
17: -- table.
18: -- 02-22-2001 dejoseph Added two more plan status functions, MERGE_PLAN and
19: -- TRANSFER_PLAN for the purpose of Party Merge.
20: -- 12-03-2002 jamose Added function for Fnd_Api_G_Miss* Changes
21: -- End of Comments
22:
23:
24: G_PVT CONSTANT VARCHAR2(30):= '_PVT';

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

84: -- *******************************************************
85: -- API Name : G_MISS_NUM
86: -- Type : Private Function
87: -- Pre-Req : None
88: -- Function : Returns the Value of the Constant FND_API.G_MISS_NUM
89: -- Return Type : Number
90: --
91: -- End of Comments
92: --

Line 101: -- Function : Returns the Value of the Constant FND_API.G_MISS_CHAR

97: -- *******************************************************
98: -- API Name : G_MISS_CHAR
99: -- Type : Private Function
100: -- Pre-Req : None
101: -- Function : Returns the Value of the Constant FND_API.G_MISS_CHAR
102: -- Return Type : Varchar2
103: --
104: -- End of Comments
105: --

Line 114: -- Function : Returns the Value of the Constant FND_API.G_MISS_DATE

110: -- *******************************************************
111: -- API Name : G_MISS_DATE
112: -- Type : Private Function
113: -- Pre-Req : None
114: -- Function : Returns the Value of the Constant FND_API.G_MISS_DATE
115: -- Return Type : Date
116: --
117: -- End of Comments
118: --

Line 127: -- Function : Returns the Value of the Constant FND_API.G_RET_STS_SUCCESS

123: -- *******************************************************
124: -- API Name : G_RET_STS_SUCCESS
125: -- Type : Private Function
126: -- Pre-Req : None
127: -- Function : Returns the Value of the Constant FND_API.G_RET_STS_SUCCESS
128: -- Return Type : Date
129: --
130: -- End of Comments
131: --

Line 140: -- Function : Returns the Value of the Constant FND_API.G_RET_STS_ERROR

136: -- *******************************************************
137: -- API Name : G_RET_STS_ERROR
138: -- Type : Private Function
139: -- Pre-Req : None
140: -- Function : Returns the Value of the Constant FND_API.G_RET_STS_ERROR
141: -- Return Type : Date
142: --
143: -- End of Comments
144: --

Line 153: -- Function : Returns the Value of the Constant FND_API.G_RET_STS_UNEXP_ERROR

149: -- *******************************************************
150: -- API Name : G_RET_STS_UNEXP_ERROR
151: -- Type : Private Function
152: -- Pre-Req : None
153: -- Function : Returns the Value of the Constant FND_API.G_RET_STS_UNEXP_ERROR
154: -- Return Type : Date
155: --
156: -- End of Comments
157: --

Line 167: -- FND_API.G_VALID_LEVEL_NONE

163: -- API Name : G_VALID_LEVEL_NONE
164: -- Type : Private Function
165: -- Pre-Req : None
166: -- Function : Returns the Value of the Constant
167: -- FND_API.G_VALID_LEVEL_NONE
168: -- Return Type : Number
169: --
170: -- End of Comments
171: --

Line 181: -- FND_API.G_VALID_LEVEL_FULL

177: -- API Name : G_VALID_LEVEL_FULL
178: -- Type : Private Function
179: -- Pre-Req : None
180: -- Function : Returns the Value of the Constant
181: -- FND_API.G_VALID_LEVEL_FULL
182: -- Return Type : Number
183: --
184: -- End of Comments
185: --

Line 209: -- FND_API.G_TRUE

205: -- API Name : G_TRUE
206: -- Type : Private Function
207: -- Pre-Req : None
208: -- Function : Returns the Value of the Constant
209: -- FND_API.G_TRUE
210: -- Return Type : Varchar2
211: --
212: -- End of Comments
213: --

Line 223: -- FND_API.G_FALSE

219: -- API Name : G_FALSE
220: -- Type : Private Function
221: -- Pre-Req : None
222: -- Function : Returns the Value of the Constant
223: -- FND_API.G_FALSE
224: -- Return Type : Varchar2
225: --
226: -- End of Comments
227: --

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

354: X_MSG_DATA OUT NOCOPY VARCHAR2,
355: X_RETURN_STATUS OUT NOCOPY VARCHAR2);
356:
357: PROCEDURE Validate_Dates (
358: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
359: p_validation_mode IN VARCHAR2,
360: P_START_DATE IN DATE,
361: P_END_DATE IN DATE,
362: x_return_status OUT NOCOPY VARCHAR2,

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

364: x_msg_data OUT NOCOPY VARCHAR2);
365:
366:
367: PROCEDURE Validate_Not_Nulls (
368: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
369: p_validation_mode IN VARCHAR2,
370: P_COLUMN_NAME IN VARCHAR2,
371: P_COLUMN_VALUE IN VARCHAR2,
372: x_return_status OUT NOCOPY VARCHAR2,

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

373: x_msg_count OUT NOCOPY NUMBER,
374: x_msg_data OUT NOCOPY VARCHAR2);
375:
376: PROCEDURE Validate_Not_Nulls (
377: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
378: p_validation_mode IN VARCHAR2,
379: P_COLUMN_NAME IN VARCHAR2,
380: P_COLUMN_VALUE IN NUMBER,
381: x_return_status OUT NOCOPY VARCHAR2,

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

382: x_msg_count OUT NOCOPY NUMBER,
383: x_msg_data OUT NOCOPY VARCHAR2);
384:
385: PROCEDURE Validate_Not_Nulls (
386: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
387: p_validation_mode IN VARCHAR2,
388: P_COLUMN_NAME IN VARCHAR2,
389: P_COLUMN_VALUE IN DATE,
390: x_return_status OUT NOCOPY VARCHAR2,

Line 450: -- lookupcode exists in fnd_lookups. Returns FND_API.G_RET_STS_SUCCESS

446: --
447:
448: -- Description:
449: -- A function for lookupcode validation. Used to validate a date tracked
450: -- lookupcode exists in fnd_lookups. Returns FND_API.G_RET_STS_SUCCESS
451: -- if the lookup code exists else returns FND_API.G_RET_STS_ERROR if the
452: -- lookup code doesnt exist or if not enabled or if it doesnt exist for
453: -- the specified period (p_effective_date).
454: --

Line 451: -- if the lookup code exists else returns FND_API.G_RET_STS_ERROR if the

447:
448: -- Description:
449: -- A function for lookupcode validation. Used to validate a date tracked
450: -- lookupcode exists in fnd_lookups. Returns FND_API.G_RET_STS_SUCCESS
451: -- if the lookup code exists else returns FND_API.G_RET_STS_ERROR if the
452: -- lookup code doesnt exist or if not enabled or if it doesnt exist for
453: -- the specified period (p_effective_date).
454: --
455: --

Line 464: -- FND_API.G_RET_STS_SUCCESS else G_RET_STS_ERROR.

460: --
461: -- Returns the status depending on the outcome
462: -- If p_currency_code is valid for the specified
463: -- (p_effective_date) period then returns
464: -- FND_API.G_RET_STS_SUCCESS else G_RET_STS_ERROR.
465:
466: --
467: -- Access Status:
468: -- Internal Development Use Only.

Line 495: -- currency code exists in fnd_currencies. Returns FND_API.G_RET_STS_SUCCESS

491: --
492:
493: -- Description:
494: -- A function for currency code validation. Used to validate a date tracked
495: -- currency code exists in fnd_currencies. Returns FND_API.G_RET_STS_SUCCESS
496: -- if the currency code exists else returns FND_API.G_RET_STS_ERROR if the
497: -- currency code doesnt exist or if not enabled or if it doesnt exist for
498: -- the specified period (p_effective_date).
499: --

Line 496: -- if the currency code exists else returns FND_API.G_RET_STS_ERROR if the

492:
493: -- Description:
494: -- A function for currency code validation. Used to validate a date tracked
495: -- currency code exists in fnd_currencies. Returns FND_API.G_RET_STS_SUCCESS
496: -- if the currency code exists else returns FND_API.G_RET_STS_ERROR if the
497: -- currency code doesnt exist or if not enabled or if it doesnt exist for
498: -- the specified period (p_effective_date).
499: --
500: --

Line 509: -- FND_API.G_RET_STS_SUCCESS else G_RET_STS_ERROR.

505: --
506: -- Returns the status depending on the outcome.
507: -- If p_currency_code is enabled for the specified
508: -- (p_effective_date) period then returns
509: -- FND_API.G_RET_STS_SUCCESS else G_RET_STS_ERROR.
510: --
511: -- Access Status:
512: -- Internal Development Use Only.
513:

Line 530: -- never be NULL.If end_date is null then uses the fnd_api.g_miss_date to

526: --
527:
528: -- Description:
529: -- Used for validating the start and end date. Assuming the start date will
530: -- never be NULL.If end_date is null then uses the fnd_api.g_miss_date to
531: -- validate the dates.
532:
533: -- Writes the messages CS_ALL_START_DATE and CS_ALL_END_DATE. Returns
534: -- FND_API.G_RET_STS_SUCCESS if start_date < session_date and end_date < start_date

Line 534: -- FND_API.G_RET_STS_SUCCESS if start_date < session_date and end_date < start_date

530: -- never be NULL.If end_date is null then uses the fnd_api.g_miss_date to
531: -- validate the dates.
532:
533: -- Writes the messages CS_ALL_START_DATE and CS_ALL_END_DATE. Returns
534: -- FND_API.G_RET_STS_SUCCESS if start_date < session_date and end_date < start_date
535: -- else returns FND_API.G_RET_STS_ERROR.
536:
537: --
538: -- In Arguments:

Line 535: -- else returns FND_API.G_RET_STS_ERROR.

531: -- validate the dates.
532:
533: -- Writes the messages CS_ALL_START_DATE and CS_ALL_END_DATE. Returns
534: -- FND_API.G_RET_STS_SUCCESS if start_date < session_date and end_date < start_date
535: -- else returns FND_API.G_RET_STS_ERROR.
536:
537: --
538: -- In Arguments:
539: -- p_api_name IN VARCHAR2