DBA Data[Home] [Help]

APPS.HZ_CUSTOMER_PROFILE_V2PUB dependencies on FND_API

Line 270: * FND_API.G_TRUE. Default is FND_API.G_FALSE.

266: *
267: * ARGUMENTS
268: * IN:
269: * p_init_msg_list Initialize message stack if it is set to
270: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
271: * p_customer_profile_rec Customer profile record. One customer account
272: * must have a customer profile. One account site
273: * use can optionally have one customer profile.
274: * p_create_profile_amt If it is set to FND_API.G_TRUE, API create customer

Line 274: * p_create_profile_amt If it is set to FND_API.G_TRUE, API create customer

270: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
271: * p_customer_profile_rec Customer profile record. One customer account
272: * must have a customer profile. One account site
273: * use can optionally have one customer profile.
274: * p_create_profile_amt If it is set to FND_API.G_TRUE, API create customer
275: * profile amounts by copying corresponding data
276: * from customer profile class amounts.
277: * IN/OUT:
278: * OUT:

Line 281: * be FND_API.G_RET_STS_SUCCESS (success),

277: * IN/OUT:
278: * OUT:
279: * x_cust_account_profile_id Customer account profile ID.
280: * x_return_status Return status after the call. The status can
281: * be FND_API.G_RET_STS_SUCCESS (success),
282: * FND_API.G_RET_STS_ERROR (error),
283: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
284: * x_msg_count Number of messages in message stack.
285: * x_msg_data Message text if x_msg_count is 1.

Line 282: * FND_API.G_RET_STS_ERROR (error),

278: * OUT:
279: * x_cust_account_profile_id Customer account profile ID.
280: * x_return_status Return status after the call. The status can
281: * be FND_API.G_RET_STS_SUCCESS (success),
282: * FND_API.G_RET_STS_ERROR (error),
283: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
284: * x_msg_count Number of messages in message stack.
285: * x_msg_data Message text if x_msg_count is 1.
286: *

Line 283: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

279: * x_cust_account_profile_id Customer account profile ID.
280: * x_return_status Return status after the call. The status can
281: * be FND_API.G_RET_STS_SUCCESS (success),
282: * FND_API.G_RET_STS_ERROR (error),
283: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
284: * x_msg_count Number of messages in message stack.
285: * x_msg_data Message text if x_msg_count is 1.
286: *
287: * NOTES

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

303: * @rep:businessevent oracle.apps.ar.hz.CustomerProfile.create
304: * @rep:doccd 120hztig.pdf Customer Profile APIs, Oracle Trading Community Architecture Technical Implementation Guide
305: */
306: PROCEDURE create_customer_profile (
307: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
308: p_customer_profile_rec IN CUSTOMER_PROFILE_REC_TYPE,
309: p_create_profile_amt IN VARCHAR2 := FND_API.G_TRUE,
310: x_cust_account_profile_id OUT NOCOPY NUMBER,
311: x_return_status OUT NOCOPY VARCHAR2,

Line 309: p_create_profile_amt IN VARCHAR2 := FND_API.G_TRUE,

305: */
306: PROCEDURE create_customer_profile (
307: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
308: p_customer_profile_rec IN CUSTOMER_PROFILE_REC_TYPE,
309: p_create_profile_amt IN VARCHAR2 := FND_API.G_TRUE,
310: x_cust_account_profile_id OUT NOCOPY NUMBER,
311: x_return_status OUT NOCOPY VARCHAR2,
312: x_msg_count OUT NOCOPY NUMBER,
313: x_msg_data OUT NOCOPY VARCHAR2

Line 327: * FND_API.G_TRUE. Default is FND_API.G_FALSE.

323: *
324: * ARGUMENTS
325: * IN:
326: * p_init_msg_list Initialize message stack if it is set to
327: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
328: * p_customer_profile_rec Customer profile record. One customer account
329: * must have a customer profile. One account site
330: * use can optionally have one customer profile.
331: * IN/OUT:

Line 335: * be FND_API.G_RET_STS_SUCCESS (success),

331: * IN/OUT:
332: * p_object_version_number Used for locking the being updated record.
333: * OUT:
334: * x_return_status Return status after the call. The status can
335: * be FND_API.G_RET_STS_SUCCESS (success),
336: * FND_API.G_RET_STS_ERROR (error),
337: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
338: * x_msg_count Number of messages in message stack.
339: * x_msg_data Message text if x_msg_count is 1.

Line 336: * FND_API.G_RET_STS_ERROR (error),

332: * p_object_version_number Used for locking the being updated record.
333: * OUT:
334: * x_return_status Return status after the call. The status can
335: * be FND_API.G_RET_STS_SUCCESS (success),
336: * FND_API.G_RET_STS_ERROR (error),
337: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
338: * x_msg_count Number of messages in message stack.
339: * x_msg_data Message text if x_msg_count is 1.
340: *

Line 337: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

333: * OUT:
334: * x_return_status Return status after the call. The status can
335: * be FND_API.G_RET_STS_SUCCESS (success),
336: * FND_API.G_RET_STS_ERROR (error),
337: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
338: * x_msg_count Number of messages in message stack.
339: * x_msg_data Message text if x_msg_count is 1.
340: *
341: * NOTES

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

356: * @rep:businessevent oracle.apps.ar.hz.CustomerProfile.update
357: * @rep:doccd 120hztig.pdf Customer Profile APIs, Oracle Trading Community Architecture Technical Implementation Guide
358: */
359: PROCEDURE update_customer_profile (
360: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
361: p_customer_profile_rec IN CUSTOMER_PROFILE_REC_TYPE,
362: p_object_version_number IN OUT NOCOPY NUMBER,
363: x_return_status OUT NOCOPY VARCHAR2,
364: x_msg_count OUT NOCOPY NUMBER,

Line 379: * FND_API.G_TRUE. Default is FND_API.G_FALSE.

375: *
376: * ARGUMENTS
377: * IN:
378: * p_init_msg_list Initialize message stack if it is set to
379: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
380: * p_cust_account_profile_id Customer account profile id.
381: * IN/OUT:
382: * OUT:
383: * x_customer_profile_rec Returned customer profile record.

Line 385: * be FND_API.G_RET_STS_SUCCESS (success),

381: * IN/OUT:
382: * OUT:
383: * x_customer_profile_rec Returned customer profile record.
384: * x_return_status Return status after the call. The status can
385: * be FND_API.G_RET_STS_SUCCESS (success),
386: * FND_API.G_RET_STS_ERROR (error),
387: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
388: * x_msg_count Number of messages in message stack.
389: * x_msg_data Message text if x_msg_count is 1.

Line 386: * FND_API.G_RET_STS_ERROR (error),

382: * OUT:
383: * x_customer_profile_rec Returned customer profile record.
384: * x_return_status Return status after the call. The status can
385: * be FND_API.G_RET_STS_SUCCESS (success),
386: * FND_API.G_RET_STS_ERROR (error),
387: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
388: * x_msg_count Number of messages in message stack.
389: * x_msg_data Message text if x_msg_count is 1.
390: *

Line 387: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

383: * x_customer_profile_rec Returned customer profile record.
384: * x_return_status Return status after the call. The status can
385: * be FND_API.G_RET_STS_SUCCESS (success),
386: * FND_API.G_RET_STS_ERROR (error),
387: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
388: * x_msg_count Number of messages in message stack.
389: * x_msg_data Message text if x_msg_count is 1.
390: *
391: * NOTES

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

396: *
397: */
398:
399: PROCEDURE get_customer_profile_rec (
400: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
401: p_cust_account_profile_id IN NUMBER,
402: x_customer_profile_rec OUT NOCOPY CUSTOMER_PROFILE_REC_TYPE,
403: x_return_status OUT NOCOPY VARCHAR2,
404: x_msg_count OUT NOCOPY NUMBER,

Line 419: * FND_API.G_TRUE. Default is FND_API.G_FALSE.

415: *
416: * ARGUMENTS
417: * IN:
418: * p_init_msg_list Initialize message stack if it is set to
419: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
420: * p_check_foreign_key If do foreign key checking on cust_account_id
421: * and cust_account_profile_id or not. Defaut value
422: * is FND_API.G_TRUE, which means API will do foreign
423: * key checking on these 2 columns.

Line 422: * is FND_API.G_TRUE, which means API will do foreign

418: * p_init_msg_list Initialize message stack if it is set to
419: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
420: * p_check_foreign_key If do foreign key checking on cust_account_id
421: * and cust_account_profile_id or not. Defaut value
422: * is FND_API.G_TRUE, which means API will do foreign
423: * key checking on these 2 columns.
424: * p_cust_profile_amt_rec Customer profile amount record.
425: * IN/OUT:
426: * OUT:

Line 429: * be FND_API.G_RET_STS_SUCCESS (success),

425: * IN/OUT:
426: * OUT:
427: * x_cust_acct_profile_amt_id Customer account profile amount ID.
428: * x_return_status Return status after the call. The status can
429: * be FND_API.G_RET_STS_SUCCESS (success),
430: * FND_API.G_RET_STS_ERROR (error),
431: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
432: * x_msg_count Number of messages in message stack.
433: * x_msg_data Message text if x_msg_count is 1.

Line 430: * FND_API.G_RET_STS_ERROR (error),

426: * OUT:
427: * x_cust_acct_profile_amt_id Customer account profile amount ID.
428: * x_return_status Return status after the call. The status can
429: * be FND_API.G_RET_STS_SUCCESS (success),
430: * FND_API.G_RET_STS_ERROR (error),
431: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
432: * x_msg_count Number of messages in message stack.
433: * x_msg_data Message text if x_msg_count is 1.
434: *

Line 431: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

427: * x_cust_acct_profile_amt_id Customer account profile amount ID.
428: * x_return_status Return status after the call. The status can
429: * be FND_API.G_RET_STS_SUCCESS (success),
430: * FND_API.G_RET_STS_ERROR (error),
431: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
432: * x_msg_count Number of messages in message stack.
433: * x_msg_data Message text if x_msg_count is 1.
434: *
435: * NOTES

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

450: * @rep:businessevent oracle.apps.ar.hz.CustProfileAmt.create
451: * @rep:doccd 120hztig.pdf Customer Profile APIs, Oracle Trading Community Architecture Technical Implementation Guide
452: */
453: PROCEDURE create_cust_profile_amt (
454: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
455: p_check_foreign_key IN VARCHAR2 := FND_API.G_TRUE,
456: p_cust_profile_amt_rec IN CUST_PROFILE_AMT_REC_TYPE,
457: x_cust_acct_profile_amt_id OUT NOCOPY NUMBER,
458: x_return_status OUT NOCOPY VARCHAR2,

Line 455: p_check_foreign_key IN VARCHAR2 := FND_API.G_TRUE,

451: * @rep:doccd 120hztig.pdf Customer Profile APIs, Oracle Trading Community Architecture Technical Implementation Guide
452: */
453: PROCEDURE create_cust_profile_amt (
454: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
455: p_check_foreign_key IN VARCHAR2 := FND_API.G_TRUE,
456: p_cust_profile_amt_rec IN CUST_PROFILE_AMT_REC_TYPE,
457: x_cust_acct_profile_amt_id OUT NOCOPY NUMBER,
458: x_return_status OUT NOCOPY VARCHAR2,
459: x_msg_count OUT NOCOPY NUMBER,

Line 474: * FND_API.G_TRUE. Default is FND_API.G_FALSE.

470: *
471: * ARGUMENTS
472: * IN:
473: * p_init_msg_list Initialize message stack if it is set to
474: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
475: * p_cust_profile_amt_rec Customer profile amount record.
476: * IN/OUT:
477: * p_object_version_number Used for locking the being updated record.
478: * OUT:

Line 480: * be FND_API.G_RET_STS_SUCCESS (success),

476: * IN/OUT:
477: * p_object_version_number Used for locking the being updated record.
478: * OUT:
479: * x_return_status Return status after the call. The status can
480: * be FND_API.G_RET_STS_SUCCESS (success),
481: * FND_API.G_RET_STS_ERROR (error),
482: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
483: * x_msg_count Number of messages in message stack.
484: * x_msg_data Message text if x_msg_count is 1.

Line 481: * FND_API.G_RET_STS_ERROR (error),

477: * p_object_version_number Used for locking the being updated record.
478: * OUT:
479: * x_return_status Return status after the call. The status can
480: * be FND_API.G_RET_STS_SUCCESS (success),
481: * FND_API.G_RET_STS_ERROR (error),
482: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
483: * x_msg_count Number of messages in message stack.
484: * x_msg_data Message text if x_msg_count is 1.
485: *

Line 482: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

478: * OUT:
479: * x_return_status Return status after the call. The status can
480: * be FND_API.G_RET_STS_SUCCESS (success),
481: * FND_API.G_RET_STS_ERROR (error),
482: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
483: * x_msg_count Number of messages in message stack.
484: * x_msg_data Message text if x_msg_count is 1.
485: *
486: * NOTES

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

500: * @rep:businessevent oracle.apps.ar.hz.CustProfileAmt.update
501: * @rep:doccd 120hztig.pdf Customer Profile APIs, Oracle Trading Community Architecture Technical Implementation Guide
502: */
503: PROCEDURE update_cust_profile_amt (
504: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
505: p_cust_profile_amt_rec IN CUST_PROFILE_AMT_REC_TYPE,
506: p_object_version_number IN OUT NOCOPY NUMBER,
507: x_return_status OUT NOCOPY VARCHAR2,
508: x_msg_count OUT NOCOPY NUMBER,

Line 523: * FND_API.G_TRUE. Default is FND_API.G_FALSE.

519: *
520: * ARGUMENTS
521: * IN:
522: * p_init_msg_list Initialize message stack if it is set to
523: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
524: * p_cust_acct_profile_amt_id Customer account profile amount id.
525: * IN/OUT:
526: * OUT:
527: * x_cust_profile_amt_rec Returned customer profile amount record.

Line 529: * be FND_API.G_RET_STS_SUCCESS (success),

525: * IN/OUT:
526: * OUT:
527: * x_cust_profile_amt_rec Returned customer profile amount record.
528: * x_return_status Return status after the call. The status can
529: * be FND_API.G_RET_STS_SUCCESS (success),
530: * FND_API.G_RET_STS_ERROR (error),
531: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
532: * x_msg_count Number of messages in message stack.
533: * x_msg_data Message text if x_msg_count is 1.

Line 530: * FND_API.G_RET_STS_ERROR (error),

526: * OUT:
527: * x_cust_profile_amt_rec Returned customer profile amount record.
528: * x_return_status Return status after the call. The status can
529: * be FND_API.G_RET_STS_SUCCESS (success),
530: * FND_API.G_RET_STS_ERROR (error),
531: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
532: * x_msg_count Number of messages in message stack.
533: * x_msg_data Message text if x_msg_count is 1.
534: *

Line 531: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

527: * x_cust_profile_amt_rec Returned customer profile amount record.
528: * x_return_status Return status after the call. The status can
529: * be FND_API.G_RET_STS_SUCCESS (success),
530: * FND_API.G_RET_STS_ERROR (error),
531: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
532: * x_msg_count Number of messages in message stack.
533: * x_msg_data Message text if x_msg_count is 1.
534: *
535: * NOTES

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

540: *
541: */
542:
543: PROCEDURE get_cust_profile_amt_rec (
544: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
545: p_cust_acct_profile_amt_id IN NUMBER,
546: x_cust_profile_amt_rec OUT NOCOPY CUST_PROFILE_AMT_REC_TYPE,
547: x_return_status OUT NOCOPY VARCHAR2,
548: x_msg_count OUT NOCOPY NUMBER,