DBA Data[Home] [Help]

APPS.HZ_CUSTOMER_PROFILE_V2PUB dependencies on FND_API

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

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

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

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

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

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

Line 281: * FND_API.G_RET_STS_ERROR (error),

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

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

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

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

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

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

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

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

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

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

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

Line 335: * FND_API.G_RET_STS_ERROR (error),

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

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

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

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

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

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

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

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

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

Line 385: * FND_API.G_RET_STS_ERROR (error),

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

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

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

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

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

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

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

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

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

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

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

Line 429: * FND_API.G_RET_STS_ERROR (error),

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

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

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

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

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

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

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

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

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

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

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

Line 480: * FND_API.G_RET_STS_ERROR (error),

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

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

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

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

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

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

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

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

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

Line 529: * FND_API.G_RET_STS_ERROR (error),

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

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

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

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

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