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

Line 154: -- 6. Please don't pass in any FND_API.g_mess_char/num/date.

150: -- the sequence.
151: -- 4. If a flag column is passed in, check if it is 'Y' or 'N'.
152: -- Raise exception for invalid flag.
153: -- 5. If a flag column is not passed in, default it to 'Y' or 'N'.
154: -- 6. Please don't pass in any FND_API.g_mess_char/num/date.
155: ---------------------------------------------------------------------
156:
157: /*#
158: * This procedure creates a marketing campaign. The details of the campaign will be passed

Line 169: * FND_API.G_RET_STS_SUCCESS: Indicates the API call was successful;

165: * @param p_commit Flag to indicate if changes should be comitted on success.
166: * @param p_validation_level Level of validation required. None: No validation will be performed. Full: Item and record level validation will be performed.
167: * @param p_camp_rec Record of type AMS_Campaign_PVT.camp_rec_type that takes in the details for the Campaign.
168: * @param x_return_status Indicates the return status of the API. The values are one of the following:
169: * FND_API.G_RET_STS_SUCCESS: Indicates the API call was successful;
170: * FND_API.G_RET_STS_ERROR: Indicates there was a validation error or a missing data error;
171: * FND_API.G_RET_STS_UNEXP_ERROR: Indicates the calling program encountered an unxpected or unhandled error.
172: * @param x_msg_count Count of error messages in the message list.
173: * @param x_msg_data Error messages returned by the API. If more than one message is returned, this parameter is null and messages must be extracted from the message stack.

Line 170: * FND_API.G_RET_STS_ERROR: Indicates there was a validation error or a missing data error;

166: * @param p_validation_level Level of validation required. None: No validation will be performed. Full: Item and record level validation will be performed.
167: * @param p_camp_rec Record of type AMS_Campaign_PVT.camp_rec_type that takes in the details for the Campaign.
168: * @param x_return_status Indicates the return status of the API. The values are one of the following:
169: * FND_API.G_RET_STS_SUCCESS: Indicates the API call was successful;
170: * FND_API.G_RET_STS_ERROR: Indicates there was a validation error or a missing data error;
171: * FND_API.G_RET_STS_UNEXP_ERROR: Indicates the calling program encountered an unxpected or unhandled error.
172: * @param x_msg_count Count of error messages in the message list.
173: * @param x_msg_data Error messages returned by the API. If more than one message is returned, this parameter is null and messages must be extracted from the message stack.
174: * @param x_camp_id Unique identifier for the newly created Campaign

Line 171: * FND_API.G_RET_STS_UNEXP_ERROR: Indicates the calling program encountered an unxpected or unhandled error.

167: * @param p_camp_rec Record of type AMS_Campaign_PVT.camp_rec_type that takes in the details for the Campaign.
168: * @param x_return_status Indicates the return status of the API. The values are one of the following:
169: * FND_API.G_RET_STS_SUCCESS: Indicates the API call was successful;
170: * FND_API.G_RET_STS_ERROR: Indicates there was a validation error or a missing data error;
171: * FND_API.G_RET_STS_UNEXP_ERROR: Indicates the calling program encountered an unxpected or unhandled error.
172: * @param x_msg_count Count of error messages in the message list.
173: * @param x_msg_data Error messages returned by the API. If more than one message is returned, this parameter is null and messages must be extracted from the message stack.
174: * @param x_camp_id Unique identifier for the newly created Campaign
175: * @rep:scope public

Line 182: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

178: */
179:
180: PROCEDURE create_campaign(
181: p_api_version IN NUMBER,
182: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
183: p_commit IN VARCHAR2 := FND_API.g_false,
184: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
185:
186: x_return_status OUT NOCOPY VARCHAR2,

Line 183: p_commit IN VARCHAR2 := FND_API.g_false,

179:
180: PROCEDURE create_campaign(
181: p_api_version IN NUMBER,
182: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
183: p_commit IN VARCHAR2 := FND_API.g_false,
184: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
185:
186: x_return_status OUT NOCOPY VARCHAR2,
187: x_msg_count OUT NOCOPY NUMBER,

Line 184: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

180: PROCEDURE create_campaign(
181: p_api_version IN NUMBER,
182: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
183: p_commit IN VARCHAR2 := FND_API.g_false,
184: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
185:
186: x_return_status OUT NOCOPY VARCHAR2,
187: x_msg_count OUT NOCOPY NUMBER,
188: x_msg_data OUT NOCOPY VARCHAR2,

Line 213: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

209: -- from database.
210: --------------------------------------------------------------------
211: PROCEDURE delete_campaign(
212: p_api_version IN NUMBER,
213: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
214: p_commit IN VARCHAR2 := FND_API.g_false,
215:
216: x_return_status OUT NOCOPY VARCHAR2,
217: x_msg_count OUT NOCOPY NUMBER,

Line 214: p_commit IN VARCHAR2 := FND_API.g_false,

210: --------------------------------------------------------------------
211: PROCEDURE delete_campaign(
212: p_api_version IN NUMBER,
213: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
214: p_commit IN VARCHAR2 := FND_API.g_false,
215:
216: x_return_status OUT NOCOPY VARCHAR2,
217: x_msg_count OUT NOCOPY NUMBER,
218: x_msg_data OUT NOCOPY VARCHAR2,

Line 241: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

237: -- 1. Raise exception if the object_version_number doesn't match.
238: --------------------------------------------------------------------
239: PROCEDURE lock_campaign(
240: p_api_version IN NUMBER,
241: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
242:
243: x_return_status OUT NOCOPY VARCHAR2,
244: x_msg_count OUT NOCOPY NUMBER,
245: x_msg_data OUT NOCOPY VARCHAR2,

Line 264: -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,

260: -- p_camp_rec: the record with new items
261: --
262: -- NOTES
263: -- 1. Raise exception if the object_version_number doesn't match.
264: -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,
265: -- that column won't be updated.
266: ----------------------------------------------------------------------
267:
268: /*#

Line 279: * FND_API.G_RET_STS_SUCCESS: Indicates the API call was successful;

275: * @param p_commit Flag to indicate if changes should be comitted on success.
276: * @param p_validation_level Level of validation required. None: No validation will be performed. Full: Item and record level validation will be performed.
277: * @param p_camp_rec Record of type AMS_Campaign_PVT.camp_rec_type that takes in the details for the Campaign.
278: * @param x_return_status Indicates the return status of the API. The values are one of the following:
279: * FND_API.G_RET_STS_SUCCESS: Indicates the API call was successful;
280: * FND_API.G_RET_STS_ERROR: Indicates there was a validation error or a missing data error;
281: * FND_API.G_RET_STS_UNEXP_ERROR: Indicates the calling program encountered an unxpected or unhandled error.
282: * @param x_msg_count Count of error messages in the message list.
283: * @param x_msg_data Error messages returned by the API. If more than one message is returned, this parameter is null and messages must be extracted from the message stack.

Line 280: * FND_API.G_RET_STS_ERROR: Indicates there was a validation error or a missing data error;

276: * @param p_validation_level Level of validation required. None: No validation will be performed. Full: Item and record level validation will be performed.
277: * @param p_camp_rec Record of type AMS_Campaign_PVT.camp_rec_type that takes in the details for the Campaign.
278: * @param x_return_status Indicates the return status of the API. The values are one of the following:
279: * FND_API.G_RET_STS_SUCCESS: Indicates the API call was successful;
280: * FND_API.G_RET_STS_ERROR: Indicates there was a validation error or a missing data error;
281: * FND_API.G_RET_STS_UNEXP_ERROR: Indicates the calling program encountered an unxpected or unhandled error.
282: * @param x_msg_count Count of error messages in the message list.
283: * @param x_msg_data Error messages returned by the API. If more than one message is returned, this parameter is null and messages must be extracted from the message stack.
284: * @rep:scope public

Line 281: * FND_API.G_RET_STS_UNEXP_ERROR: Indicates the calling program encountered an unxpected or unhandled error.

277: * @param p_camp_rec Record of type AMS_Campaign_PVT.camp_rec_type that takes in the details for the Campaign.
278: * @param x_return_status Indicates the return status of the API. The values are one of the following:
279: * FND_API.G_RET_STS_SUCCESS: Indicates the API call was successful;
280: * FND_API.G_RET_STS_ERROR: Indicates there was a validation error or a missing data error;
281: * FND_API.G_RET_STS_UNEXP_ERROR: Indicates the calling program encountered an unxpected or unhandled error.
282: * @param x_msg_count Count of error messages in the message list.
283: * @param x_msg_data Error messages returned by the API. If more than one message is returned, this parameter is null and messages must be extracted from the message stack.
284: * @rep:scope public
285: * @rep:lifecycle active

Line 291: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

287: */
288:
289: PROCEDURE update_campaign(
290: p_api_version IN NUMBER,
291: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
292: p_commit IN VARCHAR2 := FND_API.g_false,
293: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
294:
295: x_return_status OUT NOCOPY VARCHAR2,

Line 292: p_commit IN VARCHAR2 := FND_API.g_false,

288:
289: PROCEDURE update_campaign(
290: p_api_version IN NUMBER,
291: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
292: p_commit IN VARCHAR2 := FND_API.g_false,
293: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
294:
295: x_return_status OUT NOCOPY VARCHAR2,
296: x_msg_count OUT NOCOPY NUMBER,

Line 293: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

289: PROCEDURE update_campaign(
290: p_api_version IN NUMBER,
291: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
292: p_commit IN VARCHAR2 := FND_API.g_false,
293: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
294:
295: x_return_status OUT NOCOPY VARCHAR2,
296: x_msg_count OUT NOCOPY NUMBER,
297: x_msg_data OUT NOCOPY VARCHAR2,

Line 315: -- should not be any FND_API.g_miss_char/num/date in it.

311: -- p_camp_rec: the campaign record to be validated
312: --
313: -- NOTES
314: -- 1. p_camp_rec should be the complete campaign record. There
315: -- should not be any FND_API.g_miss_char/num/date in it.
316: ----------------------------------------------------------------------
317: PROCEDURE validate_campaign(
318: p_api_version IN NUMBER,
319: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

Line 319: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

315: -- should not be any FND_API.g_miss_char/num/date in it.
316: ----------------------------------------------------------------------
317: PROCEDURE validate_campaign(
318: p_api_version IN NUMBER,
319: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
320: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
321:
322: x_return_status OUT NOCOPY VARCHAR2,
323: x_msg_count OUT NOCOPY NUMBER,

Line 320: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

316: ----------------------------------------------------------------------
317: PROCEDURE validate_campaign(
318: p_api_version IN NUMBER,
319: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
320: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
321:
322: x_return_status OUT NOCOPY VARCHAR2,
323: x_msg_count OUT NOCOPY NUMBER,
324: x_msg_data OUT NOCOPY VARCHAR2,