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 478: x_return_status := FND_API.G_RET_STS_ERROR;

474: /*
475: if p_customer_profile_rec.cons_bill_level is NOT NULL then
476: FND_MESSAGE.SET_NAME('AR', 'HZ_API_SITE_BILL_LVL_NULL');
477: FND_MSG_PUB.ADD;
478: x_return_status := FND_API.G_RET_STS_ERROR;
479: end if;
480: */
481: OPEN c_acct_use_profile_dtls;
482: FETCH c_acct_use_profile_dtls INTO l_cons_bill_level, l_cons_inv_type;

Line 486: x_return_status := FND_API.G_RET_STS_ERROR;

482: FETCH c_acct_use_profile_dtls INTO l_cons_bill_level, l_cons_inv_type;
483: IF c_acct_use_profile_dtls%NOTFOUND THEN
484: FND_MESSAGE.SET_NAME('AR', 'HZ_API_ENABLE_ACC_BAL_FWD_BILL');
485: FND_MSG_PUB.ADD;
486: x_return_status := FND_API.G_RET_STS_ERROR;
487: END IF;
488: p_customer_profile_rec.cons_bill_level := l_cons_bill_level;
489: if p_customer_profile_rec.cons_inv_type is NULL then
490: p_customer_profile_rec.cons_inv_type := l_cons_inv_type;

Line 533: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

529: p_customer_profile_rec => p_customer_profile_rec,
530: p_rowid => NULL,
531: x_return_status => x_return_status );
532:
533: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
534: RAISE FND_API.G_EXC_ERROR;
535: END IF;
536:
537: -- Added rounding of payment_grace_days to integer for Late charge project.

Line 534: RAISE FND_API.G_EXC_ERROR;

530: p_rowid => NULL,
531: x_return_status => x_return_status );
532:
533: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
534: RAISE FND_API.G_EXC_ERROR;
535: END IF;
536:
537: -- Added rounding of payment_grace_days to integer for Late charge project.
538: IF p_customer_profile_rec.payment_grace_days is NOT NULL then

Line 572: p_init_msg_list => FND_API.G_FALSE,

568:
569: BEGIN
570: OE_Holds_PUB.Process_Holds (
571: p_api_version => 1.0,
572: p_init_msg_list => FND_API.G_FALSE,
573: p_hold_entity_code => v_entity_code,
574: p_hold_entity_id => v_entity_id,
575: p_hold_id => 1,
576: p_release_reason_code => 'AR_AUTOMATIC',

Line 606: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

602:
603: --
604: -- only raise unexpected error
605: --
606: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
608: END IF;
609: END IF;
610:

Line 607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

603: --
604: -- only raise unexpected error
605: --
606: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
608: END IF;
609: END IF;
610:
611: -- Call table-handler.

Line 747: IF p_create_profile_amt = FND_API.G_FALSE THEN

743:
744: -- Now default in the profile amounts only if
745: -- p_create_profile_amt is TRUE. Otherwise, simply return.
746:
747: IF p_create_profile_amt = FND_API.G_FALSE THEN
748: RETURN;
749: END IF;
750:
751: BEGIN

Line 893: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

889: l_msg_count,
890: l_msg_data );
891: END IF;
892:
893: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
894: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
895: RAISE FND_API.G_EXC_ERROR;
896: ELSE
897: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 894: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

890: l_msg_data );
891: END IF;
892:
893: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
894: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
895: RAISE FND_API.G_EXC_ERROR;
896: ELSE
897: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
898: END IF;

Line 895: RAISE FND_API.G_EXC_ERROR;

891: END IF;
892:
893: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
894: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
895: RAISE FND_API.G_EXC_ERROR;
896: ELSE
897: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
898: END IF;
899: END IF;

Line 897: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

893: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
894: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
895: RAISE FND_API.G_EXC_ERROR;
896: ELSE
897: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
898: END IF;
899: END IF;
900:
901: END LOOP;

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

937: * must have a customer profile. One account site
938: * use can optionally have one customer profile.
939: * p_object_version_number Used for locking the being updated record.
940: * x_return_status Return status after the call. The status can
941: * be FND_API.G_RET_STS_SUCCESS (success),
942: * FND_API.G_RET_STS_ERROR (error),
943: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
944: *
945: * NOTES

Line 942: * FND_API.G_RET_STS_ERROR (error),

938: * use can optionally have one customer profile.
939: * p_object_version_number Used for locking the being updated record.
940: * x_return_status Return status after the call. The status can
941: * be FND_API.G_RET_STS_SUCCESS (success),
942: * FND_API.G_RET_STS_ERROR (error),
943: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
944: *
945: * NOTES
946: *

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

939: * p_object_version_number Used for locking the being updated record.
940: * x_return_status Return status after the call. The status can
941: * be FND_API.G_RET_STS_SUCCESS (success),
942: * FND_API.G_RET_STS_ERROR (error),
943: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
944: *
945: * NOTES
946: *
947: * MODIFICATION HISTORY

Line 1043: RAISE FND_API.G_EXC_ERROR;

1039: THEN
1040: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_RECORD_CHANGED' );
1041: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_customer_profiles' );
1042: FND_MSG_PUB.ADD;
1043: RAISE FND_API.G_EXC_ERROR;
1044: END IF;
1045:
1046: p_object_version_number := NVL( l_object_version_number, 1 ) + 1;
1047:

Line 1055: RAISE FND_API.G_EXC_ERROR;

1051: FND_MESSAGE.SET_TOKEN( 'RECORD', 'customer profile' );
1052: FND_MESSAGE.SET_TOKEN( 'VALUE',
1053: NVL( TO_CHAR( p_customer_profile_rec.cust_account_profile_id ), 'null' ) );
1054: FND_MSG_PUB.ADD;
1055: RAISE FND_API.G_EXC_ERROR;
1056: END;
1057:
1058: l_profile_class_changed := 'N';
1059:

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

1058: l_profile_class_changed := 'N';
1059:
1060: -- If the profile_class_id is changed get profile class rec into l_profile_class_rec
1061: IF (p_customer_profile_rec.profile_class_id IS NOT NULL AND
1062: p_customer_profile_rec.profile_class_id <> FND_API.G_MISS_NUM AND
1063: p_customer_profile_rec.profile_class_id <> NVL(l_profile_class_id, FND_API.G_MISS_NUM)) then
1064:
1065: l_profile_class_changed := 'Y';
1066:

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

1059:
1060: -- If the profile_class_id is changed get profile class rec into l_profile_class_rec
1061: IF (p_customer_profile_rec.profile_class_id IS NOT NULL AND
1062: p_customer_profile_rec.profile_class_id <> FND_API.G_MISS_NUM AND
1063: p_customer_profile_rec.profile_class_id <> NVL(l_profile_class_id, FND_API.G_MISS_NUM)) then
1064:
1065: l_profile_class_changed := 'Y';
1066:
1067: SELECT * INTO l_profile_class_rec

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

1071: -- While changing the profile class for an existing cusromer profile record
1072: -- it should do the validations based on the new input parameters.
1073: -- If the input parameters are passed NULL or G_MISS, get the value from profile class.
1074: if ( p_customer_profile_rec.cons_inv_flag is NULL OR
1075: p_customer_profile_rec.cons_inv_flag = FND_API.G_MISS_CHAR) then
1076: p_customer_profile_rec.cons_inv_flag := l_profile_class_rec.cons_inv_flag;
1077: end if;
1078: if ( p_customer_profile_rec.cons_bill_level is NULL OR
1079: p_customer_profile_rec.cons_bill_level = FND_API.G_MISS_CHAR) then

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

1075: p_customer_profile_rec.cons_inv_flag = FND_API.G_MISS_CHAR) then
1076: p_customer_profile_rec.cons_inv_flag := l_profile_class_rec.cons_inv_flag;
1077: end if;
1078: if ( p_customer_profile_rec.cons_bill_level is NULL OR
1079: p_customer_profile_rec.cons_bill_level = FND_API.G_MISS_CHAR) then
1080: p_customer_profile_rec.cons_bill_level := l_profile_class_rec.cons_bill_level;
1081: end if;
1082: if ( p_customer_profile_rec.cons_inv_type is NULL OR
1083: p_customer_profile_rec.cons_inv_type = FND_API.G_MISS_CHAR) then

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

1079: p_customer_profile_rec.cons_bill_level = FND_API.G_MISS_CHAR) then
1080: p_customer_profile_rec.cons_bill_level := l_profile_class_rec.cons_bill_level;
1081: end if;
1082: if ( p_customer_profile_rec.cons_inv_type is NULL OR
1083: p_customer_profile_rec.cons_inv_type = FND_API.G_MISS_CHAR) then
1084: p_customer_profile_rec.cons_inv_type := l_profile_class_rec.cons_inv_type;
1085: end if;
1086: if ( p_customer_profile_rec.standard_terms is NULL OR
1087: p_customer_profile_rec.standard_terms = FND_API.G_MISS_NUM) then

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

1083: p_customer_profile_rec.cons_inv_type = FND_API.G_MISS_CHAR) then
1084: p_customer_profile_rec.cons_inv_type := l_profile_class_rec.cons_inv_type;
1085: end if;
1086: if ( p_customer_profile_rec.standard_terms is NULL OR
1087: p_customer_profile_rec.standard_terms = FND_API.G_MISS_NUM) then
1088: p_customer_profile_rec.standard_terms := l_profile_class_rec.standard_terms;
1089: end if;
1090: END IF;
1091:

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

1091:
1092: -- Value for cons_inv_flag should be Y or N
1093: if p_customer_profile_rec.cons_inv_flag is NULL then
1094: p_customer_profile_rec.cons_inv_flag := l_cons_inv_flag;
1095: elsif p_customer_profile_rec.cons_inv_flag = FND_API.G_MISS_CHAR then
1096: p_customer_profile_rec.cons_inv_flag := 'N';
1097: end if;
1098:
1099: -- If user passes NULL in update set value as in database

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

1102: end if;
1103:
1104: -- if cons_inv_flag is 'N', make cons_bill_level and cons_inv_type to NULL
1105: if p_customer_profile_rec.cons_inv_flag = 'N' then
1106: p_customer_profile_rec.cons_bill_level := FND_API.G_MISS_CHAR;
1107: p_customer_profile_rec.cons_inv_type := FND_API.G_MISS_CHAR;
1108: end if;
1109:
1110: -- Bill level is non updatable at site level

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

1103:
1104: -- if cons_inv_flag is 'N', make cons_bill_level and cons_inv_type to NULL
1105: if p_customer_profile_rec.cons_inv_flag = 'N' then
1106: p_customer_profile_rec.cons_bill_level := FND_API.G_MISS_CHAR;
1107: p_customer_profile_rec.cons_inv_type := FND_API.G_MISS_CHAR;
1108: end if;
1109:
1110: -- Bill level is non updatable at site level
1111: /*

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

1109:
1110: -- Bill level is non updatable at site level
1111: /*
1112: if l_site_use_id is NOT NULL AND
1113: p_customer_profile_rec.cons_bill_level <> FND_API.G_MISS_CHAR AND
1114: p_customer_profile_rec.cons_bill_level <> NVL(l_cons_bill_level, FND_API.G_MISS_CHAR) then
1115: FND_MESSAGE.SET_NAME('AR', 'HZ_API_SITE_BILL_LVL_NULL');
1116: FND_MSG_PUB.ADD;
1117: x_return_status := FND_API.G_RET_STS_ERROR;

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

1110: -- Bill level is non updatable at site level
1111: /*
1112: if l_site_use_id is NOT NULL AND
1113: p_customer_profile_rec.cons_bill_level <> FND_API.G_MISS_CHAR AND
1114: p_customer_profile_rec.cons_bill_level <> NVL(l_cons_bill_level, FND_API.G_MISS_CHAR) then
1115: FND_MESSAGE.SET_NAME('AR', 'HZ_API_SITE_BILL_LVL_NULL');
1116: FND_MSG_PUB.ADD;
1117: x_return_status := FND_API.G_RET_STS_ERROR;
1118: end if;

Line 1117: x_return_status := FND_API.G_RET_STS_ERROR;

1113: p_customer_profile_rec.cons_bill_level <> FND_API.G_MISS_CHAR AND
1114: p_customer_profile_rec.cons_bill_level <> NVL(l_cons_bill_level, FND_API.G_MISS_CHAR) then
1115: FND_MESSAGE.SET_NAME('AR', 'HZ_API_SITE_BILL_LVL_NULL');
1116: FND_MSG_PUB.ADD;
1117: x_return_status := FND_API.G_RET_STS_ERROR;
1118: end if;
1119: */
1120:
1121: -- if cons_inv_flag is changed from N to Y for a site level,

Line 1133: x_return_status := FND_API.G_RET_STS_ERROR;

1129: FETCH c_acct_use_profile_dtls INTO ll_cons_bill_level, ll_cons_inv_type;
1130: IF c_acct_use_profile_dtls%NOTFOUND THEN
1131: FND_MESSAGE.SET_NAME('AR', 'HZ_API_ENABLE_ACC_BAL_FWD_BILL');
1132: FND_MSG_PUB.ADD;
1133: x_return_status := FND_API.G_RET_STS_ERROR;
1134: END IF;
1135: p_customer_profile_rec.cons_bill_level := ll_cons_bill_level;
1136: if ( p_customer_profile_rec.cons_inv_type is NULL OR
1137: p_customer_profile_rec.cons_inv_type = FND_API.G_MISS_CHAR) then

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

1133: x_return_status := FND_API.G_RET_STS_ERROR;
1134: END IF;
1135: p_customer_profile_rec.cons_bill_level := ll_cons_bill_level;
1136: if ( p_customer_profile_rec.cons_inv_type is NULL OR
1137: p_customer_profile_rec.cons_inv_type = FND_API.G_MISS_CHAR) then
1138: p_customer_profile_rec.cons_inv_type := ll_cons_inv_type;
1139: end if;
1140: CLOSE c_acct_use_profile_dtls;
1141: end if;

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

1149: -- When cons_inv_flag is changed from 'N' to 'Y' or 'Y' to 'N'
1150: -- and profile class is not changed
1151: -- update the standard_terms of the profile to null
1152: if p_customer_profile_rec.cons_inv_flag IS NOT NULL AND
1153: p_customer_profile_rec.cons_inv_flag <> FND_API.G_MISS_CHAR AND
1154: p_customer_profile_rec.cons_inv_flag <> NVL(l_cons_inv_flag, FND_API.G_MISS_CHAR) AND
1155: l_profile_class_changed = 'N' then
1156: if (p_customer_profile_rec.standard_terms is NULL OR
1157: p_customer_profile_rec.standard_terms = nvl(l_standard_terms,-999111))

Line 1154: p_customer_profile_rec.cons_inv_flag <> NVL(l_cons_inv_flag, FND_API.G_MISS_CHAR) AND

1150: -- and profile class is not changed
1151: -- update the standard_terms of the profile to null
1152: if p_customer_profile_rec.cons_inv_flag IS NOT NULL AND
1153: p_customer_profile_rec.cons_inv_flag <> FND_API.G_MISS_CHAR AND
1154: p_customer_profile_rec.cons_inv_flag <> NVL(l_cons_inv_flag, FND_API.G_MISS_CHAR) AND
1155: l_profile_class_changed = 'N' then
1156: if (p_customer_profile_rec.standard_terms is NULL OR
1157: p_customer_profile_rec.standard_terms = nvl(l_standard_terms,-999111))
1158: then

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

1156: if (p_customer_profile_rec.standard_terms is NULL OR
1157: p_customer_profile_rec.standard_terms = nvl(l_standard_terms,-999111))
1158: then
1159: --l_standard_terms
1160: p_customer_profile_rec.standard_terms := FND_API.G_MISS_NUM;
1161: end if;
1162: end if;
1163:
1164: -- if late charge payment term or late charge type or message_text_id is NULL, get value from database.

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

1163:
1164: -- if late charge payment term or late charge type or message_text_id is NULL, get value from database.
1165: if p_customer_profile_rec.late_charge_term_id is NULL then
1166: p_customer_profile_rec.late_charge_term_id := l_late_charge_term_id;
1167: elsif p_customer_profile_rec.late_charge_term_id = FND_API.G_MISS_NUM then
1168: p_customer_profile_rec.late_charge_term_id := l_profile_class_rec.late_charge_term_id;
1169: end if;
1170: if p_customer_profile_rec.late_charge_type is NULL then
1171: p_customer_profile_rec.late_charge_type := l_late_charge_type;

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

1168: p_customer_profile_rec.late_charge_term_id := l_profile_class_rec.late_charge_term_id;
1169: end if;
1170: if p_customer_profile_rec.late_charge_type is NULL then
1171: p_customer_profile_rec.late_charge_type := l_late_charge_type;
1172: elsif p_customer_profile_rec.late_charge_type = FND_API.G_MISS_CHAR then
1173: p_customer_profile_rec.late_charge_type := l_profile_class_rec.late_charge_type;
1174: end if;
1175: if p_customer_profile_rec.message_text_id is NULL then
1176: p_customer_profile_rec.message_text_id := l_message_text_id;

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

1173: p_customer_profile_rec.late_charge_type := l_profile_class_rec.late_charge_type;
1174: end if;
1175: if p_customer_profile_rec.message_text_id is NULL then
1176: p_customer_profile_rec.message_text_id := l_message_text_id;
1177: elsif p_customer_profile_rec.message_text_id = FND_API.G_MISS_NUM then
1178: p_customer_profile_rec.message_text_id := l_profile_class_rec.message_text_id;
1179: end if;
1180:
1181: if p_customer_profile_rec.late_charge_type = 'ADJ' then

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

1178: p_customer_profile_rec.message_text_id := l_profile_class_rec.message_text_id;
1179: end if;
1180:
1181: if p_customer_profile_rec.late_charge_type = 'ADJ' then
1182: p_customer_profile_rec.late_charge_term_id := FND_API.G_MISS_NUM;
1183: p_customer_profile_rec.message_text_id := FND_API.G_MISS_NUM;
1184: end if;
1185:
1186: -- Validate customer profile record

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

1179: end if;
1180:
1181: if p_customer_profile_rec.late_charge_type = 'ADJ' then
1182: p_customer_profile_rec.late_charge_term_id := FND_API.G_MISS_NUM;
1183: p_customer_profile_rec.message_text_id := FND_API.G_MISS_NUM;
1184: end if;
1185:
1186: -- Validate customer profile record
1187: HZ_ACCOUNT_VALIDATE_V2PUB.validate_customer_profile (

Line 1193: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1189: p_customer_profile_rec => p_customer_profile_rec,
1190: p_rowid => l_rowid,
1191: x_return_status => x_return_status );
1192:
1193: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1194: RAISE FND_API.G_EXC_ERROR;
1195: END IF;
1196:
1197: -- Added rounding of payment_grace_days to integer for Late charge project.

Line 1194: RAISE FND_API.G_EXC_ERROR;

1190: p_rowid => l_rowid,
1191: x_return_status => x_return_status );
1192:
1193: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1194: RAISE FND_API.G_EXC_ERROR;
1195: END IF;
1196:
1197: -- Added rounding of payment_grace_days to integer for Late charge project.
1198: IF (p_customer_profile_rec.payment_grace_days is NOT NULL AND

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

1195: END IF;
1196:
1197: -- Added rounding of payment_grace_days to integer for Late charge project.
1198: IF (p_customer_profile_rec.payment_grace_days is NOT NULL AND
1199: p_customer_profile_rec.payment_grace_days <> FND_API.G_MISS_NUM) then
1200: p_customer_profile_rec.payment_grace_days := ROUND(p_customer_profile_rec.payment_grace_days,0);
1201: END IF;
1202:
1203: -- Added rounding of interest_period_days to integer for Late charge project.

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

1201: END IF;
1202:
1203: -- Added rounding of interest_period_days to integer for Late charge project.
1204: IF (p_customer_profile_rec.interest_period_days is NOT NULL AND
1205: p_customer_profile_rec.interest_period_days <> FND_API.G_MISS_NUM) then
1206: p_customer_profile_rec.interest_period_days := ROUND(p_customer_profile_rec.interest_period_days,0);
1207: END IF;
1208:
1209: -- Add logic for global holds

Line 1238: p_init_msg_list => FND_API.G_FALSE,

1234:
1235: BEGIN
1236: OE_Holds_PUB.Process_Holds (
1237: p_api_version => 1.0,
1238: p_init_msg_list => FND_API.G_FALSE,
1239: p_hold_entity_code => v_entity_code,
1240: p_hold_entity_id => v_entity_id,
1241: p_hold_id => 1,
1242: p_release_reason_code => 'AR_AUTOMATIC',

Line 1272: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1268:
1269: --
1270: -- only raise unexpected error
1271: --
1272: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1273: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1274: END IF;
1275: END IF;
1276: END IF; -- Bug 5606895

Line 1273: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1269: --
1270: -- only raise unexpected error
1271: --
1272: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1273: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1274: END IF;
1275: END IF;
1276: END IF; -- Bug 5606895
1277: -- Call table-handler.

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

1583: -- The currency does not exist, create new amount
1584: l_cust_profile_amt_rec.cust_acct_profile_amt_id := NULL;
1585:
1586: IF p_customer_profile_rec.created_by_module IS NOT NULL
1587: and p_customer_profile_rec.created_by_module <> fnd_api.g_miss_char THEN
1588: l_cust_profile_amt_rec.created_by_module := p_customer_profile_rec.created_by_module;
1589: ELSE
1590: -- if l_created_by_module is null, default to TCA_V2_API
1591: l_cust_profile_amt_rec.created_by_module := nvl(l_created_by_module, 'TCA_V2_API');

Line 1621: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1617: l_msg_data );
1618: END IF;
1619:
1620:
1621: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1622: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1623: RAISE FND_API.G_EXC_ERROR;
1624: ELSE
1625: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1622: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1618: END IF;
1619:
1620:
1621: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1622: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1623: RAISE FND_API.G_EXC_ERROR;
1624: ELSE
1625: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1626: END IF;

Line 1623: RAISE FND_API.G_EXC_ERROR;

1619:
1620:
1621: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1622: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1623: RAISE FND_API.G_EXC_ERROR;
1624: ELSE
1625: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1626: END IF;
1627: END IF;

Line 1625: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1621: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1622: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1623: RAISE FND_API.G_EXC_ERROR;
1624: ELSE
1625: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1626: END IF;
1627: END IF;
1628:
1629: END LOOP;

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

1661: * ARGUMENTS
1662: * IN:
1663: * p_check_foreign_key If do foreign key checking on cust_account_id
1664: * and cust_account_profile_id or not. Defaut value
1665: * is FND_API.G_TRUE, which means API will do foreign
1666: * key checking on these 2 columns.
1667: * IN/OUT:
1668: * p_cust_profile_amt_rec Customer profile amount record.
1669: * x_return_status Return status after the call. The status can

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

1666: * key checking on these 2 columns.
1667: * IN/OUT:
1668: * p_cust_profile_amt_rec Customer profile amount record.
1669: * x_return_status Return status after the call. The status can
1670: * be FND_API.G_RET_STS_SUCCESS (success),
1671: * FND_API.G_RET_STS_ERROR (error),
1672: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1673: * OUT:
1674: * x_cust_acct_profile_amt_id Customer account profile amount ID.

Line 1671: * FND_API.G_RET_STS_ERROR (error),

1667: * IN/OUT:
1668: * p_cust_profile_amt_rec Customer profile amount record.
1669: * x_return_status Return status after the call. The status can
1670: * be FND_API.G_RET_STS_SUCCESS (success),
1671: * FND_API.G_RET_STS_ERROR (error),
1672: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1673: * OUT:
1674: * x_cust_acct_profile_amt_id Customer account profile amount ID.
1675: *

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

1668: * p_cust_profile_amt_rec Customer profile amount record.
1669: * x_return_status Return status after the call. The status can
1670: * be FND_API.G_RET_STS_SUCCESS (success),
1671: * FND_API.G_RET_STS_ERROR (error),
1672: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1673: * OUT:
1674: * x_cust_acct_profile_amt_id Customer account profile amount ID.
1675: *
1676: * NOTES

Line 1710: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1706: p_cust_profile_amt_rec => p_cust_profile_amt_rec,
1707: p_rowid => NULL,
1708: x_return_status => x_return_status );
1709:
1710: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1711: RAISE FND_API.G_EXC_ERROR;
1712: END IF;
1713:
1714: -- Added rounding of min_fc_invoice_amount, min_fc_balance_amount, min_interest_charge,

Line 1711: RAISE FND_API.G_EXC_ERROR;

1707: p_rowid => NULL,
1708: x_return_status => x_return_status );
1709:
1710: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1711: RAISE FND_API.G_EXC_ERROR;
1712: END IF;
1713:
1714: -- Added rounding of min_fc_invoice_amount, min_fc_balance_amount, min_interest_charge,
1715: -- min_interest_charge, interest_fixed_amount and penalty_fixed_amount to 2 decimal places for Late charge project.

Line 1746: 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

1742: -- Bug 6472676
1743: -- Changed do_create_cust_profile_amt Procudure to get SITE_USE_ID value from Customer Profiles if
1744: -- Parameter CUST_PROFILE_AMT_REC containing null value in SITE_USE_ID.
1745:
1746: 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
1747: BEGIN
1748: SELECT site_use_id
1749: INTO l_site_use_id
1750: FROM hz_customer_profiles

Line 1758: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1754: p_cust_profile_amt_rec.site_use_id := l_site_use_id ;
1755:
1756: EXCEPTION
1757: WHEN OTHERS THEN
1758: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1759: END;
1760: END IF;
1761:
1762: -- Call table-handler.

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

1881: * IN/OUT:
1882: * p_cust_profile_amt_rec Customer profile amount record.
1883: * p_object_version_number Used for locking the being updated record.
1884: * x_return_status Return status after the call. The status can
1885: * be FND_API.G_RET_STS_SUCCESS (success),
1886: * FND_API.G_RET_STS_ERROR (error),
1887: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1888: *
1889: * NOTES

Line 1886: * FND_API.G_RET_STS_ERROR (error),

1882: * p_cust_profile_amt_rec Customer profile amount record.
1883: * p_object_version_number Used for locking the being updated record.
1884: * x_return_status Return status after the call. The status can
1885: * be FND_API.G_RET_STS_SUCCESS (success),
1886: * FND_API.G_RET_STS_ERROR (error),
1887: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1888: *
1889: * NOTES
1890: *

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

1883: * p_object_version_number Used for locking the being updated record.
1884: * x_return_status Return status after the call. The status can
1885: * be FND_API.G_RET_STS_SUCCESS (success),
1886: * FND_API.G_RET_STS_ERROR (error),
1887: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1888: *
1889: * NOTES
1890: *
1891: * MODIFICATION HISTORY

Line 1934: RAISE FND_API.G_EXC_ERROR;

1930: THEN
1931: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_RECORD_CHANGED' );
1932: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_cust_profile_amts' );
1933: FND_MSG_PUB.ADD;
1934: RAISE FND_API.G_EXC_ERROR;
1935: END IF;
1936:
1937: p_object_version_number := NVL( l_object_version_number, 1 ) + 1;
1938:

Line 1946: RAISE FND_API.G_EXC_ERROR;

1942: FND_MESSAGE.SET_TOKEN( 'RECORD', 'customer account profile amount' );
1943: FND_MESSAGE.SET_TOKEN( 'VALUE',
1944: NVL( TO_CHAR( p_cust_profile_amt_rec.cust_acct_profile_amt_id ), 'null' ) );
1945: FND_MSG_PUB.ADD;
1946: RAISE FND_API.G_EXC_ERROR;
1947: END;
1948:
1949: -- Validate cust profile amt record
1950: HZ_ACCOUNT_VALIDATE_V2PUB.validate_cust_profile_amt (

Line 1957: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1953: p_cust_profile_amt_rec => p_cust_profile_amt_rec,
1954: p_rowid => l_rowid,
1955: x_return_status => x_return_status );
1956:
1957: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1958: RAISE FND_API.G_EXC_ERROR;
1959: END IF;
1960:
1961: -- Added rounding of min_fc_invoice_amount, min_fc_balance_amount, min_interest_charge,

Line 1958: RAISE FND_API.G_EXC_ERROR;

1954: p_rowid => l_rowid,
1955: x_return_status => x_return_status );
1956:
1957: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1958: RAISE FND_API.G_EXC_ERROR;
1959: END IF;
1960:
1961: -- Added rounding of min_fc_invoice_amount, min_fc_balance_amount, min_interest_charge,
1962: -- min_interest_charge, interest_fixed_amount and penalty_fixed_amount to 2 decimal places for Late charge project.

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

2193: *
2194: * ARGUMENTS
2195: * IN:
2196: * p_init_msg_list Initialize message stack if it is set to
2197: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
2198: * p_customer_profile_rec Customer profile record. One customer account
2199: * must have a customer profile. One account site
2200: * use can optionally have one customer profile.
2201: * p_create_profile_amt If it is set to FND_API.G_TRUE, API create customer

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

2197: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
2198: * p_customer_profile_rec Customer profile record. One customer account
2199: * must have a customer profile. One account site
2200: * use can optionally have one customer profile.
2201: * p_create_profile_amt If it is set to FND_API.G_TRUE, API create customer
2202: * profile amounts by copying corresponding data
2203: * from customer profile class amounts.
2204: * IN/OUT:
2205: * OUT:

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

2204: * IN/OUT:
2205: * OUT:
2206: * x_cust_account_profile_id Customer account profile ID.
2207: * x_return_status Return status after the call. The status can
2208: * be FND_API.G_RET_STS_SUCCESS (success),
2209: * FND_API.G_RET_STS_ERROR (error),
2210: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
2211: * x_msg_count Number of messages in message stack.
2212: * x_msg_data Message text if x_msg_count is 1.

Line 2209: * FND_API.G_RET_STS_ERROR (error),

2205: * OUT:
2206: * x_cust_account_profile_id Customer account profile ID.
2207: * x_return_status Return status after the call. The status can
2208: * be FND_API.G_RET_STS_SUCCESS (success),
2209: * FND_API.G_RET_STS_ERROR (error),
2210: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
2211: * x_msg_count Number of messages in message stack.
2212: * x_msg_data Message text if x_msg_count is 1.
2213: *

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

2206: * x_cust_account_profile_id Customer account profile ID.
2207: * x_return_status Return status after the call. The status can
2208: * be FND_API.G_RET_STS_SUCCESS (success),
2209: * FND_API.G_RET_STS_ERROR (error),
2210: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
2211: * x_msg_count Number of messages in message stack.
2212: * x_msg_data Message text if x_msg_count is 1.
2213: *
2214: * NOTES

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

2219: *
2220: */
2221:
2222: PROCEDURE create_customer_profile (
2223: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2224: p_customer_profile_rec IN CUSTOMER_PROFILE_REC_TYPE,
2225: p_create_profile_amt IN VARCHAR2 := FND_API.G_TRUE,
2226: x_cust_account_profile_id OUT NOCOPY NUMBER,
2227: x_return_status OUT NOCOPY VARCHAR2,

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

2221:
2222: PROCEDURE create_customer_profile (
2223: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2224: p_customer_profile_rec IN CUSTOMER_PROFILE_REC_TYPE,
2225: p_create_profile_amt IN VARCHAR2 := FND_API.G_TRUE,
2226: x_cust_account_profile_id OUT NOCOPY NUMBER,
2227: x_return_status OUT NOCOPY VARCHAR2,
2228: x_msg_count OUT NOCOPY NUMBER,
2229: x_msg_data OUT NOCOPY VARCHAR2

Line 2251: IF FND_API.to_Boolean(p_init_msg_list) THEN

2247: p_msg_level=>fnd_log.level_procedure);
2248: END IF;
2249:
2250: -- Initialize message list if p_init_msg_list is set to TRUE.
2251: IF FND_API.to_Boolean(p_init_msg_list) THEN
2252: FND_MSG_PUB.initialize;
2253: END IF;
2254:
2255: -- Initialize API return status to success.

Line 2256: x_return_status := FND_API.G_RET_STS_SUCCESS;

2252: FND_MSG_PUB.initialize;
2253: END IF;
2254:
2255: -- Initialize API return status to success.
2256: x_return_status := FND_API.G_RET_STS_SUCCESS;
2257:
2258: -- Call to business logic.
2259: do_create_customer_profile (
2260: l_customer_profile_rec,

Line 2265: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

2261: p_create_profile_amt,
2262: x_cust_account_profile_id,
2263: x_return_status );
2264:
2265: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2266: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN
2267: -- Invoke business event system.
2268: HZ_BUSINESS_EVENT_V2PVT.create_customer_profile_event (
2269: l_customer_profile_rec,

Line 2282: p_encoded => FND_API.G_FALSE,

2278: END IF;
2279:
2280: -- Standard call to get message count and if count is 1, get message info.
2281: FND_MSG_PUB.Count_And_Get(
2282: p_encoded => FND_API.G_FALSE,
2283: p_count => x_msg_count,
2284: p_data => x_msg_data );
2285:
2286: -- Debug info.

Line 2303: WHEN FND_API.G_EXC_ERROR THEN

2299: -- Check if API is called in debug mode. If yes, disable debug.
2300: --disable_debug;
2301:
2302: EXCEPTION
2303: WHEN FND_API.G_EXC_ERROR THEN
2304: ROLLBACK TO create_customer_profile;
2305: x_return_status := FND_API.G_RET_STS_ERROR;
2306:
2307: FND_MSG_PUB.Count_And_Get(

Line 2305: x_return_status := FND_API.G_RET_STS_ERROR;

2301:
2302: EXCEPTION
2303: WHEN FND_API.G_EXC_ERROR THEN
2304: ROLLBACK TO create_customer_profile;
2305: x_return_status := FND_API.G_RET_STS_ERROR;
2306:
2307: FND_MSG_PUB.Count_And_Get(
2308: p_encoded => FND_API.G_FALSE,
2309: p_count => x_msg_count,

Line 2308: p_encoded => FND_API.G_FALSE,

2304: ROLLBACK TO create_customer_profile;
2305: x_return_status := FND_API.G_RET_STS_ERROR;
2306:
2307: FND_MSG_PUB.Count_And_Get(
2308: p_encoded => FND_API.G_FALSE,
2309: p_count => x_msg_count,
2310: p_data => x_msg_data );
2311:
2312: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

Line 2327: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2323:
2324: -- Check if API is called in debug mode. If yes, disable debug.
2325: --disable_debug;
2326:
2327: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2328: ROLLBACK TO create_customer_profile;
2329: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2330:
2331: FND_MSG_PUB.Count_And_Get(

Line 2329: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2325: --disable_debug;
2326:
2327: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2328: ROLLBACK TO create_customer_profile;
2329: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2330:
2331: FND_MSG_PUB.Count_And_Get(
2332: p_encoded => FND_API.G_FALSE,
2333: p_count => x_msg_count,

Line 2332: p_encoded => FND_API.G_FALSE,

2328: ROLLBACK TO create_customer_profile;
2329: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2330:
2331: FND_MSG_PUB.Count_And_Get(
2332: p_encoded => FND_API.G_FALSE,
2333: p_count => x_msg_count,
2334: p_data => x_msg_data );
2335:
2336: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

Line 2353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2349: --disable_debug;
2350:
2351: WHEN OTHERS THEN
2352: ROLLBACK TO create_customer_profile;
2353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2354:
2355: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2356: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2357: FND_MSG_PUB.ADD;

Line 2360: p_encoded => FND_API.G_FALSE,

2356: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2357: FND_MSG_PUB.ADD;
2358:
2359: FND_MSG_PUB.Count_And_Get(
2360: p_encoded => FND_API.G_FALSE,
2361: p_count => x_msg_count,
2362: p_data => x_msg_data );
2363:
2364: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

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

2389: *
2390: * ARGUMENTS
2391: * IN:
2392: * p_init_msg_list Initialize message stack if it is set to
2393: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
2394: * p_customer_profile_rec Customer profile record. One customer account
2395: * must have a customer profile. One account site
2396: * use can optionally have one customer profile.
2397: * IN/OUT:

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

2397: * IN/OUT:
2398: * p_object_version_number Used for locking the being updated record.
2399: * OUT:
2400: * x_return_status Return status after the call. The status can
2401: * be FND_API.G_RET_STS_SUCCESS (success),
2402: * FND_API.G_RET_STS_ERROR (error),
2403: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
2404: * x_msg_count Number of messages in message stack.
2405: * x_msg_data Message text if x_msg_count is 1.

Line 2402: * FND_API.G_RET_STS_ERROR (error),

2398: * p_object_version_number Used for locking the being updated record.
2399: * OUT:
2400: * x_return_status Return status after the call. The status can
2401: * be FND_API.G_RET_STS_SUCCESS (success),
2402: * FND_API.G_RET_STS_ERROR (error),
2403: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
2404: * x_msg_count Number of messages in message stack.
2405: * x_msg_data Message text if x_msg_count is 1.
2406: *

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

2399: * OUT:
2400: * x_return_status Return status after the call. The status can
2401: * be FND_API.G_RET_STS_SUCCESS (success),
2402: * FND_API.G_RET_STS_ERROR (error),
2403: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
2404: * x_msg_count Number of messages in message stack.
2405: * x_msg_data Message text if x_msg_count is 1.
2406: *
2407: * NOTES

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

2412: *
2413: */
2414:
2415: PROCEDURE update_customer_profile (
2416: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2417: p_customer_profile_rec IN CUSTOMER_PROFILE_REC_TYPE,
2418: p_object_version_number IN OUT NOCOPY NUMBER,
2419: x_return_status OUT NOCOPY VARCHAR2,
2420: x_msg_count OUT NOCOPY NUMBER,

Line 2444: IF FND_API.to_Boolean(p_init_msg_list) THEN

2440: p_msg_level=>fnd_log.level_procedure);
2441: END IF;
2442:
2443: -- Initialize message list if p_init_msg_list is set to TRUE.
2444: IF FND_API.to_Boolean(p_init_msg_list) THEN
2445: FND_MSG_PUB.initialize;
2446: END IF;
2447:
2448: -- Initialize API return status to success.

Line 2449: x_return_status := FND_API.G_RET_STS_SUCCESS;

2445: FND_MSG_PUB.initialize;
2446: END IF;
2447:
2448: -- Initialize API return status to success.
2449: x_return_status := FND_API.G_RET_STS_SUCCESS;
2450:
2451: --2290537
2452: get_customer_profile_rec (
2453: p_cust_account_profile_id => p_customer_profile_rec.cust_account_profile_id,

Line 2459: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

2455: x_return_status => x_return_status,
2456: x_msg_count => x_msg_count,
2457: x_msg_data => x_msg_data);
2458:
2459: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2460: RAISE FND_API.G_EXC_ERROR;
2461: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2462: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2463: END IF;

Line 2460: RAISE FND_API.G_EXC_ERROR;

2456: x_msg_count => x_msg_count,
2457: x_msg_data => x_msg_data);
2458:
2459: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2460: RAISE FND_API.G_EXC_ERROR;
2461: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2462: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2463: END IF;
2464:

Line 2461: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2457: x_msg_data => x_msg_data);
2458:
2459: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2460: RAISE FND_API.G_EXC_ERROR;
2461: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2462: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2463: END IF;
2464:
2465: -- Call to business logic.

Line 2462: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2458:
2459: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2460: RAISE FND_API.G_EXC_ERROR;
2461: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2462: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2463: END IF;
2464:
2465: -- Call to business logic.
2466: do_update_customer_profile (

Line 2471: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

2467: l_customer_profile_rec,
2468: p_object_version_number,
2469: x_return_status );
2470:
2471: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2472: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN
2473: -- Invoke business event system.
2474: HZ_BUSINESS_EVENT_V2PVT.update_customer_profile_event (
2475: l_customer_profile_rec , l_old_customer_profile_rec);

Line 2487: p_encoded => FND_API.G_FALSE,

2483: END IF;
2484:
2485: -- Standard call to get message count and if count is 1, get message info.
2486: FND_MSG_PUB.Count_And_Get(
2487: p_encoded => FND_API.G_FALSE,
2488: p_count => x_msg_count,
2489: p_data => x_msg_data );
2490:
2491: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

Line 2507: WHEN FND_API.G_EXC_ERROR THEN

2503: -- Check if API is called in debug mode. If yes, disable debug.
2504: --disable_debug;
2505:
2506: EXCEPTION
2507: WHEN FND_API.G_EXC_ERROR THEN
2508: ROLLBACK TO update_customer_profile;
2509: x_return_status := FND_API.G_RET_STS_ERROR;
2510:
2511: FND_MSG_PUB.Count_And_Get(

Line 2509: x_return_status := FND_API.G_RET_STS_ERROR;

2505:
2506: EXCEPTION
2507: WHEN FND_API.G_EXC_ERROR THEN
2508: ROLLBACK TO update_customer_profile;
2509: x_return_status := FND_API.G_RET_STS_ERROR;
2510:
2511: FND_MSG_PUB.Count_And_Get(
2512: p_encoded => FND_API.G_FALSE,
2513: p_count => x_msg_count,

Line 2512: p_encoded => FND_API.G_FALSE,

2508: ROLLBACK TO update_customer_profile;
2509: x_return_status := FND_API.G_RET_STS_ERROR;
2510:
2511: FND_MSG_PUB.Count_And_Get(
2512: p_encoded => FND_API.G_FALSE,
2513: p_count => x_msg_count,
2514: p_data => x_msg_data );
2515:
2516: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

Line 2531: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2527:
2528: -- Check if API is called in debug mode. If yes, disable debug.
2529: --disable_debug;
2530:
2531: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2532: ROLLBACK TO update_customer_profile;
2533: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2534:
2535: FND_MSG_PUB.Count_And_Get(

Line 2533: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2529: --disable_debug;
2530:
2531: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2532: ROLLBACK TO update_customer_profile;
2533: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2534:
2535: FND_MSG_PUB.Count_And_Get(
2536: p_encoded => FND_API.G_FALSE,
2537: p_count => x_msg_count,

Line 2536: p_encoded => FND_API.G_FALSE,

2532: ROLLBACK TO update_customer_profile;
2533: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2534:
2535: FND_MSG_PUB.Count_And_Get(
2536: p_encoded => FND_API.G_FALSE,
2537: p_count => x_msg_count,
2538: p_data => x_msg_data );
2539:
2540: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

Line 2557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2553: --disable_debug;
2554:
2555: WHEN OTHERS THEN
2556: ROLLBACK TO update_customer_profile;
2557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2558:
2559: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2560: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2561: FND_MSG_PUB.ADD;

Line 2564: p_encoded => FND_API.G_FALSE,

2560: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2561: FND_MSG_PUB.ADD;
2562:
2563: FND_MSG_PUB.Count_And_Get(
2564: p_encoded => FND_API.G_FALSE,
2565: p_count => x_msg_count,
2566: p_data => x_msg_data );
2567:
2568: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

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

2593: *
2594: * ARGUMENTS
2595: * IN:
2596: * p_init_msg_list Initialize message stack if it is set to
2597: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
2598: * p_cust_account_profile_id Customer account profile id.
2599: * IN/OUT:
2600: * OUT:
2601: * x_customer_profile_rec Returned customer profile record.

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

2599: * IN/OUT:
2600: * OUT:
2601: * x_customer_profile_rec Returned customer profile record.
2602: * x_return_status Return status after the call. The status can
2603: * be FND_API.G_RET_STS_SUCCESS (success),
2604: * FND_API.G_RET_STS_ERROR (error),
2605: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
2606: * x_msg_count Number of messages in message stack.
2607: * x_msg_data Message text if x_msg_count is 1.

Line 2604: * FND_API.G_RET_STS_ERROR (error),

2600: * OUT:
2601: * x_customer_profile_rec Returned customer profile record.
2602: * x_return_status Return status after the call. The status can
2603: * be FND_API.G_RET_STS_SUCCESS (success),
2604: * FND_API.G_RET_STS_ERROR (error),
2605: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
2606: * x_msg_count Number of messages in message stack.
2607: * x_msg_data Message text if x_msg_count is 1.
2608: *

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

2601: * x_customer_profile_rec Returned customer profile record.
2602: * x_return_status Return status after the call. The status can
2603: * be FND_API.G_RET_STS_SUCCESS (success),
2604: * FND_API.G_RET_STS_ERROR (error),
2605: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
2606: * x_msg_count Number of messages in message stack.
2607: * x_msg_data Message text if x_msg_count is 1.
2608: *
2609: * NOTES

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

2614: *
2615: */
2616:
2617: PROCEDURE get_customer_profile_rec (
2618: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2619: p_cust_account_profile_id IN NUMBER,
2620: x_customer_profile_rec OUT NOCOPY CUSTOMER_PROFILE_REC_TYPE,
2621: x_return_status OUT NOCOPY VARCHAR2,
2622: x_msg_count OUT NOCOPY NUMBER,

Line 2639: IF FND_API.to_Boolean(p_init_msg_list) THEN

2635: p_msg_level=>fnd_log.level_procedure);
2636: END IF;
2637:
2638: -- Initialize message list if p_init_msg_list is set to TRUE.
2639: IF FND_API.to_Boolean(p_init_msg_list) THEN
2640: FND_MSG_PUB.initialize;
2641: END IF;
2642:
2643: -- Initialize API return status to success.

Line 2644: x_return_status := FND_API.G_RET_STS_SUCCESS;

2640: FND_MSG_PUB.initialize;
2641: END IF;
2642:
2643: -- Initialize API return status to success.
2644: x_return_status := FND_API.G_RET_STS_SUCCESS;
2645:
2646: -- Check whether primary key has been passed in.
2647: IF p_cust_account_profile_id IS NULL OR
2648: p_cust_account_profile_id = FND_API.G_MISS_NUM THEN

Line 2648: p_cust_account_profile_id = FND_API.G_MISS_NUM THEN

2644: x_return_status := FND_API.G_RET_STS_SUCCESS;
2645:
2646: -- Check whether primary key has been passed in.
2647: IF p_cust_account_profile_id IS NULL OR
2648: p_cust_account_profile_id = FND_API.G_MISS_NUM THEN
2649: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2650: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'cust_account_profile_id' );
2651: FND_MSG_PUB.ADD;
2652: RAISE FND_API.G_EXC_ERROR;

Line 2652: RAISE FND_API.G_EXC_ERROR;

2648: p_cust_account_profile_id = FND_API.G_MISS_NUM THEN
2649: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2650: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'cust_account_profile_id' );
2651: FND_MSG_PUB.ADD;
2652: RAISE FND_API.G_EXC_ERROR;
2653: END IF;
2654:
2655: x_customer_profile_rec.cust_account_profile_id := p_cust_account_profile_id;
2656:

Line 2786: p_encoded => FND_API.G_FALSE,

2782: END IF;
2783:
2784: -- Standard call to get message count and if count is 1, get message info.
2785: FND_MSG_PUB.Count_And_Get(
2786: p_encoded => FND_API.G_FALSE,
2787: p_count => x_msg_count,
2788: p_data => x_msg_data );
2789:
2790: -- Debug info.

Line 2807: WHEN FND_API.G_EXC_ERROR THEN

2803: -- Check if API is called in debug mode. If yes, disable debug.
2804: --disable_debug;
2805:
2806: EXCEPTION
2807: WHEN FND_API.G_EXC_ERROR THEN
2808: x_return_status := FND_API.G_RET_STS_ERROR;
2809:
2810: FND_MSG_PUB.Count_And_Get(
2811: p_encoded => FND_API.G_FALSE,

Line 2808: x_return_status := FND_API.G_RET_STS_ERROR;

2804: --disable_debug;
2805:
2806: EXCEPTION
2807: WHEN FND_API.G_EXC_ERROR THEN
2808: x_return_status := FND_API.G_RET_STS_ERROR;
2809:
2810: FND_MSG_PUB.Count_And_Get(
2811: p_encoded => FND_API.G_FALSE,
2812: p_count => x_msg_count,

Line 2811: p_encoded => FND_API.G_FALSE,

2807: WHEN FND_API.G_EXC_ERROR THEN
2808: x_return_status := FND_API.G_RET_STS_ERROR;
2809:
2810: FND_MSG_PUB.Count_And_Get(
2811: p_encoded => FND_API.G_FALSE,
2812: p_count => x_msg_count,
2813: p_data => x_msg_data );
2814:
2815: -- Debug info.

Line 2831: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2827:
2828: -- Check if API is called in debug mode. If yes, disable debug.
2829: --disable_debug;
2830:
2831: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2832: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2833:
2834: FND_MSG_PUB.Count_And_Get(
2835: p_encoded => FND_API.G_FALSE,

Line 2832: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2828: -- Check if API is called in debug mode. If yes, disable debug.
2829: --disable_debug;
2830:
2831: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2832: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2833:
2834: FND_MSG_PUB.Count_And_Get(
2835: p_encoded => FND_API.G_FALSE,
2836: p_count => x_msg_count,

Line 2835: p_encoded => FND_API.G_FALSE,

2831: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2832: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2833:
2834: FND_MSG_PUB.Count_And_Get(
2835: p_encoded => FND_API.G_FALSE,
2836: p_count => x_msg_count,
2837: p_data => x_msg_data );
2838:
2839: -- Debug info.

Line 2856: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2852: -- Check if API is called in debug mode. If yes, disable debug.
2853: --disable_debug;
2854:
2855: WHEN OTHERS THEN
2856: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2857:
2858: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2859: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2860: FND_MSG_PUB.ADD;

Line 2863: p_encoded => FND_API.G_FALSE,

2859: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2860: FND_MSG_PUB.ADD;
2861:
2862: FND_MSG_PUB.Count_And_Get(
2863: p_encoded => FND_API.G_FALSE,
2864: p_count => x_msg_count,
2865: p_data => x_msg_data );
2866:
2867: -- Debug info.

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

2893: *
2894: * ARGUMENTS
2895: * IN:
2896: * p_init_msg_list Initialize message stack if it is set to
2897: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
2898: * p_check_foreign_key If do foreign key checking on cust_account_id
2899: * and cust_account_profile_id or not. Defaut value
2900: * is FND_API.G_TRUE, which means API will do foreign
2901: * key checking on these 2 columns.

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

2896: * p_init_msg_list Initialize message stack if it is set to
2897: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
2898: * p_check_foreign_key If do foreign key checking on cust_account_id
2899: * and cust_account_profile_id or not. Defaut value
2900: * is FND_API.G_TRUE, which means API will do foreign
2901: * key checking on these 2 columns.
2902: * p_cust_profile_amt_rec Customer profile amount record.
2903: * IN/OUT:
2904: * OUT:

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

2903: * IN/OUT:
2904: * OUT:
2905: * x_cust_acct_profile_amt_id Customer account profile amount ID.
2906: * x_return_status Return status after the call. The status can
2907: * be FND_API.G_RET_STS_SUCCESS (success),
2908: * FND_API.G_RET_STS_ERROR (error),
2909: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
2910: * x_msg_count Number of messages in message stack.
2911: * x_msg_data Message text if x_msg_count is 1.

Line 2908: * FND_API.G_RET_STS_ERROR (error),

2904: * OUT:
2905: * x_cust_acct_profile_amt_id Customer account profile amount ID.
2906: * x_return_status Return status after the call. The status can
2907: * be FND_API.G_RET_STS_SUCCESS (success),
2908: * FND_API.G_RET_STS_ERROR (error),
2909: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
2910: * x_msg_count Number of messages in message stack.
2911: * x_msg_data Message text if x_msg_count is 1.
2912: *

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

2905: * x_cust_acct_profile_amt_id Customer account profile amount ID.
2906: * x_return_status Return status after the call. The status can
2907: * be FND_API.G_RET_STS_SUCCESS (success),
2908: * FND_API.G_RET_STS_ERROR (error),
2909: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
2910: * x_msg_count Number of messages in message stack.
2911: * x_msg_data Message text if x_msg_count is 1.
2912: *
2913: * NOTES

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

2919: */
2920:
2921:
2922: PROCEDURE create_cust_profile_amt (
2923: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2924: p_check_foreign_key IN VARCHAR2 := FND_API.G_TRUE,
2925: p_cust_profile_amt_rec IN CUST_PROFILE_AMT_REC_TYPE,
2926: x_cust_acct_profile_amt_id OUT NOCOPY NUMBER,
2927: x_return_status OUT NOCOPY VARCHAR2,

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

2920:
2921:
2922: PROCEDURE create_cust_profile_amt (
2923: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2924: p_check_foreign_key IN VARCHAR2 := FND_API.G_TRUE,
2925: p_cust_profile_amt_rec IN CUST_PROFILE_AMT_REC_TYPE,
2926: x_cust_acct_profile_amt_id OUT NOCOPY NUMBER,
2927: x_return_status OUT NOCOPY VARCHAR2,
2928: x_msg_count OUT NOCOPY NUMBER,

Line 2951: IF FND_API.to_Boolean(p_init_msg_list) THEN

2947: p_msg_level=>fnd_log.level_procedure);
2948: END IF;
2949:
2950: -- Initialize message list if p_init_msg_list is set to TRUE.
2951: IF FND_API.to_Boolean(p_init_msg_list) THEN
2952: FND_MSG_PUB.initialize;
2953: END IF;
2954:
2955: -- Initialize API return status to success.

Line 2956: x_return_status := FND_API.G_RET_STS_SUCCESS;

2952: FND_MSG_PUB.initialize;
2953: END IF;
2954:
2955: -- Initialize API return status to success.
2956: x_return_status := FND_API.G_RET_STS_SUCCESS;
2957:
2958: -- Call to business logic.
2959: do_create_cust_profile_amt (
2960: p_check_foreign_key,

Line 2965: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

2961: l_cust_profile_amt_rec,
2962: x_cust_acct_profile_amt_id,
2963: x_return_status );
2964:
2965: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2966: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN
2967: -- Invoke business event system.
2968: HZ_BUSINESS_EVENT_V2PVT.create_cust_profile_amt_event (
2969: l_cust_profile_amt_rec );

Line 2981: p_encoded => FND_API.G_FALSE,

2977: END IF;
2978:
2979: -- Standard call to get message count and if count is 1, get message info.
2980: FND_MSG_PUB.Count_And_Get(
2981: p_encoded => FND_API.G_FALSE,
2982: p_count => x_msg_count,
2983: p_data => x_msg_data );
2984:
2985: -- Debug info.

Line 3002: WHEN FND_API.G_EXC_ERROR THEN

2998: -- Check if API is called in debug mode. If yes, disable debug.
2999: --disable_debug;
3000:
3001: EXCEPTION
3002: WHEN FND_API.G_EXC_ERROR THEN
3003: ROLLBACK TO create_cust_profile_amt;
3004: x_return_status := FND_API.G_RET_STS_ERROR;
3005:
3006: FND_MSG_PUB.Count_And_Get(

Line 3004: x_return_status := FND_API.G_RET_STS_ERROR;

3000:
3001: EXCEPTION
3002: WHEN FND_API.G_EXC_ERROR THEN
3003: ROLLBACK TO create_cust_profile_amt;
3004: x_return_status := FND_API.G_RET_STS_ERROR;
3005:
3006: FND_MSG_PUB.Count_And_Get(
3007: p_encoded => FND_API.G_FALSE,
3008: p_count => x_msg_count,

Line 3007: p_encoded => FND_API.G_FALSE,

3003: ROLLBACK TO create_cust_profile_amt;
3004: x_return_status := FND_API.G_RET_STS_ERROR;
3005:
3006: FND_MSG_PUB.Count_And_Get(
3007: p_encoded => FND_API.G_FALSE,
3008: p_count => x_msg_count,
3009: p_data => x_msg_data );
3010:
3011: -- Debug info.

Line 3027: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3023:
3024: -- Check if API is called in debug mode. If yes, disable debug.
3025: --disable_debug;
3026:
3027: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3028: ROLLBACK TO create_cust_profile_amt;
3029: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3030:
3031: FND_MSG_PUB.Count_And_Get(

Line 3029: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3025: --disable_debug;
3026:
3027: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3028: ROLLBACK TO create_cust_profile_amt;
3029: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3030:
3031: FND_MSG_PUB.Count_And_Get(
3032: p_encoded => FND_API.G_FALSE,
3033: p_count => x_msg_count,

Line 3032: p_encoded => FND_API.G_FALSE,

3028: ROLLBACK TO create_cust_profile_amt;
3029: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3030:
3031: FND_MSG_PUB.Count_And_Get(
3032: p_encoded => FND_API.G_FALSE,
3033: p_count => x_msg_count,
3034: p_data => x_msg_data );
3035:
3036: -- Debug info.

Line 3054: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3050: --disable_debug;
3051:
3052: WHEN OTHERS THEN
3053: ROLLBACK TO create_cust_profile_amt;
3054: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3055:
3056: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
3057: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3058: FND_MSG_PUB.ADD;

Line 3061: p_encoded => FND_API.G_FALSE,

3057: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3058: FND_MSG_PUB.ADD;
3059:
3060: FND_MSG_PUB.Count_And_Get(
3061: p_encoded => FND_API.G_FALSE,
3062: p_count => x_msg_count,
3063: p_data => x_msg_data );
3064:
3065: -- Debug info.

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

3092: *
3093: * ARGUMENTS
3094: * IN:
3095: * p_init_msg_list Initialize message stack if it is set to
3096: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
3097: * p_cust_profile_amt_rec Customer profile amount record.
3098: * IN/OUT:
3099: * p_object_version_number Used for locking the being updated record.
3100: * OUT:

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

3098: * IN/OUT:
3099: * p_object_version_number Used for locking the being updated record.
3100: * OUT:
3101: * x_return_status Return status after the call. The status can
3102: * be FND_API.G_RET_STS_SUCCESS (success),
3103: * FND_API.G_RET_STS_ERROR (error),
3104: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
3105: * x_msg_count Number of messages in message stack.
3106: * x_msg_data Message text if x_msg_count is 1.

Line 3103: * FND_API.G_RET_STS_ERROR (error),

3099: * p_object_version_number Used for locking the being updated record.
3100: * OUT:
3101: * x_return_status Return status after the call. The status can
3102: * be FND_API.G_RET_STS_SUCCESS (success),
3103: * FND_API.G_RET_STS_ERROR (error),
3104: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
3105: * x_msg_count Number of messages in message stack.
3106: * x_msg_data Message text if x_msg_count is 1.
3107: *

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

3100: * OUT:
3101: * x_return_status Return status after the call. The status can
3102: * be FND_API.G_RET_STS_SUCCESS (success),
3103: * FND_API.G_RET_STS_ERROR (error),
3104: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
3105: * x_msg_count Number of messages in message stack.
3106: * x_msg_data Message text if x_msg_count is 1.
3107: *
3108: * NOTES

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

3113: *
3114: */
3115:
3116: PROCEDURE update_cust_profile_amt (
3117: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3118: p_cust_profile_amt_rec IN CUST_PROFILE_AMT_REC_TYPE,
3119: p_object_version_number IN OUT NOCOPY NUMBER,
3120: x_return_status OUT NOCOPY VARCHAR2,
3121: x_msg_count OUT NOCOPY NUMBER,

Line 3145: IF FND_API.to_Boolean(p_init_msg_list) THEN

3141: p_msg_level=>fnd_log.level_procedure);
3142: END IF;
3143:
3144: -- Initialize message list if p_init_msg_list is set to TRUE.
3145: IF FND_API.to_Boolean(p_init_msg_list) THEN
3146: FND_MSG_PUB.initialize;
3147: END IF;
3148:
3149: -- Initialize API return status to success.

Line 3150: x_return_status := FND_API.G_RET_STS_SUCCESS;

3146: FND_MSG_PUB.initialize;
3147: END IF;
3148:
3149: -- Initialize API return status to success.
3150: x_return_status := FND_API.G_RET_STS_SUCCESS;
3151:
3152: --2290537
3153: get_cust_profile_amt_rec (
3154: p_cust_acct_profile_amt_id => p_cust_profile_amt_rec.cust_acct_profile_amt_id,

Line 3160: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

3156: x_return_status => x_return_status,
3157: x_msg_count => x_msg_count,
3158: x_msg_data => x_msg_data);
3159:
3160: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3161: RAISE FND_API.G_EXC_ERROR;
3162: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3164: END IF;

Line 3161: RAISE FND_API.G_EXC_ERROR;

3157: x_msg_count => x_msg_count,
3158: x_msg_data => x_msg_data);
3159:
3160: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3161: RAISE FND_API.G_EXC_ERROR;
3162: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3164: END IF;
3165:

Line 3162: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3158: x_msg_data => x_msg_data);
3159:
3160: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3161: RAISE FND_API.G_EXC_ERROR;
3162: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3164: END IF;
3165:
3166: -- Call to business logic.

Line 3163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3159:
3160: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3161: RAISE FND_API.G_EXC_ERROR;
3162: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3164: END IF;
3165:
3166: -- Call to business logic.
3167: do_update_cust_profile_amt (

Line 3172: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

3168: l_cust_profile_amt_rec,
3169: p_object_version_number,
3170: x_return_status );
3171:
3172: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
3173: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN
3174: -- Invoke business event system.
3175: HZ_BUSINESS_EVENT_V2PVT.update_cust_profile_amt_event (
3176: l_cust_profile_amt_rec , l_old_cust_profile_amt_rec );

Line 3188: p_encoded => FND_API.G_FALSE,

3184: END IF;
3185:
3186: -- Standard call to get message count and if count is 1, get message info.
3187: FND_MSG_PUB.Count_And_Get(
3188: p_encoded => FND_API.G_FALSE,
3189: p_count => x_msg_count,
3190: p_data => x_msg_data );
3191:
3192: -- Debug info.

Line 3210: WHEN FND_API.G_EXC_ERROR THEN

3206: -- Check if API is called in debug mode. If yes, disable debug.
3207: --disable_debug;
3208:
3209: EXCEPTION
3210: WHEN FND_API.G_EXC_ERROR THEN
3211: ROLLBACK TO update_cust_profile_amt;
3212: x_return_status := FND_API.G_RET_STS_ERROR;
3213:
3214: FND_MSG_PUB.Count_And_Get(

Line 3212: x_return_status := FND_API.G_RET_STS_ERROR;

3208:
3209: EXCEPTION
3210: WHEN FND_API.G_EXC_ERROR THEN
3211: ROLLBACK TO update_cust_profile_amt;
3212: x_return_status := FND_API.G_RET_STS_ERROR;
3213:
3214: FND_MSG_PUB.Count_And_Get(
3215: p_encoded => FND_API.G_FALSE,
3216: p_count => x_msg_count,

Line 3215: p_encoded => FND_API.G_FALSE,

3211: ROLLBACK TO update_cust_profile_amt;
3212: x_return_status := FND_API.G_RET_STS_ERROR;
3213:
3214: FND_MSG_PUB.Count_And_Get(
3215: p_encoded => FND_API.G_FALSE,
3216: p_count => x_msg_count,
3217: p_data => x_msg_data );
3218:
3219: -- Debug info.

Line 3235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3231:
3232: -- Check if API is called in debug mode. If yes, disable debug.
3233: --disable_debug;
3234:
3235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3236: ROLLBACK TO update_cust_profile_amt;
3237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3238:
3239: FND_MSG_PUB.Count_And_Get(

Line 3237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3233: --disable_debug;
3234:
3235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3236: ROLLBACK TO update_cust_profile_amt;
3237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3238:
3239: FND_MSG_PUB.Count_And_Get(
3240: p_encoded => FND_API.G_FALSE,
3241: p_count => x_msg_count,

Line 3240: p_encoded => FND_API.G_FALSE,

3236: ROLLBACK TO update_cust_profile_amt;
3237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3238:
3239: FND_MSG_PUB.Count_And_Get(
3240: p_encoded => FND_API.G_FALSE,
3241: p_count => x_msg_count,
3242: p_data => x_msg_data );
3243:
3244: -- Debug info.

Line 3262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3258: --disable_debug;
3259:
3260: WHEN OTHERS THEN
3261: ROLLBACK TO update_cust_profile_amt;
3262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3263:
3264: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
3265: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3266: FND_MSG_PUB.ADD;

Line 3269: p_encoded => FND_API.G_FALSE,

3265: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3266: FND_MSG_PUB.ADD;
3267:
3268: FND_MSG_PUB.Count_And_Get(
3269: p_encoded => FND_API.G_FALSE,
3270: p_count => x_msg_count,
3271: p_data => x_msg_data );
3272:
3273: -- Debug info.

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

3299: *
3300: * ARGUMENTS
3301: * IN:
3302: * p_init_msg_list Initialize message stack if it is set to
3303: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
3304: * p_cust_acct_profile_amt_id Customer account profile amount id.
3305: * IN/OUT:
3306: * OUT:
3307: * x_cust_profile_amt_rec Returned customer profile amount record.

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

3305: * IN/OUT:
3306: * OUT:
3307: * x_cust_profile_amt_rec Returned customer profile amount record.
3308: * x_return_status Return status after the call. The status can
3309: * be FND_API.G_RET_STS_SUCCESS (success),
3310: * FND_API.G_RET_STS_ERROR (error),
3311: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
3312: * x_msg_count Number of messages in message stack.
3313: * x_msg_data Message text if x_msg_count is 1.

Line 3310: * FND_API.G_RET_STS_ERROR (error),

3306: * OUT:
3307: * x_cust_profile_amt_rec Returned customer profile amount record.
3308: * x_return_status Return status after the call. The status can
3309: * be FND_API.G_RET_STS_SUCCESS (success),
3310: * FND_API.G_RET_STS_ERROR (error),
3311: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
3312: * x_msg_count Number of messages in message stack.
3313: * x_msg_data Message text if x_msg_count is 1.
3314: *

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

3307: * x_cust_profile_amt_rec Returned customer profile amount record.
3308: * x_return_status Return status after the call. The status can
3309: * be FND_API.G_RET_STS_SUCCESS (success),
3310: * FND_API.G_RET_STS_ERROR (error),
3311: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
3312: * x_msg_count Number of messages in message stack.
3313: * x_msg_data Message text if x_msg_count is 1.
3314: *
3315: * NOTES

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

3320: *
3321: */
3322:
3323: PROCEDURE get_cust_profile_amt_rec (
3324: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3325: p_cust_acct_profile_amt_id IN NUMBER,
3326: x_cust_profile_amt_rec OUT NOCOPY CUST_PROFILE_AMT_REC_TYPE,
3327: x_return_status OUT NOCOPY VARCHAR2,
3328: x_msg_count OUT NOCOPY NUMBER,

Line 3345: IF FND_API.to_Boolean(p_init_msg_list) THEN

3341: p_msg_level=>fnd_log.level_procedure);
3342: END IF;
3343:
3344: -- Initialize message list if p_init_msg_list is set to TRUE.
3345: IF FND_API.to_Boolean(p_init_msg_list) THEN
3346: FND_MSG_PUB.initialize;
3347: END IF;
3348:
3349: -- Initialize API return status to success.

Line 3350: x_return_status := FND_API.G_RET_STS_SUCCESS;

3346: FND_MSG_PUB.initialize;
3347: END IF;
3348:
3349: -- Initialize API return status to success.
3350: x_return_status := FND_API.G_RET_STS_SUCCESS;
3351:
3352: -- Check whether primary key has been passed in.
3353: IF p_cust_acct_profile_amt_id IS NULL OR
3354: p_cust_acct_profile_amt_id = FND_API.G_MISS_NUM THEN

Line 3354: p_cust_acct_profile_amt_id = FND_API.G_MISS_NUM THEN

3350: x_return_status := FND_API.G_RET_STS_SUCCESS;
3351:
3352: -- Check whether primary key has been passed in.
3353: IF p_cust_acct_profile_amt_id IS NULL OR
3354: p_cust_acct_profile_amt_id = FND_API.G_MISS_NUM THEN
3355: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
3356: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'cust_acct_profile_amt_id' );
3357: FND_MSG_PUB.ADD;
3358: RAISE FND_API.G_EXC_ERROR;

Line 3358: RAISE FND_API.G_EXC_ERROR;

3354: p_cust_acct_profile_amt_id = FND_API.G_MISS_NUM THEN
3355: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
3356: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'cust_acct_profile_amt_id' );
3357: FND_MSG_PUB.ADD;
3358: RAISE FND_API.G_EXC_ERROR;
3359: END IF;
3360:
3361: x_cust_profile_amt_rec.cust_acct_profile_amt_id := p_cust_acct_profile_amt_id;
3362:

Line 3467: p_encoded => FND_API.G_FALSE,

3463: END IF;
3464:
3465: -- Standard call to get message count and if count is 1, get message info.
3466: FND_MSG_PUB.Count_And_Get(
3467: p_encoded => FND_API.G_FALSE,
3468: p_count => x_msg_count,
3469: p_data => x_msg_data );
3470:
3471: -- Debug info.

Line 3488: WHEN FND_API.G_EXC_ERROR THEN

3484: -- Check if API is called in debug mode. If yes, disable debug.
3485: --disable_debug;
3486:
3487: EXCEPTION
3488: WHEN FND_API.G_EXC_ERROR THEN
3489: x_return_status := FND_API.G_RET_STS_ERROR;
3490:
3491: FND_MSG_PUB.Count_And_Get(
3492: p_encoded => FND_API.G_FALSE,

Line 3489: x_return_status := FND_API.G_RET_STS_ERROR;

3485: --disable_debug;
3486:
3487: EXCEPTION
3488: WHEN FND_API.G_EXC_ERROR THEN
3489: x_return_status := FND_API.G_RET_STS_ERROR;
3490:
3491: FND_MSG_PUB.Count_And_Get(
3492: p_encoded => FND_API.G_FALSE,
3493: p_count => x_msg_count,

Line 3492: p_encoded => FND_API.G_FALSE,

3488: WHEN FND_API.G_EXC_ERROR THEN
3489: x_return_status := FND_API.G_RET_STS_ERROR;
3490:
3491: FND_MSG_PUB.Count_And_Get(
3492: p_encoded => FND_API.G_FALSE,
3493: p_count => x_msg_count,
3494: p_data => x_msg_data );
3495:
3496: -- Debug info.

Line 3512: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3508:
3509: -- Check if API is called in debug mode. If yes, disable debug.
3510: --disable_debug;
3511:
3512: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3513: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3514:
3515: FND_MSG_PUB.Count_And_Get(
3516: p_encoded => FND_API.G_FALSE,

Line 3513: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3509: -- Check if API is called in debug mode. If yes, disable debug.
3510: --disable_debug;
3511:
3512: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3513: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3514:
3515: FND_MSG_PUB.Count_And_Get(
3516: p_encoded => FND_API.G_FALSE,
3517: p_count => x_msg_count,

Line 3516: p_encoded => FND_API.G_FALSE,

3512: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3513: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3514:
3515: FND_MSG_PUB.Count_And_Get(
3516: p_encoded => FND_API.G_FALSE,
3517: p_count => x_msg_count,
3518: p_data => x_msg_data );
3519:
3520: -- Debug info.

Line 3537: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3533: -- Check if API is called in debug mode. If yes, disable debug.
3534: --disable_debug;
3535:
3536: WHEN OTHERS THEN
3537: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3538:
3539: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
3540: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3541: FND_MSG_PUB.ADD;

Line 3544: p_encoded => FND_API.G_FALSE,

3540: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3541: FND_MSG_PUB.ADD;
3542:
3543: FND_MSG_PUB.Count_And_Get(
3544: p_encoded => FND_API.G_FALSE,
3545: p_count => x_msg_count,
3546: p_data => x_msg_data );
3547:
3548: -- Debug info.