324:
325:
326: IF G_ONT_ADD_CUSTOMER = 'N' THEN /* Nothing allowed */
327:
328: fnd_message.set_name('ONT','ONT_OI_INL_SET_PARAMETER');
329: fnd_message.set_token('TYPE', 'Customers, Addresses or Contacts');
330: oe_msg_pub.add;
331: x_return_status := FND_API.G_RET_STS_ERROR;
332: RETURN;
325:
326: IF G_ONT_ADD_CUSTOMER = 'N' THEN /* Nothing allowed */
327:
328: fnd_message.set_name('ONT','ONT_OI_INL_SET_PARAMETER');
329: fnd_message.set_token('TYPE', 'Customers, Addresses or Contacts');
330: oe_msg_pub.add;
331: x_return_status := FND_API.G_RET_STS_ERROR;
332: RETURN;
333:
870: IF l_ship_addr_found THEN
871:
872: IF NOT IS_VALID_ID( p_customer_id => l_customer_id ) THEN
873: x_return_status := FND_API.G_RET_STS_ERROR;
874: FND_MESSAGE.set_name('ONT','OE_INVALID_ATTRIBUTE');
875: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CUSTOMER_ID');
876: OE_MSG_PUB.Add;
877: RETURN;
878: END IF;
871:
872: IF NOT IS_VALID_ID( p_customer_id => l_customer_id ) THEN
873: x_return_status := FND_API.G_RET_STS_ERROR;
874: FND_MESSAGE.set_name('ONT','OE_INVALID_ATTRIBUTE');
875: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CUSTOMER_ID');
876: OE_MSG_PUB.Add;
877: RETURN;
878: END IF;
879:
946: IF l_bill_addr_found THEN
947:
948: IF NOT IS_VALID_ID( p_customer_id => l_customer_id ) THEN
949: x_return_status := FND_API.G_RET_STS_ERROR;
950: FND_MESSAGE.set_name('ONT','OE_INVALID_ATTRIBUTE');
951: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CUSTOMER_ID');
952: OE_MSG_PUB.Add;
953: RETURN;
954: END IF;
947:
948: IF NOT IS_VALID_ID( p_customer_id => l_customer_id ) THEN
949: x_return_status := FND_API.G_RET_STS_ERROR;
950: FND_MESSAGE.set_name('ONT','OE_INVALID_ATTRIBUTE');
951: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CUSTOMER_ID');
952: OE_MSG_PUB.Add;
953: RETURN;
954: END IF;
955:
1021: IF l_deliver_addr_found THEN
1022:
1023: IF NOT IS_VALID_ID( p_customer_id => l_customer_id ) THEN
1024: x_return_status := FND_API.G_RET_STS_ERROR;
1025: FND_MESSAGE.set_name('ONT','OE_INVALID_ATTRIBUTE');
1026: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CUSTOMER_ID');
1027: OE_MSG_PUB.Add;
1028: RETURN;
1029: END IF;
1022:
1023: IF NOT IS_VALID_ID( p_customer_id => l_customer_id ) THEN
1024: x_return_status := FND_API.G_RET_STS_ERROR;
1025: FND_MESSAGE.set_name('ONT','OE_INVALID_ATTRIBUTE');
1026: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CUSTOMER_ID');
1027: OE_MSG_PUB.Add;
1028: RETURN;
1029: END IF;
1030:
1096: IF l_sold_addr_found THEN
1097:
1098: IF NOT IS_VALID_ID( p_customer_id => l_customer_id ) THEN
1099: x_return_status := FND_API.G_RET_STS_ERROR;
1100: FND_MESSAGE.set_name('ONT','OE_INVALID_ATTRIBUTE');
1101: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CUSTOMER_ID');
1102: OE_MSG_PUB.Add;
1103: RETURN;
1104: END IF;
1097:
1098: IF NOT IS_VALID_ID( p_customer_id => l_customer_id ) THEN
1099: x_return_status := FND_API.G_RET_STS_ERROR;
1100: FND_MESSAGE.set_name('ONT','OE_INVALID_ATTRIBUTE');
1101: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CUSTOMER_ID');
1102: OE_MSG_PUB.Add;
1103: RETURN;
1104: END IF;
1105:
1175: IF l_sold_cont_found THEN
1176:
1177: IF NOT IS_VALID_ID( p_customer_id => l_customer_id ) THEN
1178: x_return_status := FND_API.G_RET_STS_ERROR;
1179: FND_MESSAGE.set_name('ONT','OE_INVALID_ATTRIBUTE');
1180: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CUSTOMER_ID');
1181: OE_MSG_PUB.Add;
1182: RETURN;
1183: END IF;
1176:
1177: IF NOT IS_VALID_ID( p_customer_id => l_customer_id ) THEN
1178: x_return_status := FND_API.G_RET_STS_ERROR;
1179: FND_MESSAGE.set_name('ONT','OE_INVALID_ATTRIBUTE');
1180: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CUSTOMER_ID');
1181: OE_MSG_PUB.Add;
1182: RETURN;
1183: END IF;
1184:
1246: IF l_ship_cont_found THEN
1247:
1248: IF NOT IS_VALID_ID( p_customer_id => l_customer_id ) THEN
1249: x_return_status := FND_API.G_RET_STS_ERROR;
1250: FND_MESSAGE.set_name('ONT','OE_INVALID_ATTRIBUTE');
1251: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CUSTOMER_ID');
1252: OE_MSG_PUB.Add;
1253: RETURN;
1254: END IF;
1247:
1248: IF NOT IS_VALID_ID( p_customer_id => l_customer_id ) THEN
1249: x_return_status := FND_API.G_RET_STS_ERROR;
1250: FND_MESSAGE.set_name('ONT','OE_INVALID_ATTRIBUTE');
1251: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CUSTOMER_ID');
1252: OE_MSG_PUB.Add;
1253: RETURN;
1254: END IF;
1255:
1319: IF l_bill_cont_found THEN
1320:
1321: IF NOT IS_VALID_ID( p_customer_id => l_customer_id ) THEN
1322: x_return_status := FND_API.G_RET_STS_ERROR;
1323: FND_MESSAGE.set_name('ONT','OE_INVALID_ATTRIBUTE');
1324: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CUSTOMER_ID');
1325: OE_MSG_PUB.Add;
1326: RETURN;
1327: END IF;
1320:
1321: IF NOT IS_VALID_ID( p_customer_id => l_customer_id ) THEN
1322: x_return_status := FND_API.G_RET_STS_ERROR;
1323: FND_MESSAGE.set_name('ONT','OE_INVALID_ATTRIBUTE');
1324: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CUSTOMER_ID');
1325: OE_MSG_PUB.Add;
1326: RETURN;
1327: END IF;
1328:
1391: IF l_deliver_cont_found THEN
1392:
1393: IF NOT IS_VALID_ID( p_customer_id => l_customer_id ) THEN
1394: x_return_status := FND_API.G_RET_STS_ERROR;
1395: FND_MESSAGE.set_name('ONT','OE_INVALID_ATTRIBUTE');
1396: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CUSTOMER_ID');
1397: OE_MSG_PUB.Add;
1398: RETURN;
1399: END IF;
1392:
1393: IF NOT IS_VALID_ID( p_customer_id => l_customer_id ) THEN
1394: x_return_status := FND_API.G_RET_STS_ERROR;
1395: FND_MESSAGE.set_name('ONT','OE_INVALID_ATTRIBUTE');
1396: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CUSTOMER_ID');
1397: OE_MSG_PUB.Add;
1398: RETURN;
1399: END IF;
1400:
1518:
1519: IF IS_VALID_ID ( p_party_id => l_customer_info_rec.party_id) THEN
1520: l_party_id := l_customer_info_rec.party_id;
1521: ELSE
1522: FND_MESSAGE.set_name('ONT','OE_INVALID_ATTRIBUTE');
1523: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','PARTY_ID');
1524: OE_MSG_PUB.Add;
1525: x_return_status := FND_API.G_RET_STS_ERROR;
1526:
1519: IF IS_VALID_ID ( p_party_id => l_customer_info_rec.party_id) THEN
1520: l_party_id := l_customer_info_rec.party_id;
1521: ELSE
1522: FND_MESSAGE.set_name('ONT','OE_INVALID_ATTRIBUTE');
1523: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','PARTY_ID');
1524: OE_MSG_PUB.Add;
1525: x_return_status := FND_API.G_RET_STS_ERROR;
1526:
1527: END IF;
2688:
2689: x_return_status := FND_API.G_RET_STS_SUCCESS;
2690:
2691: IF p_customer_record.customer_type IS NULL THEN
2692: fnd_message.set_name('ONT','ONT_PO_INL_REQD');
2693: fnd_message.set_token('API_NAME', 'CREATE_ACCOUNT');
2694: fnd_message.set_token('FIELD_REQD', 'CUSTOMER_TYPE');
2695: oe_msg_pub.add;
2696: x_return_status := FND_API.G_RET_STS_ERROR;
2689: x_return_status := FND_API.G_RET_STS_SUCCESS;
2690:
2691: IF p_customer_record.customer_type IS NULL THEN
2692: fnd_message.set_name('ONT','ONT_PO_INL_REQD');
2693: fnd_message.set_token('API_NAME', 'CREATE_ACCOUNT');
2694: fnd_message.set_token('FIELD_REQD', 'CUSTOMER_TYPE');
2695: oe_msg_pub.add;
2696: x_return_status := FND_API.G_RET_STS_ERROR;
2697:
2690:
2691: IF p_customer_record.customer_type IS NULL THEN
2692: fnd_message.set_name('ONT','ONT_PO_INL_REQD');
2693: fnd_message.set_token('API_NAME', 'CREATE_ACCOUNT');
2694: fnd_message.set_token('FIELD_REQD', 'CUSTOMER_TYPE');
2695: oe_msg_pub.add;
2696: x_return_status := FND_API.G_RET_STS_ERROR;
2697:
2698: IF l_debug_level > 0 THEN
2705: IF ( p_customer_record.customer_type = 'ORGANIZATION'
2706: AND p_customer_record.organization_name IS NULL
2707: )
2708: THEN
2709: fnd_message.set_name('ONT','ONT_PO_INL_REQD');
2710: fnd_message.set_token('API_NAME', 'CREATE_ACCOUNT');
2711: fnd_message.set_token('FIELD_REQD', 'ORGANIZATION_NAME');
2712: oe_msg_pub.add;
2713: x_return_status := FND_API.G_RET_STS_ERROR;
2706: AND p_customer_record.organization_name IS NULL
2707: )
2708: THEN
2709: fnd_message.set_name('ONT','ONT_PO_INL_REQD');
2710: fnd_message.set_token('API_NAME', 'CREATE_ACCOUNT');
2711: fnd_message.set_token('FIELD_REQD', 'ORGANIZATION_NAME');
2712: oe_msg_pub.add;
2713: x_return_status := FND_API.G_RET_STS_ERROR;
2714:
2707: )
2708: THEN
2709: fnd_message.set_name('ONT','ONT_PO_INL_REQD');
2710: fnd_message.set_token('API_NAME', 'CREATE_ACCOUNT');
2711: fnd_message.set_token('FIELD_REQD', 'ORGANIZATION_NAME');
2712: oe_msg_pub.add;
2713: x_return_status := FND_API.G_RET_STS_ERROR;
2714:
2715: IF l_debug_level > 0 THEN
2724: AND p_customer_record.person_first_name IS NULL
2725: AND p_customer_record.person_last_name IS NULL
2726: )
2727: THEN
2728: fnd_message.set_name('ONT','ONT_PO_INL_REQD');
2729: fnd_message.set_token('API_NAME', 'CREATE_ACCOUNT');
2730: fnd_message.set_token('FIELD_REQD', 'PERSON_FIRST_NAME');
2731: oe_msg_pub.add;
2732: x_return_status := FND_API.G_RET_STS_ERROR;
2725: AND p_customer_record.person_last_name IS NULL
2726: )
2727: THEN
2728: fnd_message.set_name('ONT','ONT_PO_INL_REQD');
2729: fnd_message.set_token('API_NAME', 'CREATE_ACCOUNT');
2730: fnd_message.set_token('FIELD_REQD', 'PERSON_FIRST_NAME');
2731: oe_msg_pub.add;
2732: x_return_status := FND_API.G_RET_STS_ERROR;
2733:
2726: )
2727: THEN
2728: fnd_message.set_name('ONT','ONT_PO_INL_REQD');
2729: fnd_message.set_token('API_NAME', 'CREATE_ACCOUNT');
2730: fnd_message.set_token('FIELD_REQD', 'PERSON_FIRST_NAME');
2731: oe_msg_pub.add;
2732: x_return_status := FND_API.G_RET_STS_ERROR;
2733:
2734: IF l_debug_level > 0 THEN
2740:
2741:
2742: IF G_EMAIL_REQUIRED = 'Y' and
2743: p_customer_record.email_address is NULL THEN
2744: fnd_message.set_name('ONT','ONT_PO_INL_REQD');
2745: fnd_message.set_token('API_NAME', 'CREATE_ACCOUNT');
2746: fnd_message.set_token('FIELD_REQD', 'EMAIL_ADDRESS');
2747: oe_msg_pub.add;
2748: x_return_status := FND_API.G_RET_STS_ERROR;
2741:
2742: IF G_EMAIL_REQUIRED = 'Y' and
2743: p_customer_record.email_address is NULL THEN
2744: fnd_message.set_name('ONT','ONT_PO_INL_REQD');
2745: fnd_message.set_token('API_NAME', 'CREATE_ACCOUNT');
2746: fnd_message.set_token('FIELD_REQD', 'EMAIL_ADDRESS');
2747: oe_msg_pub.add;
2748: x_return_status := FND_API.G_RET_STS_ERROR;
2749:
2742: IF G_EMAIL_REQUIRED = 'Y' and
2743: p_customer_record.email_address is NULL THEN
2744: fnd_message.set_name('ONT','ONT_PO_INL_REQD');
2745: fnd_message.set_token('API_NAME', 'CREATE_ACCOUNT');
2746: fnd_message.set_token('FIELD_REQD', 'EMAIL_ADDRESS');
2747: oe_msg_pub.add;
2748: x_return_status := FND_API.G_RET_STS_ERROR;
2749:
2750: IF l_debug_level > 0 THEN
2754:
2755: IF G_AUTO_PARTY_NUMBERING = 'N' and
2756: p_customer_record.party_number IS NULL Then
2757:
2758: fnd_message.set_name('ONT','ONT_PO_INL_REQD');
2759: fnd_message.set_token('API_NAME', 'CREATE_ACCOUNT');
2760: fnd_message.set_token('FIELD_REQD', 'PARTY_NUMBER');
2761: oe_msg_pub.add;
2762: x_return_status := FND_API.G_RET_STS_ERROR;
2755: IF G_AUTO_PARTY_NUMBERING = 'N' and
2756: p_customer_record.party_number IS NULL Then
2757:
2758: fnd_message.set_name('ONT','ONT_PO_INL_REQD');
2759: fnd_message.set_token('API_NAME', 'CREATE_ACCOUNT');
2760: fnd_message.set_token('FIELD_REQD', 'PARTY_NUMBER');
2761: oe_msg_pub.add;
2762: x_return_status := FND_API.G_RET_STS_ERROR;
2763:
2756: p_customer_record.party_number IS NULL Then
2757:
2758: fnd_message.set_name('ONT','ONT_PO_INL_REQD');
2759: fnd_message.set_token('API_NAME', 'CREATE_ACCOUNT');
2760: fnd_message.set_token('FIELD_REQD', 'PARTY_NUMBER');
2761: oe_msg_pub.add;
2762: x_return_status := FND_API.G_RET_STS_ERROR;
2763:
2764: IF l_debug_level > 0 THEN
2769:
2770: IF G_AUTO_CUST_NUMBERING = 'N' and
2771: p_customer_record.customer_number IS NULL THEN
2772:
2773: fnd_message.set_name('ONT','ONT_PO_INL_REQD');
2774: fnd_message.set_token('API_NAME', 'CREATE_ACCOUNT');
2775: fnd_message.set_token('FIELD_REQD', 'CUSTOMER_NUMBER');
2776: oe_msg_pub.add;
2777: x_return_status := FND_API.G_RET_STS_ERROR;
2770: IF G_AUTO_CUST_NUMBERING = 'N' and
2771: p_customer_record.customer_number IS NULL THEN
2772:
2773: fnd_message.set_name('ONT','ONT_PO_INL_REQD');
2774: fnd_message.set_token('API_NAME', 'CREATE_ACCOUNT');
2775: fnd_message.set_token('FIELD_REQD', 'CUSTOMER_NUMBER');
2776: oe_msg_pub.add;
2777: x_return_status := FND_API.G_RET_STS_ERROR;
2778:
2771: p_customer_record.customer_number IS NULL THEN
2772:
2773: fnd_message.set_name('ONT','ONT_PO_INL_REQD');
2774: fnd_message.set_token('API_NAME', 'CREATE_ACCOUNT');
2775: fnd_message.set_token('FIELD_REQD', 'CUSTOMER_NUMBER');
2776: oe_msg_pub.add;
2777: x_return_status := FND_API.G_RET_STS_ERROR;
2778:
2779: IF l_debug_level > 0 THEN
2795: BEGIN
2796: x_return_status := FND_API.G_RET_STS_SUCCESS;
2797:
2798: IF p_customer_record.customer_type NOT IN ('ORGANIZATION','PERSON') THEN
2799: FND_MESSAGE.set_name('ONT','OE_INVALID_ATTRIBUTE');
2800: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','PARTY_ID');
2801: OE_MSG_PUB.Add;
2802: x_return_status := FND_API.G_RET_STS_ERROR;
2803: END IF;
2796: x_return_status := FND_API.G_RET_STS_SUCCESS;
2797:
2798: IF p_customer_record.customer_type NOT IN ('ORGANIZATION','PERSON') THEN
2799: FND_MESSAGE.set_name('ONT','OE_INVALID_ATTRIBUTE');
2800: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','PARTY_ID');
2801: OE_MSG_PUB.Add;
2802: x_return_status := FND_API.G_RET_STS_ERROR;
2803: END IF;
2804:
3060: IF p_contact_record.person_first_name IS NULL
3061: AND p_contact_record.person_last_name IS NULL
3062:
3063: THEN
3064: fnd_message.set_name('ONT','ONT_PO_INL_REQD');
3065: fnd_message.set_token('API_NAME', 'CREATE_CONTACT');
3066: fnd_message.set_token('FIELD_REQD', 'PERSON_FIRST_NAME');
3067: oe_msg_pub.add;
3068: x_return_status := FND_API.G_RET_STS_ERROR;
3061: AND p_contact_record.person_last_name IS NULL
3062:
3063: THEN
3064: fnd_message.set_name('ONT','ONT_PO_INL_REQD');
3065: fnd_message.set_token('API_NAME', 'CREATE_CONTACT');
3066: fnd_message.set_token('FIELD_REQD', 'PERSON_FIRST_NAME');
3067: oe_msg_pub.add;
3068: x_return_status := FND_API.G_RET_STS_ERROR;
3069:
3062:
3063: THEN
3064: fnd_message.set_name('ONT','ONT_PO_INL_REQD');
3065: fnd_message.set_token('API_NAME', 'CREATE_CONTACT');
3066: fnd_message.set_token('FIELD_REQD', 'PERSON_FIRST_NAME');
3067: oe_msg_pub.add;
3068: x_return_status := FND_API.G_RET_STS_ERROR;
3069:
3070: END IF;
3082: x_return_status := FND_API.G_RET_STS_SUCCESS;
3083:
3084: IF G_AUTO_CONTACT_NUMBERING = 'N' THEN
3085: IF p_contact_record.contact_number IS NULL THEN
3086: fnd_message.set_name('ONT','ONT_PO_INL_REQD');
3087: fnd_message.set_token('API_NAME', 'CREATE_CONTACT');
3088: fnd_message.set_token('FIELD_REQD', 'CONTACT_NUMBER');
3089: oe_msg_pub.add;
3090: x_return_status := FND_API.G_RET_STS_ERROR;
3083:
3084: IF G_AUTO_CONTACT_NUMBERING = 'N' THEN
3085: IF p_contact_record.contact_number IS NULL THEN
3086: fnd_message.set_name('ONT','ONT_PO_INL_REQD');
3087: fnd_message.set_token('API_NAME', 'CREATE_CONTACT');
3088: fnd_message.set_token('FIELD_REQD', 'CONTACT_NUMBER');
3089: oe_msg_pub.add;
3090: x_return_status := FND_API.G_RET_STS_ERROR;
3091: END IF;
3084: IF G_AUTO_CONTACT_NUMBERING = 'N' THEN
3085: IF p_contact_record.contact_number IS NULL THEN
3086: fnd_message.set_name('ONT','ONT_PO_INL_REQD');
3087: fnd_message.set_token('API_NAME', 'CREATE_CONTACT');
3088: fnd_message.set_token('FIELD_REQD', 'CONTACT_NUMBER');
3089: oe_msg_pub.add;
3090: x_return_status := FND_API.G_RET_STS_ERROR;
3091: END IF;
3092: END IF;
3244: WHEN OTHERS THEN
3245: IF l_debug_level > 0 THEN
3246: oe_debug_pub.add('Unable to retrive the location_id for the site_use_id :'||p_site_use_id||'and site_usage_code :'||p_site_usage_code);
3247: END IF;
3248: FND_MESSAGE.set_name('ONT','OE_INVALID_ATTRIBUTE');
3249: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','SITE_USE_ID');
3250: OE_MSG_PUB.Add;
3251: return FND_API.G_MISS_NUM;
3252: END Get_Location_id;
3245: IF l_debug_level > 0 THEN
3246: oe_debug_pub.add('Unable to retrive the location_id for the site_use_id :'||p_site_use_id||'and site_usage_code :'||p_site_usage_code);
3247: END IF;
3248: FND_MESSAGE.set_name('ONT','OE_INVALID_ATTRIBUTE');
3249: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','SITE_USE_ID');
3250: OE_MSG_PUB.Add;
3251: return FND_API.G_MISS_NUM;
3252: END Get_Location_id;
3253:
3907: AND ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_contact_rec.contact_id;
3908:
3909: Exception
3910: WHEN OTHERS THEN
3911: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3912: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CONTACT_ID');
3913: OE_MSG_PUB.Add;
3914: x_return_status := FND_API.G_RET_STS_ERROR;
3915: End;
3908:
3909: Exception
3910: WHEN OTHERS THEN
3911: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3912: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CONTACT_ID');
3913: OE_MSG_PUB.Add;
3914: x_return_status := FND_API.G_RET_STS_ERROR;
3915: End;
3916: