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

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

262: * HZ_CUST_PROF_CLASS_AMTS_PKG.Select_Row
263: *
264: * ARGUMENTS
265: * IN:
266: * p_create_profile_amt If it is set to FND_API.G_TRUE, API create customer
267: * profile amounts by copying corresponding data
268: * from customer profile class amounts.
269: * IN/OUT:
270: * p_customer_profile_rec Customer profile record. One customer account

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

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: * x_return_status Return status after the call. The status can
274: * be FND_API.G_RET_STS_SUCCESS (success),
275: * FND_API.G_RET_STS_ERROR (error),
276: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
277: * OUT:
278: * x_cust_account_profile_id Customer account profile ID.

Line 275: * FND_API.G_RET_STS_ERROR (error),

271: * must have a customer profile. One account site
272: * use can optionally have one customer profile.
273: * x_return_status Return status after the call. The status can
274: * be FND_API.G_RET_STS_SUCCESS (success),
275: * FND_API.G_RET_STS_ERROR (error),
276: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
277: * OUT:
278: * x_cust_account_profile_id Customer account profile ID.
279: *

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

272: * use can optionally have one customer profile.
273: * x_return_status Return status after the call. The status can
274: * be FND_API.G_RET_STS_SUCCESS (success),
275: * FND_API.G_RET_STS_ERROR (error),
276: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
277: * OUT:
278: * x_cust_account_profile_id Customer account profile ID.
279: *
280: * NOTES

Line 351: p_customer_profile_rec.profile_class_id = FND_API.G_MISS_NUM

347: END IF;
348:
349: -- Default profile_class_id.
350: IF p_customer_profile_rec.profile_class_id IS NULL OR
351: p_customer_profile_rec.profile_class_id = FND_API.G_MISS_NUM
352: THEN
353: BEGIN
354: SELECT STATUS, NAME INTO l_status, l_profile_class_name
355: FROM HZ_CUST_PROFILE_CLASSES

Line 362: RAISE FND_API.G_EXC_ERROR;

358: IF l_status = 'I' THEN
359: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INACTIVE_PROFILE_CLASS' );
360: FND_MESSAGE.SET_TOKEN( 'NAME', l_profile_class_name );
361: FND_MSG_PUB.ADD;
362: RAISE FND_API.G_EXC_ERROR;
363: END IF;
364:
365: -- Setup profile_class_id.
366: p_customer_profile_rec.profile_class_id := 0;

Line 372: RAISE FND_API.G_EXC_ERROR;

368: EXCEPTION
369: WHEN NO_DATA_FOUND THEN
370: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_DEFAULT_PROF_CLASS' );
371: FND_MSG_PUB.ADD;
372: RAISE FND_API.G_EXC_ERROR;
373: END;
374: END IF;
375:
376: -- Debug info.

Line 401: p_customer_profile_rec.party_id = FND_API.G_MISS_NUM )

397: -- party_id must be active
398: -- cust_account_id and party_id must be associated in hz_cust_accounts.
399: --
400: IF ( p_customer_profile_rec.party_id IS NULL OR
401: p_customer_profile_rec.party_id = FND_API.G_MISS_NUM )
402: THEN
403:
404: IF ( p_customer_profile_rec.cust_account_id IS NULL OR
405: p_customer_profile_rec.cust_account_id = FND_API.G_MISS_NUM )

Line 405: p_customer_profile_rec.cust_account_id = FND_API.G_MISS_NUM )

401: p_customer_profile_rec.party_id = FND_API.G_MISS_NUM )
402: THEN
403:
404: IF ( p_customer_profile_rec.cust_account_id IS NULL OR
405: p_customer_profile_rec.cust_account_id = FND_API.G_MISS_NUM )
406: THEN
407: FND_MESSAGE.SET_NAME('AR','HZ_API_CF_ASS_PTY_OR_ACCT');
408: FND_MSG_PUB.ADD;
409: x_return_status := FND_API.G_RET_STS_ERROR;

Line 409: x_return_status := FND_API.G_RET_STS_ERROR;

405: p_customer_profile_rec.cust_account_id = FND_API.G_MISS_NUM )
406: THEN
407: FND_MESSAGE.SET_NAME('AR','HZ_API_CF_ASS_PTY_OR_ACCT');
408: FND_MSG_PUB.ADD;
409: x_return_status := FND_API.G_RET_STS_ERROR;
410: ELSE
411: l_party_id := party_id_value(p_customer_profile_rec.cust_account_id, 'A');
412: IF l_party_id = -99999 THEN
413: FND_MESSAGE.SET_NAME('AR','HZ_API_NO_A_PTY_ASS_ACCT');

Line 416: x_return_status := FND_API.G_RET_STS_ERROR;

412: IF l_party_id = -99999 THEN
413: FND_MESSAGE.SET_NAME('AR','HZ_API_NO_A_PTY_ASS_ACCT');
414: FND_MESSAGE.SET_TOKEN('ACCT_ID',p_customer_profile_rec.cust_account_id);
415: FND_MSG_PUB.ADD;
416: x_return_status := FND_API.G_RET_STS_ERROR;
417: END IF;
418: p_customer_profile_rec.party_id := l_party_id;
419: END IF;
420:

Line 427: x_return_status := FND_API.G_RET_STS_ERROR;

423: IF party_exist( p_customer_profile_rec.party_id, 'A' ) <> 'Y' THEN
424: FND_MESSAGE.SET_NAME('AR','HZ_API_NO_A_PTY');
425: FND_MESSAGE.SET_TOKEN( 'PARTY_ID', p_customer_profile_rec.party_id);
426: FND_MSG_PUB.ADD;
427: x_return_status := FND_API.G_RET_STS_ERROR;
428: END IF;
429:
430: IF ( p_customer_profile_rec.cust_account_id IS NULL OR
431: p_customer_profile_rec.cust_account_id = FND_API.G_MISS_NUM )

Line 431: p_customer_profile_rec.cust_account_id = FND_API.G_MISS_NUM )

427: x_return_status := FND_API.G_RET_STS_ERROR;
428: END IF;
429:
430: IF ( p_customer_profile_rec.cust_account_id IS NULL OR
431: p_customer_profile_rec.cust_account_id = FND_API.G_MISS_NUM )
432: THEN
433: p_customer_profile_rec.cust_account_id := -1;
434: ELSE
435: IF party_id_value(p_customer_profile_rec.cust_account_id, 'A')

Line 442: x_return_status := FND_API.G_RET_STS_ERROR;

438: FND_MESSAGE.SET_NAME('AR','HZ_API_ACCT_NOT_ASS_PTY');
439: FND_MESSAGE.SET_TOKEN( 'ACCT_ID', p_customer_profile_rec.cust_account_id );
440: FND_MESSAGE.SET_TOKEN( 'PARTY_ID', p_customer_profile_rec.party_id);
441: FND_MSG_PUB.ADD;
442: x_return_status := FND_API.G_RET_STS_ERROR;
443: END IF;
444: END IF;
445:
446: END IF;

Line 463: RAISE FND_API.G_EXC_ERROR;

459: FND_MESSAGE.SET_TOKEN( 'RECORD', 'Customer Profile Class' );
460: FND_MESSAGE.SET_TOKEN( 'VALUE',
461: NVL( TO_CHAR( p_customer_profile_rec.profile_class_id ), 'null' ) );
462: FND_MSG_PUB.ADD;
463: RAISE FND_API.G_EXC_ERROR;
464: END;
465: -- if cons_inv_flag is NULL, get it defaulted from profile class
466: -- if it is still NULL, assign it as 'N'
467: if p_customer_profile_rec.cons_inv_flag is NULl then

Line 489: x_return_status := FND_API.G_RET_STS_ERROR;

485: /*
486: if p_customer_profile_rec.cons_bill_level is NOT NULL then
487: FND_MESSAGE.SET_NAME('AR', 'HZ_API_SITE_BILL_LVL_NULL');
488: FND_MSG_PUB.ADD;
489: x_return_status := FND_API.G_RET_STS_ERROR;
490: end if;
491: */
492: OPEN c_acct_use_profile_dtls;
493: FETCH c_acct_use_profile_dtls INTO l_cons_bill_level, l_cons_inv_type;

Line 497: x_return_status := FND_API.G_RET_STS_ERROR;

493: FETCH c_acct_use_profile_dtls INTO l_cons_bill_level, l_cons_inv_type;
494: IF c_acct_use_profile_dtls%NOTFOUND THEN
495: FND_MESSAGE.SET_NAME('AR', 'HZ_API_ENABLE_ACC_BAL_FWD_BILL');
496: FND_MSG_PUB.ADD;
497: x_return_status := FND_API.G_RET_STS_ERROR;
498: END IF;
499: p_customer_profile_rec.cons_bill_level := l_cons_bill_level;
500: if p_customer_profile_rec.cons_inv_type is NULL then
501: p_customer_profile_rec.cons_inv_type := l_cons_inv_type;

Line 550: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

546: p_customer_profile_rec => p_customer_profile_rec,
547: p_rowid => NULL,
548: x_return_status => x_return_status );
549:
550: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
551: RAISE FND_API.G_EXC_ERROR;
552: END IF;
553:
554: -- Added rounding of payment_grace_days to integer for Late charge project.

Line 551: RAISE FND_API.G_EXC_ERROR;

547: p_rowid => NULL,
548: x_return_status => x_return_status );
549:
550: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
551: RAISE FND_API.G_EXC_ERROR;
552: END IF;
553:
554: -- Added rounding of payment_grace_days to integer for Late charge project.
555: IF p_customer_profile_rec.payment_grace_days is NOT NULL then

Line 589: p_init_msg_list => FND_API.G_FALSE,

585:
586: BEGIN
587: OE_Holds_PUB.Process_Holds (
588: p_api_version => 1.0,
589: p_init_msg_list => FND_API.G_FALSE,
590: p_hold_entity_code => v_entity_code,
591: p_hold_entity_id => v_entity_id,
592: p_hold_id => 1,
593: p_release_reason_code => 'AR_AUTOMATIC',

Line 622: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

618: --We should remove the code where they are suppressing the error being raise
619: --by OM code. TCA team should always pass on the error message back to the user
620: --/ UI / calling API, so that they will know that an error has occurred in OM
621: -- l_return_status := 'S';
622: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
623:
624: END;
625:
626: --

Line 629: --Added FND_API.G_EXC_ERROR

625:
626: --
627: -- only raise unexpected error
628: --Bug14059649
629: --Added FND_API.G_EXC_ERROR
630: --We should remove the code where they are suppressing the error being raise
631: --by OM code. TCA team should always pass on the error message back to the user
632: --/ UI / calling API, so that they will know that an error has occurred in OM
633: --

Line 634: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

630: --We should remove the code where they are suppressing the error being raise
631: --by OM code. TCA team should always pass on the error message back to the user
632: --/ UI / calling API, so that they will know that an error has occurred in OM
633: --
634: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
635: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
636: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
637: RAISE FND_API.G_EXC_ERROR;
638: END IF;

Line 635: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

631: --by OM code. TCA team should always pass on the error message back to the user
632: --/ UI / calling API, so that they will know that an error has occurred in OM
633: --
634: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
635: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
636: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
637: RAISE FND_API.G_EXC_ERROR;
638: END IF;
639: END IF;

Line 636: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

632: --/ UI / calling API, so that they will know that an error has occurred in OM
633: --
634: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
635: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
636: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
637: RAISE FND_API.G_EXC_ERROR;
638: END IF;
639: END IF;
640:

Line 637: RAISE FND_API.G_EXC_ERROR;

633: --
634: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
635: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
636: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
637: RAISE FND_API.G_EXC_ERROR;
638: END IF;
639: END IF;
640:
641: -- Call table-handler.

Line 778: IF p_create_profile_amt = FND_API.G_FALSE THEN

774:
775: -- Now default in the profile amounts only if
776: -- p_create_profile_amt is TRUE. Otherwise, simply return.
777:
778: IF p_create_profile_amt = FND_API.G_FALSE THEN
779: RETURN;
780: END IF;
781:
782: BEGIN

Line 924: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

920: l_msg_count,
921: l_msg_data );
922: END IF;
923:
924: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
925: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
926: RAISE FND_API.G_EXC_ERROR;
927: ELSE
928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 925: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

921: l_msg_data );
922: END IF;
923:
924: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
925: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
926: RAISE FND_API.G_EXC_ERROR;
927: ELSE
928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
929: END IF;

Line 926: RAISE FND_API.G_EXC_ERROR;

922: END IF;
923:
924: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
925: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
926: RAISE FND_API.G_EXC_ERROR;
927: ELSE
928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
929: END IF;
930: END IF;

Line 928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

924: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
925: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
926: RAISE FND_API.G_EXC_ERROR;
927: ELSE
928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
929: END IF;
930: END IF;
931:
932: END LOOP;

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

968: * must have a customer profile. One account site
969: * use can optionally have one customer profile.
970: * p_object_version_number Used for locking the being updated record.
971: * x_return_status Return status after the call. The status can
972: * be FND_API.G_RET_STS_SUCCESS (success),
973: * FND_API.G_RET_STS_ERROR (error),
974: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
975: *
976: * NOTES

Line 973: * FND_API.G_RET_STS_ERROR (error),

969: * use can optionally have one customer profile.
970: * p_object_version_number Used for locking the being updated record.
971: * x_return_status Return status after the call. The status can
972: * be FND_API.G_RET_STS_SUCCESS (success),
973: * FND_API.G_RET_STS_ERROR (error),
974: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
975: *
976: * NOTES
977: *

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

970: * p_object_version_number Used for locking the being updated record.
971: * x_return_status Return status after the call. The status can
972: * be FND_API.G_RET_STS_SUCCESS (success),
973: * FND_API.G_RET_STS_ERROR (error),
974: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
975: *
976: * NOTES
977: *
978: * MODIFICATION HISTORY

Line 1077: RAISE FND_API.G_EXC_ERROR;

1073: THEN
1074: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_RECORD_CHANGED' );
1075: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_customer_profiles' );
1076: FND_MSG_PUB.ADD;
1077: RAISE FND_API.G_EXC_ERROR;
1078: END IF;
1079:
1080: p_object_version_number := NVL( l_object_version_number, 1 ) + 1;
1081:

Line 1089: RAISE FND_API.G_EXC_ERROR;

1085: FND_MESSAGE.SET_TOKEN( 'RECORD', 'customer profile' );
1086: FND_MESSAGE.SET_TOKEN( 'VALUE',
1087: NVL( TO_CHAR( p_customer_profile_rec.cust_account_profile_id ), 'null' ) );
1088: FND_MSG_PUB.ADD;
1089: RAISE FND_API.G_EXC_ERROR;
1090: END;
1091:
1092: l_profile_class_changed := 'N';
1093: -- Bug 9188425 -Exception block is added to handle invalid Profile Class Id.

Line 1097: p_customer_profile_rec.profile_class_id <> FND_API.G_MISS_NUM AND

1093: -- Bug 9188425 -Exception block is added to handle invalid Profile Class Id.
1094: BEGIN
1095: -- If the profile_class_id is changed get profile class rec into l_profile_class_rec
1096: IF (p_customer_profile_rec.profile_class_id IS NOT NULL AND
1097: p_customer_profile_rec.profile_class_id <> FND_API.G_MISS_NUM AND
1098: p_customer_profile_rec.profile_class_id <> NVL(l_profile_class_id, FND_API.G_MISS_NUM)) then
1099:
1100: l_profile_class_changed := 'Y';
1101:

Line 1098: p_customer_profile_rec.profile_class_id <> NVL(l_profile_class_id, FND_API.G_MISS_NUM)) then

1094: BEGIN
1095: -- If the profile_class_id is changed get profile class rec into l_profile_class_rec
1096: IF (p_customer_profile_rec.profile_class_id IS NOT NULL AND
1097: p_customer_profile_rec.profile_class_id <> FND_API.G_MISS_NUM AND
1098: p_customer_profile_rec.profile_class_id <> NVL(l_profile_class_id, FND_API.G_MISS_NUM)) then
1099:
1100: l_profile_class_changed := 'Y';
1101:
1102: SELECT * INTO l_profile_class_rec

Line 1110: p_customer_profile_rec.cons_inv_flag = FND_API.G_MISS_CHAR) then

1106: -- While changing the profile class for an existing cusromer profile record
1107: -- it should do the validations based on the new input parameters.
1108: -- If the input parameters are passed NULL or G_MISS, get the value from profile class.
1109: if ( p_customer_profile_rec.cons_inv_flag is NULL OR
1110: p_customer_profile_rec.cons_inv_flag = FND_API.G_MISS_CHAR) then
1111: p_customer_profile_rec.cons_inv_flag := l_profile_class_rec.cons_inv_flag;
1112: end if;
1113: if ( p_customer_profile_rec.cons_bill_level is NULL OR
1114: p_customer_profile_rec.cons_bill_level = FND_API.G_MISS_CHAR) then

Line 1114: p_customer_profile_rec.cons_bill_level = FND_API.G_MISS_CHAR) then

1110: p_customer_profile_rec.cons_inv_flag = FND_API.G_MISS_CHAR) then
1111: p_customer_profile_rec.cons_inv_flag := l_profile_class_rec.cons_inv_flag;
1112: end if;
1113: if ( p_customer_profile_rec.cons_bill_level is NULL OR
1114: p_customer_profile_rec.cons_bill_level = FND_API.G_MISS_CHAR) then
1115: p_customer_profile_rec.cons_bill_level := l_profile_class_rec.cons_bill_level;
1116: end if;
1117: if ( p_customer_profile_rec.cons_inv_type is NULL OR
1118: p_customer_profile_rec.cons_inv_type = FND_API.G_MISS_CHAR) then

Line 1118: p_customer_profile_rec.cons_inv_type = FND_API.G_MISS_CHAR) then

1114: p_customer_profile_rec.cons_bill_level = FND_API.G_MISS_CHAR) then
1115: p_customer_profile_rec.cons_bill_level := l_profile_class_rec.cons_bill_level;
1116: end if;
1117: if ( p_customer_profile_rec.cons_inv_type is NULL OR
1118: p_customer_profile_rec.cons_inv_type = FND_API.G_MISS_CHAR) then
1119: p_customer_profile_rec.cons_inv_type := l_profile_class_rec.cons_inv_type;
1120: end if;
1121: if ( p_customer_profile_rec.standard_terms is NULL OR
1122: p_customer_profile_rec.standard_terms = FND_API.G_MISS_NUM) then

Line 1122: p_customer_profile_rec.standard_terms = FND_API.G_MISS_NUM) then

1118: p_customer_profile_rec.cons_inv_type = FND_API.G_MISS_CHAR) then
1119: p_customer_profile_rec.cons_inv_type := l_profile_class_rec.cons_inv_type;
1120: end if;
1121: if ( p_customer_profile_rec.standard_terms is NULL OR
1122: p_customer_profile_rec.standard_terms = FND_API.G_MISS_NUM) then
1123: p_customer_profile_rec.standard_terms := l_profile_class_rec.standard_terms;
1124: end if;
1125: --Bug9151634,9197547
1126: --Assigning Profile Class's value.

Line 1128: p_customer_profile_rec.review_cycle = FND_API.G_MISS_CHAR) then

1124: end if;
1125: --Bug9151634,9197547
1126: --Assigning Profile Class's value.
1127: if ( p_customer_profile_rec.review_cycle is NULL OR
1128: p_customer_profile_rec.review_cycle = FND_API.G_MISS_CHAR) then
1129: p_customer_profile_rec.review_cycle := l_profile_class_rec.review_cycle;
1130: end if;
1131: END IF;
1132: EXCEPTION

Line 1139: RAISE FND_API.G_EXC_ERROR;

1135: FND_MESSAGE.SET_TOKEN( 'RECORD', 'Customer Profile Class' );
1136: FND_MESSAGE.SET_TOKEN( 'VALUE',
1137: NVL( TO_CHAR( p_customer_profile_rec.profile_class_id ), 'null' ) );
1138: FND_MSG_PUB.ADD;
1139: RAISE FND_API.G_EXC_ERROR;
1140: END;
1141: -- Value for cons_inv_flag should be Y or N
1142: if p_customer_profile_rec.cons_inv_flag is NULL then
1143: p_customer_profile_rec.cons_inv_flag := l_cons_inv_flag;

Line 1144: elsif p_customer_profile_rec.cons_inv_flag = FND_API.G_MISS_CHAR then

1140: END;
1141: -- Value for cons_inv_flag should be Y or N
1142: if p_customer_profile_rec.cons_inv_flag is NULL then
1143: p_customer_profile_rec.cons_inv_flag := l_cons_inv_flag;
1144: elsif p_customer_profile_rec.cons_inv_flag = FND_API.G_MISS_CHAR then
1145: p_customer_profile_rec.cons_inv_flag := 'N';
1146: end if;
1147:
1148: -- If user passes NULL in update set value as in database

Line 1155: p_customer_profile_rec.cons_bill_level := FND_API.G_MISS_CHAR;

1151: end if;
1152:
1153: -- if cons_inv_flag is 'N', make cons_bill_level and cons_inv_type to NULL
1154: if p_customer_profile_rec.cons_inv_flag = 'N' then
1155: p_customer_profile_rec.cons_bill_level := FND_API.G_MISS_CHAR;
1156: p_customer_profile_rec.cons_inv_type := FND_API.G_MISS_CHAR;
1157: end if;
1158:
1159: -- Bill level is non updatable at site level

Line 1156: p_customer_profile_rec.cons_inv_type := FND_API.G_MISS_CHAR;

1152:
1153: -- if cons_inv_flag is 'N', make cons_bill_level and cons_inv_type to NULL
1154: if p_customer_profile_rec.cons_inv_flag = 'N' then
1155: p_customer_profile_rec.cons_bill_level := FND_API.G_MISS_CHAR;
1156: p_customer_profile_rec.cons_inv_type := FND_API.G_MISS_CHAR;
1157: end if;
1158:
1159: -- Bill level is non updatable at site level
1160: /*

Line 1162: p_customer_profile_rec.cons_bill_level <> FND_API.G_MISS_CHAR AND

1158:
1159: -- Bill level is non updatable at site level
1160: /*
1161: if l_site_use_id is NOT NULL AND
1162: p_customer_profile_rec.cons_bill_level <> FND_API.G_MISS_CHAR AND
1163: p_customer_profile_rec.cons_bill_level <> NVL(l_cons_bill_level, FND_API.G_MISS_CHAR) then
1164: FND_MESSAGE.SET_NAME('AR', 'HZ_API_SITE_BILL_LVL_NULL');
1165: FND_MSG_PUB.ADD;
1166: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1163: p_customer_profile_rec.cons_bill_level <> NVL(l_cons_bill_level, FND_API.G_MISS_CHAR) then

1159: -- Bill level is non updatable at site level
1160: /*
1161: if l_site_use_id is NOT NULL AND
1162: p_customer_profile_rec.cons_bill_level <> FND_API.G_MISS_CHAR AND
1163: p_customer_profile_rec.cons_bill_level <> NVL(l_cons_bill_level, FND_API.G_MISS_CHAR) then
1164: FND_MESSAGE.SET_NAME('AR', 'HZ_API_SITE_BILL_LVL_NULL');
1165: FND_MSG_PUB.ADD;
1166: x_return_status := FND_API.G_RET_STS_ERROR;
1167: end if;

Line 1166: x_return_status := FND_API.G_RET_STS_ERROR;

1162: p_customer_profile_rec.cons_bill_level <> FND_API.G_MISS_CHAR AND
1163: p_customer_profile_rec.cons_bill_level <> NVL(l_cons_bill_level, FND_API.G_MISS_CHAR) then
1164: FND_MESSAGE.SET_NAME('AR', 'HZ_API_SITE_BILL_LVL_NULL');
1165: FND_MSG_PUB.ADD;
1166: x_return_status := FND_API.G_RET_STS_ERROR;
1167: end if;
1168: */
1169:
1170: -- if cons_inv_flag is changed from N to Y for a site level,

Line 1182: x_return_status := FND_API.G_RET_STS_ERROR;

1178: FETCH c_acct_use_profile_dtls INTO ll_cons_bill_level, ll_cons_inv_type;
1179: IF c_acct_use_profile_dtls%NOTFOUND THEN
1180: FND_MESSAGE.SET_NAME('AR', 'HZ_API_ENABLE_ACC_BAL_FWD_BILL');
1181: FND_MSG_PUB.ADD;
1182: x_return_status := FND_API.G_RET_STS_ERROR;
1183: END IF;
1184: p_customer_profile_rec.cons_bill_level := ll_cons_bill_level;
1185: if ( p_customer_profile_rec.cons_inv_type is NULL OR
1186: p_customer_profile_rec.cons_inv_type = FND_API.G_MISS_CHAR) then

Line 1186: p_customer_profile_rec.cons_inv_type = FND_API.G_MISS_CHAR) then

1182: x_return_status := FND_API.G_RET_STS_ERROR;
1183: END IF;
1184: p_customer_profile_rec.cons_bill_level := ll_cons_bill_level;
1185: if ( p_customer_profile_rec.cons_inv_type is NULL OR
1186: p_customer_profile_rec.cons_inv_type = FND_API.G_MISS_CHAR) then
1187: p_customer_profile_rec.cons_inv_type := ll_cons_inv_type;
1188: end if;
1189: CLOSE c_acct_use_profile_dtls;
1190: end if;

Line 1203: p_customer_profile_rec.cons_inv_flag <> FND_API.G_MISS_CHAR AND

1199: -- and profile class is not changed
1200: -- update the standard_terms of the profile to null
1201: -- Bug 8349169 -In NVL function G_MISS_CHAR changed to 'N', null will consider as 'N'
1202: if p_customer_profile_rec.cons_inv_flag IS NOT NULL AND
1203: p_customer_profile_rec.cons_inv_flag <> FND_API.G_MISS_CHAR AND
1204: p_customer_profile_rec.cons_inv_flag <> NVL(l_cons_inv_flag, 'N') AND
1205: l_profile_class_changed = 'N' then
1206: if (p_customer_profile_rec.standard_terms is NULL OR
1207: p_customer_profile_rec.standard_terms = nvl(l_standard_terms,-999111))

Line 1210: p_customer_profile_rec.standard_terms := FND_API.G_MISS_NUM;

1206: if (p_customer_profile_rec.standard_terms is NULL OR
1207: p_customer_profile_rec.standard_terms = nvl(l_standard_terms,-999111))
1208: then
1209: --l_standard_terms
1210: p_customer_profile_rec.standard_terms := FND_API.G_MISS_NUM;
1211: end if;
1212: end if;
1213:
1214: -- if late charge payment term or late charge type or message_text_id is NULL, get value from database.

Line 1217: elsif p_customer_profile_rec.late_charge_term_id = FND_API.G_MISS_NUM then

1213:
1214: -- if late charge payment term or late charge type or message_text_id is NULL, get value from database.
1215: if p_customer_profile_rec.late_charge_term_id is NULL then
1216: p_customer_profile_rec.late_charge_term_id := l_late_charge_term_id;
1217: elsif p_customer_profile_rec.late_charge_term_id = FND_API.G_MISS_NUM then
1218: p_customer_profile_rec.late_charge_term_id := l_profile_class_rec.late_charge_term_id;
1219: end if;
1220: if p_customer_profile_rec.late_charge_type is NULL then
1221: p_customer_profile_rec.late_charge_type := l_late_charge_type;

Line 1222: elsif p_customer_profile_rec.late_charge_type = FND_API.G_MISS_CHAR then

1218: p_customer_profile_rec.late_charge_term_id := l_profile_class_rec.late_charge_term_id;
1219: end if;
1220: if p_customer_profile_rec.late_charge_type is NULL then
1221: p_customer_profile_rec.late_charge_type := l_late_charge_type;
1222: elsif p_customer_profile_rec.late_charge_type = FND_API.G_MISS_CHAR then
1223: p_customer_profile_rec.late_charge_type := l_profile_class_rec.late_charge_type;
1224: end if;
1225: if p_customer_profile_rec.message_text_id is NULL then
1226: p_customer_profile_rec.message_text_id := l_message_text_id;

Line 1227: elsif p_customer_profile_rec.message_text_id = FND_API.G_MISS_NUM then

1223: p_customer_profile_rec.late_charge_type := l_profile_class_rec.late_charge_type;
1224: end if;
1225: if p_customer_profile_rec.message_text_id is NULL then
1226: p_customer_profile_rec.message_text_id := l_message_text_id;
1227: elsif p_customer_profile_rec.message_text_id = FND_API.G_MISS_NUM then
1228: p_customer_profile_rec.message_text_id := l_profile_class_rec.message_text_id;
1229: end if;
1230:
1231: if p_customer_profile_rec.late_charge_type = 'ADJ' then

Line 1232: p_customer_profile_rec.late_charge_term_id := FND_API.G_MISS_NUM;

1228: p_customer_profile_rec.message_text_id := l_profile_class_rec.message_text_id;
1229: end if;
1230:
1231: if p_customer_profile_rec.late_charge_type = 'ADJ' then
1232: p_customer_profile_rec.late_charge_term_id := FND_API.G_MISS_NUM;
1233: p_customer_profile_rec.message_text_id := FND_API.G_MISS_NUM;
1234: end if;
1235:
1236: -- Validate customer profile record

Line 1233: p_customer_profile_rec.message_text_id := FND_API.G_MISS_NUM;

1229: end if;
1230:
1231: if p_customer_profile_rec.late_charge_type = 'ADJ' then
1232: p_customer_profile_rec.late_charge_term_id := FND_API.G_MISS_NUM;
1233: p_customer_profile_rec.message_text_id := FND_API.G_MISS_NUM;
1234: end if;
1235:
1236: -- Validate customer profile record
1237: HZ_ACCOUNT_VALIDATE_V2PUB.validate_customer_profile (

Line 1243: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1239: p_customer_profile_rec => p_customer_profile_rec,
1240: p_rowid => l_rowid,
1241: x_return_status => x_return_status );
1242:
1243: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1244: RAISE FND_API.G_EXC_ERROR;
1245: END IF;
1246:
1247: -- Added rounding of payment_grace_days to integer for Late charge project.

Line 1244: RAISE FND_API.G_EXC_ERROR;

1240: p_rowid => l_rowid,
1241: x_return_status => x_return_status );
1242:
1243: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1244: RAISE FND_API.G_EXC_ERROR;
1245: END IF;
1246:
1247: -- Added rounding of payment_grace_days to integer for Late charge project.
1248: IF (p_customer_profile_rec.payment_grace_days is NOT NULL AND

Line 1249: p_customer_profile_rec.payment_grace_days <> FND_API.G_MISS_NUM) then

1245: END IF;
1246:
1247: -- Added rounding of payment_grace_days to integer for Late charge project.
1248: IF (p_customer_profile_rec.payment_grace_days is NOT NULL AND
1249: p_customer_profile_rec.payment_grace_days <> FND_API.G_MISS_NUM) then
1250: p_customer_profile_rec.payment_grace_days := ROUND(p_customer_profile_rec.payment_grace_days,0);
1251: END IF;
1252:
1253: -- Added rounding of interest_period_days to integer for Late charge project.

Line 1255: p_customer_profile_rec.interest_period_days <> FND_API.G_MISS_NUM) then

1251: END IF;
1252:
1253: -- Added rounding of interest_period_days to integer for Late charge project.
1254: IF (p_customer_profile_rec.interest_period_days is NOT NULL AND
1255: p_customer_profile_rec.interest_period_days <> FND_API.G_MISS_NUM) then
1256: p_customer_profile_rec.interest_period_days := ROUND(p_customer_profile_rec.interest_period_days,0);
1257: END IF;
1258:
1259: -- Add logic for global holds

Line 1288: p_init_msg_list => FND_API.G_FALSE,

1284:
1285: BEGIN
1286: OE_Holds_PUB.Process_Holds (
1287: p_api_version => 1.0,
1288: p_init_msg_list => FND_API.G_FALSE,
1289: p_hold_entity_code => v_entity_code,
1290: p_hold_entity_id => v_entity_id,
1291: p_hold_id => 1,
1292: p_release_reason_code => 'AR_AUTOMATIC',

Line 1321: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1317: --We should remove the code where they are suppressing the error being raise
1318: --by OM code. TCA team should always pass on the error message back to the user
1319: --/ UI / calling API, so that they will know that an error has occurred in OM
1320: -- l_return_status := 'S';
1321: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1322: END;
1323:
1324: --
1325: -- only raise unexpected error

Line 1327: --Added FND_API.G_EXC_ERROR

1323:
1324: --
1325: -- only raise unexpected error
1326: --Bug14059649
1327: --Added FND_API.G_EXC_ERROR
1328: --We should remove the code where they are suppressing the error being raise
1329: --by OM code. TCA team should always pass on the error message back to the user
1330: --/ UI / calling API, so that they will know that an error has occurred in OM
1331: --

Line 1332: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1328: --We should remove the code where they are suppressing the error being raise
1329: --by OM code. TCA team should always pass on the error message back to the user
1330: --/ UI / calling API, so that they will know that an error has occurred in OM
1331: --
1332: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1334: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1335: RAISE FND_API.G_EXC_ERROR;
1336: END IF;

Line 1333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1329: --by OM code. TCA team should always pass on the error message back to the user
1330: --/ UI / calling API, so that they will know that an error has occurred in OM
1331: --
1332: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1334: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1335: RAISE FND_API.G_EXC_ERROR;
1336: END IF;
1337: END IF;

Line 1334: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1330: --/ UI / calling API, so that they will know that an error has occurred in OM
1331: --
1332: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1334: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1335: RAISE FND_API.G_EXC_ERROR;
1336: END IF;
1337: END IF;
1338: END IF; -- Bug 5606895

Line 1335: RAISE FND_API.G_EXC_ERROR;

1331: --
1332: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1334: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1335: RAISE FND_API.G_EXC_ERROR;
1336: END IF;
1337: END IF;
1338: END IF; -- Bug 5606895
1339: -- Call table-handler.

Line 1650: and p_customer_profile_rec.created_by_module <> fnd_api.g_miss_char THEN

1646: -- The currency does not exist, create new amount
1647: l_cust_profile_amt_rec.cust_acct_profile_amt_id := NULL;
1648:
1649: IF p_customer_profile_rec.created_by_module IS NOT NULL
1650: and p_customer_profile_rec.created_by_module <> fnd_api.g_miss_char THEN
1651: l_cust_profile_amt_rec.created_by_module := p_customer_profile_rec.created_by_module;
1652: ELSE
1653: -- if l_created_by_module is null, default to TCA_V2_API
1654: l_cust_profile_amt_rec.created_by_module := nvl(l_created_by_module, 'TCA_V2_API');

Line 1684: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1680: l_msg_data );
1681: END IF;
1682:
1683:
1684: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1685: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1686: RAISE FND_API.G_EXC_ERROR;
1687: ELSE
1688: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1685: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1681: END IF;
1682:
1683:
1684: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1685: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1686: RAISE FND_API.G_EXC_ERROR;
1687: ELSE
1688: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1689: END IF;

Line 1686: RAISE FND_API.G_EXC_ERROR;

1682:
1683:
1684: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1685: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1686: RAISE FND_API.G_EXC_ERROR;
1687: ELSE
1688: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1689: END IF;
1690: END IF;

Line 1688: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1684: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1685: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1686: RAISE FND_API.G_EXC_ERROR;
1687: ELSE
1688: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1689: END IF;
1690: END IF;
1691:
1692: END LOOP;

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

1724: * ARGUMENTS
1725: * IN:
1726: * p_check_foreign_key If do foreign key checking on cust_account_id
1727: * and cust_account_profile_id or not. Defaut value
1728: * is FND_API.G_TRUE, which means API will do foreign
1729: * key checking on these 2 columns.
1730: * IN/OUT:
1731: * p_cust_profile_amt_rec Customer profile amount record.
1732: * x_return_status Return status after the call. The status can

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

1729: * key checking on these 2 columns.
1730: * IN/OUT:
1731: * p_cust_profile_amt_rec Customer profile amount record.
1732: * x_return_status Return status after the call. The status can
1733: * be FND_API.G_RET_STS_SUCCESS (success),
1734: * FND_API.G_RET_STS_ERROR (error),
1735: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1736: * OUT:
1737: * x_cust_acct_profile_amt_id Customer account profile amount ID.

Line 1734: * FND_API.G_RET_STS_ERROR (error),

1730: * IN/OUT:
1731: * p_cust_profile_amt_rec Customer profile amount record.
1732: * x_return_status Return status after the call. The status can
1733: * be FND_API.G_RET_STS_SUCCESS (success),
1734: * FND_API.G_RET_STS_ERROR (error),
1735: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1736: * OUT:
1737: * x_cust_acct_profile_amt_id Customer account profile amount ID.
1738: *

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

1731: * p_cust_profile_amt_rec Customer profile amount record.
1732: * x_return_status Return status after the call. The status can
1733: * be FND_API.G_RET_STS_SUCCESS (success),
1734: * FND_API.G_RET_STS_ERROR (error),
1735: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1736: * OUT:
1737: * x_cust_acct_profile_amt_id Customer account profile amount ID.
1738: *
1739: * NOTES

Line 1773: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1769: p_cust_profile_amt_rec => p_cust_profile_amt_rec,
1770: p_rowid => NULL,
1771: x_return_status => x_return_status );
1772:
1773: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1774: RAISE FND_API.G_EXC_ERROR;
1775: END IF;
1776:
1777: -- Added rounding of min_fc_invoice_amount, min_fc_balance_amount, min_interest_charge,

Line 1774: RAISE FND_API.G_EXC_ERROR;

1770: p_rowid => NULL,
1771: x_return_status => x_return_status );
1772:
1773: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1774: RAISE FND_API.G_EXC_ERROR;
1775: END IF;
1776:
1777: -- Added rounding of min_fc_invoice_amount, min_fc_balance_amount, min_interest_charge,
1778: -- min_interest_charge, interest_fixed_amount and penalty_fixed_amount to 2 decimal places for Late charge project.

Line 1809: IF p_cust_profile_amt_rec.site_use_id IS NULL OR p_CUST_PROFILE_AMT_REC.site_use_id = FND_API.G_MISS_NUM THEN

1805: -- Bug 6472676
1806: -- Changed do_create_cust_profile_amt Procudure to get SITE_USE_ID value from Customer Profiles if
1807: -- Parameter CUST_PROFILE_AMT_REC containing null value in SITE_USE_ID.
1808:
1809: IF p_cust_profile_amt_rec.site_use_id IS NULL OR p_CUST_PROFILE_AMT_REC.site_use_id = FND_API.G_MISS_NUM THEN
1810: BEGIN
1811: SELECT site_use_id
1812: INTO l_site_use_id
1813: FROM hz_customer_profiles

Line 1821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1817: p_cust_profile_amt_rec.site_use_id := l_site_use_id ;
1818:
1819: EXCEPTION
1820: WHEN OTHERS THEN
1821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1822: END;
1823: END IF;
1824:
1825: -- Call table-handler.

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

1944: * IN/OUT:
1945: * p_cust_profile_amt_rec Customer profile amount record.
1946: * p_object_version_number Used for locking the being updated record.
1947: * x_return_status Return status after the call. The status can
1948: * be FND_API.G_RET_STS_SUCCESS (success),
1949: * FND_API.G_RET_STS_ERROR (error),
1950: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1951: *
1952: * NOTES

Line 1949: * FND_API.G_RET_STS_ERROR (error),

1945: * p_cust_profile_amt_rec Customer profile amount record.
1946: * p_object_version_number Used for locking the being updated record.
1947: * x_return_status Return status after the call. The status can
1948: * be FND_API.G_RET_STS_SUCCESS (success),
1949: * FND_API.G_RET_STS_ERROR (error),
1950: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1951: *
1952: * NOTES
1953: *

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

1946: * p_object_version_number Used for locking the being updated record.
1947: * x_return_status Return status after the call. The status can
1948: * be FND_API.G_RET_STS_SUCCESS (success),
1949: * FND_API.G_RET_STS_ERROR (error),
1950: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1951: *
1952: * NOTES
1953: *
1954: * MODIFICATION HISTORY

Line 1997: RAISE FND_API.G_EXC_ERROR;

1993: THEN
1994: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_RECORD_CHANGED' );
1995: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_cust_profile_amts' );
1996: FND_MSG_PUB.ADD;
1997: RAISE FND_API.G_EXC_ERROR;
1998: END IF;
1999:
2000: p_object_version_number := NVL( l_object_version_number, 1 ) + 1;
2001:

Line 2009: RAISE FND_API.G_EXC_ERROR;

2005: FND_MESSAGE.SET_TOKEN( 'RECORD', 'customer account profile amount' );
2006: FND_MESSAGE.SET_TOKEN( 'VALUE',
2007: NVL( TO_CHAR( p_cust_profile_amt_rec.cust_acct_profile_amt_id ), 'null' ) );
2008: FND_MSG_PUB.ADD;
2009: RAISE FND_API.G_EXC_ERROR;
2010: END;
2011:
2012: -- Validate cust profile amt record
2013: HZ_ACCOUNT_VALIDATE_V2PUB.validate_cust_profile_amt (

Line 2020: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2016: p_cust_profile_amt_rec => p_cust_profile_amt_rec,
2017: p_rowid => l_rowid,
2018: x_return_status => x_return_status );
2019:
2020: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2021: RAISE FND_API.G_EXC_ERROR;
2022: END IF;
2023:
2024: -- Added rounding of min_fc_invoice_amount, min_fc_balance_amount, min_interest_charge,

Line 2021: RAISE FND_API.G_EXC_ERROR;

2017: p_rowid => l_rowid,
2018: x_return_status => x_return_status );
2019:
2020: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2021: RAISE FND_API.G_EXC_ERROR;
2022: END IF;
2023:
2024: -- Added rounding of min_fc_invoice_amount, min_fc_balance_amount, min_interest_charge,
2025: -- min_interest_charge, interest_fixed_amount and penalty_fixed_amount to 2 decimal places for Late charge project.

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

2256: *
2257: * ARGUMENTS
2258: * IN:
2259: * p_init_msg_list Initialize message stack if it is set to
2260: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
2261: * p_customer_profile_rec Customer profile record. One customer account
2262: * must have a customer profile. One account site
2263: * use can optionally have one customer profile.
2264: * p_create_profile_amt If it is set to FND_API.G_TRUE, API create customer

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

2260: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
2261: * p_customer_profile_rec Customer profile record. One customer account
2262: * must have a customer profile. One account site
2263: * use can optionally have one customer profile.
2264: * p_create_profile_amt If it is set to FND_API.G_TRUE, API create customer
2265: * profile amounts by copying corresponding data
2266: * from customer profile class amounts.
2267: * IN/OUT:
2268: * OUT:

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

2267: * IN/OUT:
2268: * OUT:
2269: * x_cust_account_profile_id Customer account profile ID.
2270: * x_return_status Return status after the call. The status can
2271: * be FND_API.G_RET_STS_SUCCESS (success),
2272: * FND_API.G_RET_STS_ERROR (error),
2273: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
2274: * x_msg_count Number of messages in message stack.
2275: * x_msg_data Message text if x_msg_count is 1.

Line 2272: * FND_API.G_RET_STS_ERROR (error),

2268: * OUT:
2269: * x_cust_account_profile_id Customer account profile ID.
2270: * x_return_status Return status after the call. The status can
2271: * be FND_API.G_RET_STS_SUCCESS (success),
2272: * FND_API.G_RET_STS_ERROR (error),
2273: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
2274: * x_msg_count Number of messages in message stack.
2275: * x_msg_data Message text if x_msg_count is 1.
2276: *

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

2269: * x_cust_account_profile_id Customer account profile ID.
2270: * x_return_status Return status after the call. The status can
2271: * be FND_API.G_RET_STS_SUCCESS (success),
2272: * FND_API.G_RET_STS_ERROR (error),
2273: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
2274: * x_msg_count Number of messages in message stack.
2275: * x_msg_data Message text if x_msg_count is 1.
2276: *
2277: * NOTES

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

2282: *
2283: */
2284:
2285: PROCEDURE create_customer_profile (
2286: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2287: p_customer_profile_rec IN CUSTOMER_PROFILE_REC_TYPE,
2288: p_create_profile_amt IN VARCHAR2 := FND_API.G_TRUE,
2289: x_cust_account_profile_id OUT NOCOPY NUMBER,
2290: x_return_status OUT NOCOPY VARCHAR2,

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

2284:
2285: PROCEDURE create_customer_profile (
2286: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2287: p_customer_profile_rec IN CUSTOMER_PROFILE_REC_TYPE,
2288: p_create_profile_amt IN VARCHAR2 := FND_API.G_TRUE,
2289: x_cust_account_profile_id OUT NOCOPY NUMBER,
2290: x_return_status OUT NOCOPY VARCHAR2,
2291: x_msg_count OUT NOCOPY NUMBER,
2292: x_msg_data OUT NOCOPY VARCHAR2

Line 2314: IF FND_API.to_Boolean(p_init_msg_list) THEN

2310: p_msg_level=>fnd_log.level_procedure);
2311: END IF;
2312:
2313: -- Initialize message list if p_init_msg_list is set to TRUE.
2314: IF FND_API.to_Boolean(p_init_msg_list) THEN
2315: FND_MSG_PUB.initialize;
2316: END IF;
2317:
2318: -- Initialize API return status to success.

Line 2319: x_return_status := FND_API.G_RET_STS_SUCCESS;

2315: FND_MSG_PUB.initialize;
2316: END IF;
2317:
2318: -- Initialize API return status to success.
2319: x_return_status := FND_API.G_RET_STS_SUCCESS;
2320:
2321: -- Call to business logic.
2322: do_create_customer_profile (
2323: l_customer_profile_rec,

Line 2328: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

2324: p_create_profile_amt,
2325: x_cust_account_profile_id,
2326: x_return_status );
2327:
2328: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2329: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN
2330: -- Invoke business event system.
2331: HZ_BUSINESS_EVENT_V2PVT.create_customer_profile_event (
2332: l_customer_profile_rec,

Line 2345: p_encoded => FND_API.G_FALSE,

2341: END IF;
2342:
2343: -- Standard call to get message count and if count is 1, get message info.
2344: FND_MSG_PUB.Count_And_Get(
2345: p_encoded => FND_API.G_FALSE,
2346: p_count => x_msg_count,
2347: p_data => x_msg_data );
2348:
2349: -- Debug info.

Line 2366: WHEN FND_API.G_EXC_ERROR THEN

2362: -- Check if API is called in debug mode. If yes, disable debug.
2363: --disable_debug;
2364:
2365: EXCEPTION
2366: WHEN FND_API.G_EXC_ERROR THEN
2367: ROLLBACK TO create_customer_profile;
2368: x_return_status := FND_API.G_RET_STS_ERROR;
2369:
2370: FND_MSG_PUB.Count_And_Get(

Line 2368: x_return_status := FND_API.G_RET_STS_ERROR;

2364:
2365: EXCEPTION
2366: WHEN FND_API.G_EXC_ERROR THEN
2367: ROLLBACK TO create_customer_profile;
2368: x_return_status := FND_API.G_RET_STS_ERROR;
2369:
2370: FND_MSG_PUB.Count_And_Get(
2371: p_encoded => FND_API.G_FALSE,
2372: p_count => x_msg_count,

Line 2371: p_encoded => FND_API.G_FALSE,

2367: ROLLBACK TO create_customer_profile;
2368: x_return_status := FND_API.G_RET_STS_ERROR;
2369:
2370: FND_MSG_PUB.Count_And_Get(
2371: p_encoded => FND_API.G_FALSE,
2372: p_count => x_msg_count,
2373: p_data => x_msg_data );
2374:
2375: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

Line 2390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2386:
2387: -- Check if API is called in debug mode. If yes, disable debug.
2388: --disable_debug;
2389:
2390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2391: ROLLBACK TO create_customer_profile;
2392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2393:
2394: FND_MSG_PUB.Count_And_Get(

Line 2392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2388: --disable_debug;
2389:
2390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2391: ROLLBACK TO create_customer_profile;
2392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2393:
2394: FND_MSG_PUB.Count_And_Get(
2395: p_encoded => FND_API.G_FALSE,
2396: p_count => x_msg_count,

Line 2395: p_encoded => FND_API.G_FALSE,

2391: ROLLBACK TO create_customer_profile;
2392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2393:
2394: FND_MSG_PUB.Count_And_Get(
2395: p_encoded => FND_API.G_FALSE,
2396: p_count => x_msg_count,
2397: p_data => x_msg_data );
2398:
2399: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

Line 2416: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2412: --disable_debug;
2413:
2414: WHEN OTHERS THEN
2415: ROLLBACK TO create_customer_profile;
2416: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2417:
2418: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2419: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2420: FND_MSG_PUB.ADD;

Line 2423: p_encoded => FND_API.G_FALSE,

2419: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2420: FND_MSG_PUB.ADD;
2421:
2422: FND_MSG_PUB.Count_And_Get(
2423: p_encoded => FND_API.G_FALSE,
2424: p_count => x_msg_count,
2425: p_data => x_msg_data );
2426:
2427: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

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

2452: *
2453: * ARGUMENTS
2454: * IN:
2455: * p_init_msg_list Initialize message stack if it is set to
2456: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
2457: * p_customer_profile_rec Customer profile record. One customer account
2458: * must have a customer profile. One account site
2459: * use can optionally have one customer profile.
2460: * IN/OUT:

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

2460: * IN/OUT:
2461: * p_object_version_number Used for locking the being updated record.
2462: * OUT:
2463: * x_return_status Return status after the call. The status can
2464: * be FND_API.G_RET_STS_SUCCESS (success),
2465: * FND_API.G_RET_STS_ERROR (error),
2466: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
2467: * x_msg_count Number of messages in message stack.
2468: * x_msg_data Message text if x_msg_count is 1.

Line 2465: * FND_API.G_RET_STS_ERROR (error),

2461: * p_object_version_number Used for locking the being updated record.
2462: * OUT:
2463: * x_return_status Return status after the call. The status can
2464: * be FND_API.G_RET_STS_SUCCESS (success),
2465: * FND_API.G_RET_STS_ERROR (error),
2466: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
2467: * x_msg_count Number of messages in message stack.
2468: * x_msg_data Message text if x_msg_count is 1.
2469: *

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

2462: * OUT:
2463: * x_return_status Return status after the call. The status can
2464: * be FND_API.G_RET_STS_SUCCESS (success),
2465: * FND_API.G_RET_STS_ERROR (error),
2466: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
2467: * x_msg_count Number of messages in message stack.
2468: * x_msg_data Message text if x_msg_count is 1.
2469: *
2470: * NOTES

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

2475: *
2476: */
2477:
2478: PROCEDURE update_customer_profile (
2479: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2480: p_customer_profile_rec IN CUSTOMER_PROFILE_REC_TYPE,
2481: p_object_version_number IN OUT NOCOPY NUMBER,
2482: x_return_status OUT NOCOPY VARCHAR2,
2483: x_msg_count OUT NOCOPY NUMBER,

Line 2507: IF FND_API.to_Boolean(p_init_msg_list) THEN

2503: p_msg_level=>fnd_log.level_procedure);
2504: END IF;
2505:
2506: -- Initialize message list if p_init_msg_list is set to TRUE.
2507: IF FND_API.to_Boolean(p_init_msg_list) THEN
2508: FND_MSG_PUB.initialize;
2509: END IF;
2510:
2511: -- Initialize API return status to success.

Line 2512: x_return_status := FND_API.G_RET_STS_SUCCESS;

2508: FND_MSG_PUB.initialize;
2509: END IF;
2510:
2511: -- Initialize API return status to success.
2512: x_return_status := FND_API.G_RET_STS_SUCCESS;
2513:
2514: --2290537
2515: get_customer_profile_rec (
2516: p_cust_account_profile_id => p_customer_profile_rec.cust_account_profile_id,

Line 2522: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

2518: x_return_status => x_return_status,
2519: x_msg_count => x_msg_count,
2520: x_msg_data => x_msg_data);
2521:
2522: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2523: RAISE FND_API.G_EXC_ERROR;
2524: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2526: END IF;

Line 2523: RAISE FND_API.G_EXC_ERROR;

2519: x_msg_count => x_msg_count,
2520: x_msg_data => x_msg_data);
2521:
2522: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2523: RAISE FND_API.G_EXC_ERROR;
2524: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2526: END IF;
2527:

Line 2524: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2520: x_msg_data => x_msg_data);
2521:
2522: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2523: RAISE FND_API.G_EXC_ERROR;
2524: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2526: END IF;
2527:
2528: -- Call to business logic.

Line 2525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2521:
2522: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2523: RAISE FND_API.G_EXC_ERROR;
2524: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2526: END IF;
2527:
2528: -- Call to business logic.
2529: do_update_customer_profile (

Line 2534: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

2530: l_customer_profile_rec,
2531: p_object_version_number,
2532: x_return_status );
2533:
2534: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2535: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN
2536: -- Invoke business event system.
2537: HZ_BUSINESS_EVENT_V2PVT.update_customer_profile_event (
2538: l_customer_profile_rec , l_old_customer_profile_rec);

Line 2550: p_encoded => FND_API.G_FALSE,

2546: END IF;
2547:
2548: -- Standard call to get message count and if count is 1, get message info.
2549: FND_MSG_PUB.Count_And_Get(
2550: p_encoded => FND_API.G_FALSE,
2551: p_count => x_msg_count,
2552: p_data => x_msg_data );
2553:
2554: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

Line 2570: WHEN FND_API.G_EXC_ERROR THEN

2566: -- Check if API is called in debug mode. If yes, disable debug.
2567: --disable_debug;
2568:
2569: EXCEPTION
2570: WHEN FND_API.G_EXC_ERROR THEN
2571: ROLLBACK TO update_customer_profile;
2572: x_return_status := FND_API.G_RET_STS_ERROR;
2573:
2574: FND_MSG_PUB.Count_And_Get(

Line 2572: x_return_status := FND_API.G_RET_STS_ERROR;

2568:
2569: EXCEPTION
2570: WHEN FND_API.G_EXC_ERROR THEN
2571: ROLLBACK TO update_customer_profile;
2572: x_return_status := FND_API.G_RET_STS_ERROR;
2573:
2574: FND_MSG_PUB.Count_And_Get(
2575: p_encoded => FND_API.G_FALSE,
2576: p_count => x_msg_count,

Line 2575: p_encoded => FND_API.G_FALSE,

2571: ROLLBACK TO update_customer_profile;
2572: x_return_status := FND_API.G_RET_STS_ERROR;
2573:
2574: FND_MSG_PUB.Count_And_Get(
2575: p_encoded => FND_API.G_FALSE,
2576: p_count => x_msg_count,
2577: p_data => x_msg_data );
2578:
2579: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

Line 2594: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2590:
2591: -- Check if API is called in debug mode. If yes, disable debug.
2592: --disable_debug;
2593:
2594: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2595: ROLLBACK TO update_customer_profile;
2596: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2597:
2598: FND_MSG_PUB.Count_And_Get(

Line 2596: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2592: --disable_debug;
2593:
2594: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2595: ROLLBACK TO update_customer_profile;
2596: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2597:
2598: FND_MSG_PUB.Count_And_Get(
2599: p_encoded => FND_API.G_FALSE,
2600: p_count => x_msg_count,

Line 2599: p_encoded => FND_API.G_FALSE,

2595: ROLLBACK TO update_customer_profile;
2596: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2597:
2598: FND_MSG_PUB.Count_And_Get(
2599: p_encoded => FND_API.G_FALSE,
2600: p_count => x_msg_count,
2601: p_data => x_msg_data );
2602:
2603: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

Line 2620: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2616: --disable_debug;
2617:
2618: WHEN OTHERS THEN
2619: ROLLBACK TO update_customer_profile;
2620: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2621:
2622: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2623: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2624: FND_MSG_PUB.ADD;

Line 2627: p_encoded => FND_API.G_FALSE,

2623: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2624: FND_MSG_PUB.ADD;
2625:
2626: FND_MSG_PUB.Count_And_Get(
2627: p_encoded => FND_API.G_FALSE,
2628: p_count => x_msg_count,
2629: p_data => x_msg_data );
2630:
2631: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

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

2656: *
2657: * ARGUMENTS
2658: * IN:
2659: * p_init_msg_list Initialize message stack if it is set to
2660: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
2661: * p_cust_account_profile_id Customer account profile id.
2662: * IN/OUT:
2663: * OUT:
2664: * x_customer_profile_rec Returned customer profile record.

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

2662: * IN/OUT:
2663: * OUT:
2664: * x_customer_profile_rec Returned customer profile record.
2665: * x_return_status Return status after the call. The status can
2666: * be FND_API.G_RET_STS_SUCCESS (success),
2667: * FND_API.G_RET_STS_ERROR (error),
2668: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
2669: * x_msg_count Number of messages in message stack.
2670: * x_msg_data Message text if x_msg_count is 1.

Line 2667: * FND_API.G_RET_STS_ERROR (error),

2663: * OUT:
2664: * x_customer_profile_rec Returned customer profile record.
2665: * x_return_status Return status after the call. The status can
2666: * be FND_API.G_RET_STS_SUCCESS (success),
2667: * FND_API.G_RET_STS_ERROR (error),
2668: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
2669: * x_msg_count Number of messages in message stack.
2670: * x_msg_data Message text if x_msg_count is 1.
2671: *

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

2664: * x_customer_profile_rec Returned customer profile record.
2665: * x_return_status Return status after the call. The status can
2666: * be FND_API.G_RET_STS_SUCCESS (success),
2667: * FND_API.G_RET_STS_ERROR (error),
2668: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
2669: * x_msg_count Number of messages in message stack.
2670: * x_msg_data Message text if x_msg_count is 1.
2671: *
2672: * NOTES

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

2677: *
2678: */
2679:
2680: PROCEDURE get_customer_profile_rec (
2681: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2682: p_cust_account_profile_id IN NUMBER,
2683: x_customer_profile_rec OUT NOCOPY CUSTOMER_PROFILE_REC_TYPE,
2684: x_return_status OUT NOCOPY VARCHAR2,
2685: x_msg_count OUT NOCOPY NUMBER,

Line 2702: IF FND_API.to_Boolean(p_init_msg_list) THEN

2698: p_msg_level=>fnd_log.level_procedure);
2699: END IF;
2700:
2701: -- Initialize message list if p_init_msg_list is set to TRUE.
2702: IF FND_API.to_Boolean(p_init_msg_list) THEN
2703: FND_MSG_PUB.initialize;
2704: END IF;
2705:
2706: -- Initialize API return status to success.

Line 2707: x_return_status := FND_API.G_RET_STS_SUCCESS;

2703: FND_MSG_PUB.initialize;
2704: END IF;
2705:
2706: -- Initialize API return status to success.
2707: x_return_status := FND_API.G_RET_STS_SUCCESS;
2708:
2709: -- Check whether primary key has been passed in.
2710: IF p_cust_account_profile_id IS NULL OR
2711: p_cust_account_profile_id = FND_API.G_MISS_NUM THEN

Line 2711: p_cust_account_profile_id = FND_API.G_MISS_NUM THEN

2707: x_return_status := FND_API.G_RET_STS_SUCCESS;
2708:
2709: -- Check whether primary key has been passed in.
2710: IF p_cust_account_profile_id IS NULL OR
2711: p_cust_account_profile_id = FND_API.G_MISS_NUM THEN
2712: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2713: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'cust_account_profile_id' );
2714: FND_MSG_PUB.ADD;
2715: RAISE FND_API.G_EXC_ERROR;

Line 2715: RAISE FND_API.G_EXC_ERROR;

2711: p_cust_account_profile_id = FND_API.G_MISS_NUM THEN
2712: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2713: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'cust_account_profile_id' );
2714: FND_MSG_PUB.ADD;
2715: RAISE FND_API.G_EXC_ERROR;
2716: END IF;
2717:
2718: x_customer_profile_rec.cust_account_profile_id := p_cust_account_profile_id;
2719:

Line 2850: p_encoded => FND_API.G_FALSE,

2846: END IF;
2847:
2848: -- Standard call to get message count and if count is 1, get message info.
2849: FND_MSG_PUB.Count_And_Get(
2850: p_encoded => FND_API.G_FALSE,
2851: p_count => x_msg_count,
2852: p_data => x_msg_data );
2853:
2854: -- Debug info.

Line 2871: WHEN FND_API.G_EXC_ERROR THEN

2867: -- Check if API is called in debug mode. If yes, disable debug.
2868: --disable_debug;
2869:
2870: EXCEPTION
2871: WHEN FND_API.G_EXC_ERROR THEN
2872: x_return_status := FND_API.G_RET_STS_ERROR;
2873:
2874: FND_MSG_PUB.Count_And_Get(
2875: p_encoded => FND_API.G_FALSE,

Line 2872: x_return_status := FND_API.G_RET_STS_ERROR;

2868: --disable_debug;
2869:
2870: EXCEPTION
2871: WHEN FND_API.G_EXC_ERROR THEN
2872: x_return_status := FND_API.G_RET_STS_ERROR;
2873:
2874: FND_MSG_PUB.Count_And_Get(
2875: p_encoded => FND_API.G_FALSE,
2876: p_count => x_msg_count,

Line 2875: p_encoded => FND_API.G_FALSE,

2871: WHEN FND_API.G_EXC_ERROR THEN
2872: x_return_status := FND_API.G_RET_STS_ERROR;
2873:
2874: FND_MSG_PUB.Count_And_Get(
2875: p_encoded => FND_API.G_FALSE,
2876: p_count => x_msg_count,
2877: p_data => x_msg_data );
2878:
2879: -- Debug info.

Line 2895: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2891:
2892: -- Check if API is called in debug mode. If yes, disable debug.
2893: --disable_debug;
2894:
2895: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2896: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2897:
2898: FND_MSG_PUB.Count_And_Get(
2899: p_encoded => FND_API.G_FALSE,

Line 2896: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2892: -- Check if API is called in debug mode. If yes, disable debug.
2893: --disable_debug;
2894:
2895: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2896: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2897:
2898: FND_MSG_PUB.Count_And_Get(
2899: p_encoded => FND_API.G_FALSE,
2900: p_count => x_msg_count,

Line 2899: p_encoded => FND_API.G_FALSE,

2895: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2896: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2897:
2898: FND_MSG_PUB.Count_And_Get(
2899: p_encoded => FND_API.G_FALSE,
2900: p_count => x_msg_count,
2901: p_data => x_msg_data );
2902:
2903: -- Debug info.

Line 2920: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2916: -- Check if API is called in debug mode. If yes, disable debug.
2917: --disable_debug;
2918:
2919: WHEN OTHERS THEN
2920: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2921:
2922: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2923: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2924: FND_MSG_PUB.ADD;

Line 2927: p_encoded => FND_API.G_FALSE,

2923: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2924: FND_MSG_PUB.ADD;
2925:
2926: FND_MSG_PUB.Count_And_Get(
2927: p_encoded => FND_API.G_FALSE,
2928: p_count => x_msg_count,
2929: p_data => x_msg_data );
2930:
2931: -- Debug info.

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

2957: *
2958: * ARGUMENTS
2959: * IN:
2960: * p_init_msg_list Initialize message stack if it is set to
2961: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
2962: * p_check_foreign_key If do foreign key checking on cust_account_id
2963: * and cust_account_profile_id or not. Defaut value
2964: * is FND_API.G_TRUE, which means API will do foreign
2965: * key checking on these 2 columns.

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

2960: * p_init_msg_list Initialize message stack if it is set to
2961: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
2962: * p_check_foreign_key If do foreign key checking on cust_account_id
2963: * and cust_account_profile_id or not. Defaut value
2964: * is FND_API.G_TRUE, which means API will do foreign
2965: * key checking on these 2 columns.
2966: * p_cust_profile_amt_rec Customer profile amount record.
2967: * IN/OUT:
2968: * OUT:

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

2967: * IN/OUT:
2968: * OUT:
2969: * x_cust_acct_profile_amt_id Customer account profile amount ID.
2970: * x_return_status Return status after the call. The status can
2971: * be FND_API.G_RET_STS_SUCCESS (success),
2972: * FND_API.G_RET_STS_ERROR (error),
2973: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
2974: * x_msg_count Number of messages in message stack.
2975: * x_msg_data Message text if x_msg_count is 1.

Line 2972: * FND_API.G_RET_STS_ERROR (error),

2968: * OUT:
2969: * x_cust_acct_profile_amt_id Customer account profile amount ID.
2970: * x_return_status Return status after the call. The status can
2971: * be FND_API.G_RET_STS_SUCCESS (success),
2972: * FND_API.G_RET_STS_ERROR (error),
2973: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
2974: * x_msg_count Number of messages in message stack.
2975: * x_msg_data Message text if x_msg_count is 1.
2976: *

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

2969: * x_cust_acct_profile_amt_id Customer account profile amount ID.
2970: * x_return_status Return status after the call. The status can
2971: * be FND_API.G_RET_STS_SUCCESS (success),
2972: * FND_API.G_RET_STS_ERROR (error),
2973: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
2974: * x_msg_count Number of messages in message stack.
2975: * x_msg_data Message text if x_msg_count is 1.
2976: *
2977: * NOTES

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

2983: */
2984:
2985:
2986: PROCEDURE create_cust_profile_amt (
2987: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2988: p_check_foreign_key IN VARCHAR2 := FND_API.G_TRUE,
2989: p_cust_profile_amt_rec IN CUST_PROFILE_AMT_REC_TYPE,
2990: x_cust_acct_profile_amt_id OUT NOCOPY NUMBER,
2991: x_return_status OUT NOCOPY VARCHAR2,

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

2984:
2985:
2986: PROCEDURE create_cust_profile_amt (
2987: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2988: p_check_foreign_key IN VARCHAR2 := FND_API.G_TRUE,
2989: p_cust_profile_amt_rec IN CUST_PROFILE_AMT_REC_TYPE,
2990: x_cust_acct_profile_amt_id OUT NOCOPY NUMBER,
2991: x_return_status OUT NOCOPY VARCHAR2,
2992: x_msg_count OUT NOCOPY NUMBER,

Line 3015: IF FND_API.to_Boolean(p_init_msg_list) THEN

3011: p_msg_level=>fnd_log.level_procedure);
3012: END IF;
3013:
3014: -- Initialize message list if p_init_msg_list is set to TRUE.
3015: IF FND_API.to_Boolean(p_init_msg_list) THEN
3016: FND_MSG_PUB.initialize;
3017: END IF;
3018:
3019: -- Initialize API return status to success.

Line 3020: x_return_status := FND_API.G_RET_STS_SUCCESS;

3016: FND_MSG_PUB.initialize;
3017: END IF;
3018:
3019: -- Initialize API return status to success.
3020: x_return_status := FND_API.G_RET_STS_SUCCESS;
3021:
3022: -- Call to business logic.
3023: do_create_cust_profile_amt (
3024: p_check_foreign_key,

Line 3029: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

3025: l_cust_profile_amt_rec,
3026: x_cust_acct_profile_amt_id,
3027: x_return_status );
3028:
3029: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
3030: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN
3031: -- Invoke business event system.
3032: HZ_BUSINESS_EVENT_V2PVT.create_cust_profile_amt_event (
3033: l_cust_profile_amt_rec );

Line 3045: p_encoded => FND_API.G_FALSE,

3041: END IF;
3042:
3043: -- Standard call to get message count and if count is 1, get message info.
3044: FND_MSG_PUB.Count_And_Get(
3045: p_encoded => FND_API.G_FALSE,
3046: p_count => x_msg_count,
3047: p_data => x_msg_data );
3048:
3049: -- Debug info.

Line 3066: WHEN FND_API.G_EXC_ERROR THEN

3062: -- Check if API is called in debug mode. If yes, disable debug.
3063: --disable_debug;
3064:
3065: EXCEPTION
3066: WHEN FND_API.G_EXC_ERROR THEN
3067: ROLLBACK TO create_cust_profile_amt;
3068: x_return_status := FND_API.G_RET_STS_ERROR;
3069:
3070: FND_MSG_PUB.Count_And_Get(

Line 3068: x_return_status := FND_API.G_RET_STS_ERROR;

3064:
3065: EXCEPTION
3066: WHEN FND_API.G_EXC_ERROR THEN
3067: ROLLBACK TO create_cust_profile_amt;
3068: x_return_status := FND_API.G_RET_STS_ERROR;
3069:
3070: FND_MSG_PUB.Count_And_Get(
3071: p_encoded => FND_API.G_FALSE,
3072: p_count => x_msg_count,

Line 3071: p_encoded => FND_API.G_FALSE,

3067: ROLLBACK TO create_cust_profile_amt;
3068: x_return_status := FND_API.G_RET_STS_ERROR;
3069:
3070: FND_MSG_PUB.Count_And_Get(
3071: p_encoded => FND_API.G_FALSE,
3072: p_count => x_msg_count,
3073: p_data => x_msg_data );
3074:
3075: -- Debug info.

Line 3091: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3087:
3088: -- Check if API is called in debug mode. If yes, disable debug.
3089: --disable_debug;
3090:
3091: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3092: ROLLBACK TO create_cust_profile_amt;
3093: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3094:
3095: FND_MSG_PUB.Count_And_Get(

Line 3093: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3089: --disable_debug;
3090:
3091: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3092: ROLLBACK TO create_cust_profile_amt;
3093: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3094:
3095: FND_MSG_PUB.Count_And_Get(
3096: p_encoded => FND_API.G_FALSE,
3097: p_count => x_msg_count,

Line 3096: p_encoded => FND_API.G_FALSE,

3092: ROLLBACK TO create_cust_profile_amt;
3093: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3094:
3095: FND_MSG_PUB.Count_And_Get(
3096: p_encoded => FND_API.G_FALSE,
3097: p_count => x_msg_count,
3098: p_data => x_msg_data );
3099:
3100: -- Debug info.

Line 3118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3114: --disable_debug;
3115:
3116: WHEN OTHERS THEN
3117: ROLLBACK TO create_cust_profile_amt;
3118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3119:
3120: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
3121: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3122: FND_MSG_PUB.ADD;

Line 3125: p_encoded => FND_API.G_FALSE,

3121: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3122: FND_MSG_PUB.ADD;
3123:
3124: FND_MSG_PUB.Count_And_Get(
3125: p_encoded => FND_API.G_FALSE,
3126: p_count => x_msg_count,
3127: p_data => x_msg_data );
3128:
3129: -- Debug info.

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

3156: *
3157: * ARGUMENTS
3158: * IN:
3159: * p_init_msg_list Initialize message stack if it is set to
3160: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
3161: * p_cust_profile_amt_rec Customer profile amount record.
3162: * IN/OUT:
3163: * p_object_version_number Used for locking the being updated record.
3164: * OUT:

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

3162: * IN/OUT:
3163: * p_object_version_number Used for locking the being updated record.
3164: * OUT:
3165: * x_return_status Return status after the call. The status can
3166: * be FND_API.G_RET_STS_SUCCESS (success),
3167: * FND_API.G_RET_STS_ERROR (error),
3168: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
3169: * x_msg_count Number of messages in message stack.
3170: * x_msg_data Message text if x_msg_count is 1.

Line 3167: * FND_API.G_RET_STS_ERROR (error),

3163: * p_object_version_number Used for locking the being updated record.
3164: * OUT:
3165: * x_return_status Return status after the call. The status can
3166: * be FND_API.G_RET_STS_SUCCESS (success),
3167: * FND_API.G_RET_STS_ERROR (error),
3168: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
3169: * x_msg_count Number of messages in message stack.
3170: * x_msg_data Message text if x_msg_count is 1.
3171: *

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

3164: * OUT:
3165: * x_return_status Return status after the call. The status can
3166: * be FND_API.G_RET_STS_SUCCESS (success),
3167: * FND_API.G_RET_STS_ERROR (error),
3168: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
3169: * x_msg_count Number of messages in message stack.
3170: * x_msg_data Message text if x_msg_count is 1.
3171: *
3172: * NOTES

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

3177: *
3178: */
3179:
3180: PROCEDURE update_cust_profile_amt (
3181: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3182: p_cust_profile_amt_rec IN CUST_PROFILE_AMT_REC_TYPE,
3183: p_object_version_number IN OUT NOCOPY NUMBER,
3184: x_return_status OUT NOCOPY VARCHAR2,
3185: x_msg_count OUT NOCOPY NUMBER,

Line 3209: IF FND_API.to_Boolean(p_init_msg_list) THEN

3205: p_msg_level=>fnd_log.level_procedure);
3206: END IF;
3207:
3208: -- Initialize message list if p_init_msg_list is set to TRUE.
3209: IF FND_API.to_Boolean(p_init_msg_list) THEN
3210: FND_MSG_PUB.initialize;
3211: END IF;
3212:
3213: -- Initialize API return status to success.

Line 3214: x_return_status := FND_API.G_RET_STS_SUCCESS;

3210: FND_MSG_PUB.initialize;
3211: END IF;
3212:
3213: -- Initialize API return status to success.
3214: x_return_status := FND_API.G_RET_STS_SUCCESS;
3215:
3216: --2290537
3217: get_cust_profile_amt_rec (
3218: p_cust_acct_profile_amt_id => p_cust_profile_amt_rec.cust_acct_profile_amt_id,

Line 3224: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

3220: x_return_status => x_return_status,
3221: x_msg_count => x_msg_count,
3222: x_msg_data => x_msg_data);
3223:
3224: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3225: RAISE FND_API.G_EXC_ERROR;
3226: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3228: END IF;

Line 3225: RAISE FND_API.G_EXC_ERROR;

3221: x_msg_count => x_msg_count,
3222: x_msg_data => x_msg_data);
3223:
3224: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3225: RAISE FND_API.G_EXC_ERROR;
3226: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3228: END IF;
3229:

Line 3226: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3222: x_msg_data => x_msg_data);
3223:
3224: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3225: RAISE FND_API.G_EXC_ERROR;
3226: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3228: END IF;
3229:
3230: -- Call to business logic.

Line 3227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3223:
3224: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3225: RAISE FND_API.G_EXC_ERROR;
3226: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3228: END IF;
3229:
3230: -- Call to business logic.
3231: do_update_cust_profile_amt (

Line 3236: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

3232: l_cust_profile_amt_rec,
3233: p_object_version_number,
3234: x_return_status );
3235:
3236: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
3237: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN
3238: -- Invoke business event system.
3239: HZ_BUSINESS_EVENT_V2PVT.update_cust_profile_amt_event (
3240: l_cust_profile_amt_rec , l_old_cust_profile_amt_rec );

Line 3252: p_encoded => FND_API.G_FALSE,

3248: END IF;
3249:
3250: -- Standard call to get message count and if count is 1, get message info.
3251: FND_MSG_PUB.Count_And_Get(
3252: p_encoded => FND_API.G_FALSE,
3253: p_count => x_msg_count,
3254: p_data => x_msg_data );
3255:
3256: -- Debug info.

Line 3274: WHEN FND_API.G_EXC_ERROR THEN

3270: -- Check if API is called in debug mode. If yes, disable debug.
3271: --disable_debug;
3272:
3273: EXCEPTION
3274: WHEN FND_API.G_EXC_ERROR THEN
3275: ROLLBACK TO update_cust_profile_amt;
3276: x_return_status := FND_API.G_RET_STS_ERROR;
3277:
3278: FND_MSG_PUB.Count_And_Get(

Line 3276: x_return_status := FND_API.G_RET_STS_ERROR;

3272:
3273: EXCEPTION
3274: WHEN FND_API.G_EXC_ERROR THEN
3275: ROLLBACK TO update_cust_profile_amt;
3276: x_return_status := FND_API.G_RET_STS_ERROR;
3277:
3278: FND_MSG_PUB.Count_And_Get(
3279: p_encoded => FND_API.G_FALSE,
3280: p_count => x_msg_count,

Line 3279: p_encoded => FND_API.G_FALSE,

3275: ROLLBACK TO update_cust_profile_amt;
3276: x_return_status := FND_API.G_RET_STS_ERROR;
3277:
3278: FND_MSG_PUB.Count_And_Get(
3279: p_encoded => FND_API.G_FALSE,
3280: p_count => x_msg_count,
3281: p_data => x_msg_data );
3282:
3283: -- Debug info.

Line 3299: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3295:
3296: -- Check if API is called in debug mode. If yes, disable debug.
3297: --disable_debug;
3298:
3299: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3300: ROLLBACK TO update_cust_profile_amt;
3301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3302:
3303: FND_MSG_PUB.Count_And_Get(

Line 3301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3297: --disable_debug;
3298:
3299: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3300: ROLLBACK TO update_cust_profile_amt;
3301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3302:
3303: FND_MSG_PUB.Count_And_Get(
3304: p_encoded => FND_API.G_FALSE,
3305: p_count => x_msg_count,

Line 3304: p_encoded => FND_API.G_FALSE,

3300: ROLLBACK TO update_cust_profile_amt;
3301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3302:
3303: FND_MSG_PUB.Count_And_Get(
3304: p_encoded => FND_API.G_FALSE,
3305: p_count => x_msg_count,
3306: p_data => x_msg_data );
3307:
3308: -- Debug info.

Line 3326: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3322: --disable_debug;
3323:
3324: WHEN OTHERS THEN
3325: ROLLBACK TO update_cust_profile_amt;
3326: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3327:
3328: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
3329: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3330: FND_MSG_PUB.ADD;

Line 3333: p_encoded => FND_API.G_FALSE,

3329: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3330: FND_MSG_PUB.ADD;
3331:
3332: FND_MSG_PUB.Count_And_Get(
3333: p_encoded => FND_API.G_FALSE,
3334: p_count => x_msg_count,
3335: p_data => x_msg_data );
3336:
3337: -- Debug info.

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

3363: *
3364: * ARGUMENTS
3365: * IN:
3366: * p_init_msg_list Initialize message stack if it is set to
3367: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
3368: * p_cust_acct_profile_amt_id Customer account profile amount id.
3369: * IN/OUT:
3370: * OUT:
3371: * x_cust_profile_amt_rec Returned customer profile amount record.

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

3369: * IN/OUT:
3370: * OUT:
3371: * x_cust_profile_amt_rec Returned customer profile amount record.
3372: * x_return_status Return status after the call. The status can
3373: * be FND_API.G_RET_STS_SUCCESS (success),
3374: * FND_API.G_RET_STS_ERROR (error),
3375: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
3376: * x_msg_count Number of messages in message stack.
3377: * x_msg_data Message text if x_msg_count is 1.

Line 3374: * FND_API.G_RET_STS_ERROR (error),

3370: * OUT:
3371: * x_cust_profile_amt_rec Returned customer profile amount record.
3372: * x_return_status Return status after the call. The status can
3373: * be FND_API.G_RET_STS_SUCCESS (success),
3374: * FND_API.G_RET_STS_ERROR (error),
3375: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
3376: * x_msg_count Number of messages in message stack.
3377: * x_msg_data Message text if x_msg_count is 1.
3378: *

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

3371: * x_cust_profile_amt_rec Returned customer profile amount record.
3372: * x_return_status Return status after the call. The status can
3373: * be FND_API.G_RET_STS_SUCCESS (success),
3374: * FND_API.G_RET_STS_ERROR (error),
3375: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
3376: * x_msg_count Number of messages in message stack.
3377: * x_msg_data Message text if x_msg_count is 1.
3378: *
3379: * NOTES

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

3384: *
3385: */
3386:
3387: PROCEDURE get_cust_profile_amt_rec (
3388: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3389: p_cust_acct_profile_amt_id IN NUMBER,
3390: x_cust_profile_amt_rec OUT NOCOPY CUST_PROFILE_AMT_REC_TYPE,
3391: x_return_status OUT NOCOPY VARCHAR2,
3392: x_msg_count OUT NOCOPY NUMBER,

Line 3409: IF FND_API.to_Boolean(p_init_msg_list) THEN

3405: p_msg_level=>fnd_log.level_procedure);
3406: END IF;
3407:
3408: -- Initialize message list if p_init_msg_list is set to TRUE.
3409: IF FND_API.to_Boolean(p_init_msg_list) THEN
3410: FND_MSG_PUB.initialize;
3411: END IF;
3412:
3413: -- Initialize API return status to success.

Line 3414: x_return_status := FND_API.G_RET_STS_SUCCESS;

3410: FND_MSG_PUB.initialize;
3411: END IF;
3412:
3413: -- Initialize API return status to success.
3414: x_return_status := FND_API.G_RET_STS_SUCCESS;
3415:
3416: -- Check whether primary key has been passed in.
3417: IF p_cust_acct_profile_amt_id IS NULL OR
3418: p_cust_acct_profile_amt_id = FND_API.G_MISS_NUM THEN

Line 3418: p_cust_acct_profile_amt_id = FND_API.G_MISS_NUM THEN

3414: x_return_status := FND_API.G_RET_STS_SUCCESS;
3415:
3416: -- Check whether primary key has been passed in.
3417: IF p_cust_acct_profile_amt_id IS NULL OR
3418: p_cust_acct_profile_amt_id = FND_API.G_MISS_NUM THEN
3419: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
3420: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'cust_acct_profile_amt_id' );
3421: FND_MSG_PUB.ADD;
3422: RAISE FND_API.G_EXC_ERROR;

Line 3422: RAISE FND_API.G_EXC_ERROR;

3418: p_cust_acct_profile_amt_id = FND_API.G_MISS_NUM THEN
3419: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
3420: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'cust_acct_profile_amt_id' );
3421: FND_MSG_PUB.ADD;
3422: RAISE FND_API.G_EXC_ERROR;
3423: END IF;
3424:
3425: x_cust_profile_amt_rec.cust_acct_profile_amt_id := p_cust_acct_profile_amt_id;
3426:

Line 3531: p_encoded => FND_API.G_FALSE,

3527: END IF;
3528:
3529: -- Standard call to get message count and if count is 1, get message info.
3530: FND_MSG_PUB.Count_And_Get(
3531: p_encoded => FND_API.G_FALSE,
3532: p_count => x_msg_count,
3533: p_data => x_msg_data );
3534:
3535: -- Debug info.

Line 3552: WHEN FND_API.G_EXC_ERROR THEN

3548: -- Check if API is called in debug mode. If yes, disable debug.
3549: --disable_debug;
3550:
3551: EXCEPTION
3552: WHEN FND_API.G_EXC_ERROR THEN
3553: x_return_status := FND_API.G_RET_STS_ERROR;
3554:
3555: FND_MSG_PUB.Count_And_Get(
3556: p_encoded => FND_API.G_FALSE,

Line 3553: x_return_status := FND_API.G_RET_STS_ERROR;

3549: --disable_debug;
3550:
3551: EXCEPTION
3552: WHEN FND_API.G_EXC_ERROR THEN
3553: x_return_status := FND_API.G_RET_STS_ERROR;
3554:
3555: FND_MSG_PUB.Count_And_Get(
3556: p_encoded => FND_API.G_FALSE,
3557: p_count => x_msg_count,

Line 3556: p_encoded => FND_API.G_FALSE,

3552: WHEN FND_API.G_EXC_ERROR THEN
3553: x_return_status := FND_API.G_RET_STS_ERROR;
3554:
3555: FND_MSG_PUB.Count_And_Get(
3556: p_encoded => FND_API.G_FALSE,
3557: p_count => x_msg_count,
3558: p_data => x_msg_data );
3559:
3560: -- Debug info.

Line 3576: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3572:
3573: -- Check if API is called in debug mode. If yes, disable debug.
3574: --disable_debug;
3575:
3576: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3578:
3579: FND_MSG_PUB.Count_And_Get(
3580: p_encoded => FND_API.G_FALSE,

Line 3577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3573: -- Check if API is called in debug mode. If yes, disable debug.
3574: --disable_debug;
3575:
3576: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3578:
3579: FND_MSG_PUB.Count_And_Get(
3580: p_encoded => FND_API.G_FALSE,
3581: p_count => x_msg_count,

Line 3580: p_encoded => FND_API.G_FALSE,

3576: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3578:
3579: FND_MSG_PUB.Count_And_Get(
3580: p_encoded => FND_API.G_FALSE,
3581: p_count => x_msg_count,
3582: p_data => x_msg_data );
3583:
3584: -- Debug info.

Line 3601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3597: -- Check if API is called in debug mode. If yes, disable debug.
3598: --disable_debug;
3599:
3600: WHEN OTHERS THEN
3601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3602:
3603: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
3604: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3605: FND_MSG_PUB.ADD;

Line 3608: p_encoded => FND_API.G_FALSE,

3604: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3605: FND_MSG_PUB.ADD;
3606:
3607: FND_MSG_PUB.Count_And_Get(
3608: p_encoded => FND_API.G_FALSE,
3609: p_count => x_msg_count,
3610: p_data => x_msg_data );
3611:
3612: -- Debug info.