APPS.OE_INLINE_CUSTOMER_PUB dependencies on FND_API

Line 6: G_INITIALIZED VARCHAR2(1) := FND_API.G_FALSE;

2: /* $Header: OEXPINLB.pls 120.7.12010000.2 2008/11/14 11:57:23 ckasera ship $ */
3:
4: -- { Start of Global Variable used in Api
5:
6: G_INITIALIZED VARCHAR2(1) := FND_API.G_FALSE;
7: G_EMAIL_REQUIRED VARCHAR2(1) := 'N';
8: G_AUTO_PARTY_NUMBERING VARCHAR2(1) := 'N';
9: G_AUTO_CUST_NUMBERING VARCHAR2(1) := 'N';
10: G_AUTO_CONTACT_NUMBERING VARCHAR2(1) := 'N';

Line 30: x_return_status := FND_API.G_RET_STS_SUCCESS;

26:
27: IF l_debug_level > 0 THEN
28: oe_debug_pub.add( 'ENTERING PROCEDURE INITIALIZE_GLOBAL' ) ;
29: END IF;
30: x_return_status := FND_API.G_RET_STS_SUCCESS;
31:
32: -- { Start of the ar_system_parameters select and assignment
33:
34: IF oe_code_control.code_release_level < '110510' THEN

Line 69: G_INITIALIZED := FND_API.G_TRUE;

65: G_AUTO_CONTACT_NUMBERING := nvl(G_AUTO_CONTACT_NUMBERING,'Y');
66: G_AUTO_SITE_NUMBERING := nvl(G_AUTO_SITE_NUMBERING, 'Y');
67:
68: -- End for global values from profile }
69: G_INITIALIZED := FND_API.G_TRUE;
70: IF l_debug_level > 0 THEN
71: oe_debug_pub.add( 'EXITING PROCEDURE INITIALIZE_GLOBAL' ) ;
72: END IF;
73: Exception

Line 75: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

71: oe_debug_pub.add( 'EXITING PROCEDURE INITIALIZE_GLOBAL' ) ;
72: END IF;
73: Exception
74: When Others Then
75: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
76: IF l_debug_level > 0 THEN
77: oe_debug_pub.add( 'PROBLEM IN CALL TO INITIALIZE_GLOBAL. ABORT PROCESSING' ) ;
78: END IF;
79: IF l_debug_level > 0 THEN

Line 121: x_return_status := FND_API.G_RET_STS_SUCCESS;

117:
118: IF l_debug_level > 0 THEN
119: oe_debug_pub.add( 'AFTER SELECT OF PARTY INFO.' ) ;
120: END IF;
121: x_return_status := FND_API.G_RET_STS_SUCCESS;
122:
123: IF l_debug_level > 0 THEN
124: oe_debug_pub.add( 'EXITING VALIDATE PARTY NUMBER API WITH PARTY ID' ) ;
125: END IF;

Line 128: x_return_status := FND_API.G_RET_STS_SUCCESS;

124: oe_debug_pub.add( 'EXITING VALIDATE PARTY NUMBER API WITH PARTY ID' ) ;
125: END IF;
126: Exception
127: When No_Data_Found Then
128: x_return_status := FND_API.G_RET_STS_SUCCESS;
129: IF l_debug_level > 0 THEN
130: oe_debug_pub.add( 'EXITING VALIDATE PARTY NUMBER API WITHOUT PARTY ID' ) ;
131: END IF;
132: When Others Then

Line 133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

129: IF l_debug_level > 0 THEN
130: oe_debug_pub.add( 'EXITING VALIDATE PARTY NUMBER API WITHOUT PARTY ID' ) ;
131: END IF;
132: When Others Then
133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
134: IF l_debug_level > 0 THEN
135: oe_debug_pub.add( 'PROBLEM IN CALL TO VALIDATE PARTY. ABORT PROCESSING' ) ;
136: END IF;
137: IF l_debug_level > 0 THEN

Line 315: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

311:
312: IF l_debug_level > 0 THEN
313: oe_debug_pub.add( 'RETURN STATS ' || L_RETURN_STATUS ) ;
314: END IF;
315: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
316: IF l_debug_level > 0 THEN
317: oe_debug_pub.add( 'RETURN ERROR MESSAGE COUNT FROM HZ ' || OE_MSG_PUB.GET ( P_MSG_INDEX => X_MSG_COUNT ) ) ;
318: END IF;
319: IF l_debug_level > 0 THEN

Line 340: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

336: oe_debug_pub.add( 'EXITING PROCEDURE CREATE_CUST_RELATIONSHIP' ) ;
337: END IF;
338: EXCEPTION
339: When Others Then
340: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
341: IF l_debug_level > 0 THEN
342: oe_debug_pub.add( 'PROBLEM IN CALL TO CREATE_CUST_RELATIONSHIP. ABORT PROCESSING' ) ;
343: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
344: END IF;

Line 484: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

480: -- Let us check the status of the call to hz api
481: IF l_debug_level > 0 THEN
482: oe_debug_pub.add( 'RETURN STATS ' || L_RETURN_STATUS ) ;
483: END IF;
484: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
485: IF l_debug_level > 0 THEN
486: oe_debug_pub.add( 'RETURN ERROR MESSAGE COUNT FROM HZ ' || OE_MSG_PUB.GET ( P_MSG_INDEX => L_MSG_COUNT ) ) ;
487: END IF;
488: IF l_debug_level > 0 THEN

Line 522: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

518: END IF;
519:
520: EXCEPTION
521: WHEN others then
522: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
523: If c_cust_acct_role%ISOPEN then
524: CLOSE c_cust_acct_role;
525: End If;
526: If c_usage_type%ISOPEN then

Line 577: x_return_status := FND_API.G_RET_STS_SUCCESS;

573: IF l_debug_level > 0 THEN
574: oe_debug_pub.add( 'ENTERING CREATE CONTACT POINT API' ) ;
575: END IF;
576:
577: x_return_status := FND_API.G_RET_STS_SUCCESS;
578: l_contact_points_rec.contact_point_type := p_contact_point_type;
579: l_contact_points_rec.status := 'A';
580: l_contact_points_rec.owner_table_name := 'HZ_PARTIES';
581: l_contact_points_rec.owner_table_id := p_owner_table_id;

Line 610: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

606: -- Let us check the status of the call to hz api
607: IF l_debug_level > 0 THEN
608: oe_debug_pub.add( 'RETURN STATS ' || L_RETURN_STATUS ) ;
609: END IF;
610: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
611: IF l_debug_level > 0 THEN
612: oe_debug_pub.add( 'RETURN ERROR MESSAGE COUNT FROM HZ ' || OE_MSG_PUB.GET ( P_MSG_INDEX => X_MSG_COUNT ) ) ;
613: END IF;
614: IF l_debug_level > 0 THEN

Line 652: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

648: -- Let us check the status of the call to hz api
649: IF l_debug_level > 0 THEN
650: oe_debug_pub.add( 'RETURN STATS ' || L_RETURN_STATUS ) ;
651: END IF;
652: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
653: IF l_debug_level > 0 THEN
654: oe_debug_pub.add( 'RETURN ERROR MESSAGE COUNT FROM HZ ' || OE_MSG_PUB.GET ( P_MSG_INDEX => X_MSG_COUNT ) ) ;
655: END IF;
656: IF l_debug_level > 0 THEN

Line 675: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

671:
672: END IF;
673: Exception
674: When Others Then
675: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
676: IF l_debug_level > 0 THEN
677: oe_debug_pub.add( 'PROBLEM IN CALL TO CREATE CONTACT PT. ABORT PROCESSING' ) ;
678: END IF;
679: IF l_debug_level > 0 THEN

Line 800: x_return_status := FND_API.G_RET_STS_SUCCESS;

796:
797: IF l_debug_level > 0 THEN
798: oe_debug_pub.add( 'ENTERING IN CREATE_ACCOUNT PROCEDURE' ) ;
799: END IF;
800: x_return_status := FND_API.G_RET_STS_SUCCESS;
801: x_existing_value := 'N';
802:
803: --{ If to check whether Add Customer privilege is set
804: If OE_ORDER_IMPORT_SPECIFIC_PVT.G_ONT_ADD_CUSTOMER = 'Y' Then

Line 865: If l_duplicate_account <> FND_API.G_MISS_NUM Then

861: p_sold_to_org => customer_rec.person_first_name || ' ' ||
862: customer_rec.person_last_name,
863: p_customer_number => customer_rec.customer_number);
864: End If;
865: If l_duplicate_account <> FND_API.G_MISS_NUM Then
866: -- Raise Error and Abort Processing
867: IF l_debug_level > 0 THEN
868: oe_debug_pub.add( 'TRYING TO ENTER THE ACCOUNT WHICH ALREADY EXISTS' ) ;
869: END IF;

Line 874: x_return_status := FND_API.G_RET_STS_ERROR;

870: fnd_message.set_name('ONT','ONT_OI_INL_DUPLICATE');
871: fnd_message.set_token('TYPE', 'ACCOUNT');
872: fnd_message.set_token('REFERENCE', p_customer_info_ref);
873: oe_msg_pub.add;
874: x_return_status := FND_API.G_RET_STS_ERROR;
875: Update_Error_Flag(p_rowid => customer_rec.rowid);
876: Return;
877: Else
878: -- As the data is not duplicate but the call to oe_value_to_id

Line 896: x_return_status := FND_API.G_RET_STS_ERROR;

892: fnd_message.set_name('ONT','ONT_OI_INL_REQD');
893: fnd_message.set_token('API_NAME', 'Create_Account');
894: fnd_message.set_token('FIELD_REQD', 'EMAIL_ADDRESS');
895: oe_msg_pub.add;
896: x_return_status := FND_API.G_RET_STS_ERROR;
897: Update_Error_Flag(p_rowid => customer_rec.rowid);
898: End If; -- If G_EMAIL_REQUIRED
899:
900: If G_AUTO_PARTY_NUMBERING = 'N' and

Line 910: x_return_status := FND_API.G_RET_STS_ERROR;

906: fnd_message.set_name('ONT','ONT_OI_INL_REQD');
907: fnd_message.set_token('API_NAME', 'Create_Account');
908: fnd_message.set_token('FIELD_REQD', 'PARTY_NUMBER');
909: oe_msg_pub.add;
910: x_return_status := FND_API.G_RET_STS_ERROR;
911: Update_Error_Flag(p_rowid => customer_rec.rowid);
912: End If; -- If G_AUTO_PARTY_NUMBERING
913:
914: If G_AUTO_CUST_NUMBERING = 'N' and

Line 924: x_return_status := FND_API.G_RET_STS_ERROR;

920: fnd_message.set_name('ONT','ONT_OI_INL_REQD');
921: fnd_message.set_token('API_NAME', 'Create_Account');
922: fnd_message.set_token('FIELD_REQD', 'CUSTOMER_NUMBER');
923: oe_msg_pub.add;
924: x_return_status := FND_API.G_RET_STS_ERROR;
925: Update_Error_Flag(p_rowid => customer_rec.rowid);
926: End If; -- If G_AUTO_CUST_NUMBERING
927: -- End Check for the Required Information }
928:

Line 940: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

936: p_party_type => customer_rec.customer_type,
937: x_party_id => l_party_id,
938: x_party_name => l_party_name,
939: x_return_status => l_return_status);
940: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
941: x_return_status := l_return_status;
942: IF l_debug_level > 0 THEN
943: oe_debug_pub.add( 'EXITING IN CREATE_ACCOUNT PROCEDURE WITH ERROR' ) ;
944: END IF;

Line 963: x_return_status := FND_API.G_RET_STS_ERROR;

959: oe_debug_pub.add( 'BOTH PERSON AND ORGANIZATION INFORMATION CAN NOT BE POPULATED TOGETHER , POPULATE WHAT YOU ARE CREATING' ) ;
960: END IF;
961: fnd_message.set_name('ONT','ONT_OI_INL_BOTH_PARTY_CUST');
962: oe_msg_pub.add;
963: x_return_status := FND_API.G_RET_STS_ERROR;
964: IF l_debug_level > 0 THEN
965: oe_debug_pub.add( 'EXITING IN CREATE_ACCOUNT PROCEDURE WITH ERROR' ) ;
966: END IF;
967: Update_Error_Flag(p_rowid => customer_rec.rowid);

Line 1084: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

1080: -- Let us check the status of the call to hz api
1081: IF l_debug_level > 0 THEN
1082: oe_debug_pub.add( 'RETURN STATS ' || L_RETURN_STATUS ) ;
1083: END IF;
1084: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
1085: IF l_debug_level > 0 THEN
1086: oe_debug_pub.add( 'RETURN ERROR MESSAGE COUNT FROM HZ ' || OE_MSG_PUB.GET ( P_MSG_INDEX => L_MSG_COUNT ) ) ;
1087: END IF;
1088: IF l_debug_level > 0 THEN

Line 1140: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

1136: -- Let us check the status of the call to hz api
1137: IF l_debug_level > 0 THEN
1138: oe_debug_pub.add( 'RETURN STATS ' || L_RETURN_STATUS ) ;
1139: END IF;
1140: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
1141: IF l_debug_level > 0 THEN
1142: oe_debug_pub.add( 'RETURN ERROR MESSAGE FROM CONTACT EML '|| L_MSG_DATA ) ;
1143: END IF;
1144: x_return_status := l_return_status;

Line 1177: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

1173: -- Let us check the status of the call to hz api
1174: IF l_debug_level > 0 THEN
1175: oe_debug_pub.add( 'RETURN STATS ' || L_RETURN_STATUS ) ;
1176: END IF;
1177: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
1178: IF l_debug_level > 0 THEN
1179: oe_debug_pub.add( 'RETURN ERROR MESSAGE FROM CONTACT PH '|| L_MSG_DATA ) ;
1180: END IF;
1181: x_return_status := l_return_status;

Line 1238: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

1234: -- Let us check the status of the call to hz api
1235: IF l_debug_level > 0 THEN
1236: oe_debug_pub.add( 'RETURN STATS ' || L_RETURN_STATUS ) ;
1237: END IF;
1238: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
1239: IF l_debug_level > 0 THEN
1240: oe_debug_pub.add( 'RETURN ERROR MESSAGE COUNT FROM HZ ' || OE_MSG_PUB.GET ( P_MSG_INDEX => L_MSG_COUNT ) ) ;
1241: END IF;
1242: IF l_debug_level > 0 THEN

Line 1294: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

1290: -- Let us check the status of the call to hz api
1291: IF l_debug_level > 0 THEN
1292: oe_debug_pub.add( 'RETURN STATS ' || L_RETURN_STATUS ) ;
1293: END IF;
1294: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
1295: IF l_debug_level > 0 THEN
1296: oe_debug_pub.add( 'RETURN ERROR MESSAGE FROM CONTACT EML '|| L_MSG_DATA ) ;
1297: END IF;
1298: x_return_status := l_return_status;

Line 1331: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

1327: -- Let us check the status of the call to hz api
1328: IF l_debug_level > 0 THEN
1329: oe_debug_pub.add( 'RETURN STATS ' || L_RETURN_STATUS ) ;
1330: END IF;
1331: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
1332: IF l_debug_level > 0 THEN
1333: oe_debug_pub.add( 'RETURN ERROR MESSAGE FROM CONTACT PH '|| L_MSG_DATA ) ;
1334: END IF;
1335: x_return_status := l_return_status;

Line 1355: x_return_status := FND_API.G_RET_STS_ERROR;

1351: -- Wrong Type is passed Error out
1352: IF l_debug_level > 0 THEN
1353: oe_debug_pub.add( 'WRONG TYPE OF CUSTOMER INFORMATION PASSED.' ) ;
1354: END IF;
1355: x_return_status := FND_API.G_RET_STS_ERROR;
1356: fnd_message.set_name('ONT','ONT_OI_INL_INV_CUST_TYPE');
1357: oe_msg_pub.add;
1358: IF l_debug_level > 0 THEN
1359: oe_debug_pub.add( 'EXITING IN CREATE_ACCOUNT PROCEDURE WITH ERROR' ) ;

Line 1379: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1375: END IF;
1376: fnd_message.set_name('ONT','ONT_OI_INL_API_FAILED');
1377: fnd_message.set_token('API_NAME', 'Create_Account');
1378: oe_msg_pub.add;
1379: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1380: Update_Error_Flag(p_rowid => customer_rec.rowid);
1381: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Unexpected error occured: ' || sqlerrm);
1382: IF l_debug_level > 0 THEN
1383: oe_debug_pub.add( 'EXITING IN CREATE_ACCOUNT PROCEDURE WITH ERROR' ) ;

Line 1396: x_return_status := FND_API.G_RET_STS_ERROR;

1392: END IF;
1393: fnd_message.set_name('ONT','ONT_OI_INL_NO_DATA');
1394: fnd_message.set_token('REFERENCE', p_customer_info_ref);
1395: oe_msg_pub.add;
1396: x_return_status := FND_API.G_RET_STS_ERROR;
1397: IF l_debug_level > 0 THEN
1398: oe_debug_pub.add( 'EXITING IN CREATE_ACCOUNT PROCEDURE WITH ERROR' ) ;
1399: END IF;
1400: End If;

Line 1409: x_return_status := FND_API.G_RET_STS_ERROR;

1405: END IF;
1406: fnd_message.set_name('ONT','ONT_OI_INL_SET_PARAMETER');
1407: fnd_message.set_token('TYPE', 'Customers');
1408: oe_msg_pub.add;
1409: x_return_status := FND_API.G_RET_STS_ERROR;
1410: End If;
1411: -- End If to check whether Add Customer privilege is set}
1412: Exception
1413: When Others Then

Line 1414: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1410: End If;
1411: -- End If to check whether Add Customer privilege is set}
1412: Exception
1413: When Others Then
1414: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1415: IF l_debug_level > 0 THEN
1416: oe_debug_pub.add( 'PROBLEM IN CALL TO CREATE_ACCOUNT. ABORT PROCESSING' ) ;
1417: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
1418: END IF;

Line 1449: x_return_status := FND_API.G_RET_STS_SUCCESS;

1445: Select party_id, cust_account_id
1446: Into x_party_id, x_account_id
1447: From hz_cust_accounts
1448: Where account_number = p_customer_number;
1449: x_return_status := FND_API.G_RET_STS_SUCCESS;
1450:
1451: IF l_debug_level > 0 THEN
1452: oe_debug_pub.add( 'EXITING VALIDATE_CUSTOMER_NUMBER API' ) ;
1453: END IF;

Line 1456: x_return_status := FND_API.G_RET_STS_ERROR;

1452: oe_debug_pub.add( 'EXITING VALIDATE_CUSTOMER_NUMBER API' ) ;
1453: END IF;
1454: Exception
1455: When NO_DATA_FOUND Then
1456: x_return_status := FND_API.G_RET_STS_ERROR;
1457: IF l_debug_level > 0 THEN
1458: oe_debug_pub.add( 'NO RECORD FOUND FOR THE PASSED EXISTING CUSTOMER , PLEASE CHECK DATA' ) ;
1459: END IF;
1460: fnd_message.set_name('ONT','ONT_OI_INL_NO_DATA');

Line 1589: x_return_status := FND_API.G_RET_STS_SUCCESS;

1585: IF l_debug_level > 0 THEN
1586: oe_debug_pub.add( 'ENTERING PROCEDURE CREATE ADDRESS' ) ;
1587: END IF;
1588:
1589: x_return_status := FND_API.G_RET_STS_SUCCESS;
1590:
1591: OE_MSG_PUB.set_msg_context(
1592: p_entity_code => 'OI_INL_ADDCUST'
1593: ,p_entity_ref => null

Line 1625: x_return_status := FND_API.G_RET_STS_ERROR;

1621: fnd_message.set_name('ONT','ONT_OI_INL_NO_USAGE_SET');
1622: fnd_message.set_token('USAGE', 'SHIP_TO');
1623: fnd_message.set_token('REFERENCE', p_customer_info_ref);
1624: oe_msg_pub.add;
1625: x_return_status := FND_API.G_RET_STS_ERROR;
1626: Return;
1627: Elsif p_type_of_address = 'BILL_TO' and
1628: nvl(address_info_rec.is_bill_to_address, 'N') <> 'Y' Then
1629: IF l_debug_level > 0 THEN

Line 1636: x_return_status := FND_API.G_RET_STS_ERROR;

1632: fnd_message.set_name('ONT','ONT_OI_INL_NO_USAGE_SET');
1633: fnd_message.set_token('USAGE', 'BILL_TO');
1634: fnd_message.set_token('REFERENCE', p_customer_info_ref);
1635: oe_msg_pub.add;
1636: x_return_status := FND_API.G_RET_STS_ERROR;
1637: Return;
1638: Elsif p_type_of_address = 'DELIVER_TO' and
1639: nvl(address_info_rec.is_deliver_to_address, 'N') <> 'Y' Then
1640: IF l_debug_level > 0 THEN

Line 1647: x_return_status := FND_API.G_RET_STS_ERROR;

1643: fnd_message.set_name('ONT','ONT_OI_INL_NO_USAGE_SET');
1644: fnd_message.set_token('USAGE', 'DELIVER_TO');
1645: fnd_message.set_token('REFERENCE', p_customer_info_ref);
1646: oe_msg_pub.add;
1647: x_return_status := FND_API.G_RET_STS_ERROR;
1648: Return;
1649: End If;
1650:
1651: If address_info_rec.is_ship_to_address = 'Y' AND

Line 1663: x_return_status := FND_API.G_RET_STS_SUCCESS;

1659: and status='A';
1660:
1661: if l_site_id_exists='Y' then
1662: x_usage_site_id := address_info_rec.new_address_id_ship;
1663: x_return_status := FND_API.G_RET_STS_SUCCESS;
1664: IF l_debug_level > 0 THEN
1665: oe_debug_pub.add( 'RETURNING EXISING SHIP_TO ID=> '|| X_USAGE_SITE_ID ) ;
1666: END IF;
1667: RETURN;

Line 1688: x_return_status := FND_API.G_RET_STS_SUCCESS;

1684: and status='A';
1685:
1686: if l_site_id_exists='Y' then
1687: x_usage_site_id := address_info_rec.new_address_id_bill;
1688: x_return_status := FND_API.G_RET_STS_SUCCESS;
1689: IF l_debug_level > 0 THEN
1690: oe_debug_pub.add( 'RETURNING EXISING BILL_TO ID=> '|| X_USAGE_SITE_ID ) ;
1691: END IF;
1692: RETURN;

Line 1713: x_return_status := FND_API.G_RET_STS_SUCCESS;

1709: and status='A';
1710:
1711: if l_site_id_exists='Y' then
1712: x_usage_site_id := address_info_rec.new_address_id_deliver;
1713: x_return_status := FND_API.G_RET_STS_SUCCESS;
1714: IF l_debug_level > 0 THEN
1715: oe_debug_pub.add( 'RETURNING EXISING DELIVER_TO ID=> '|| X_USAGE_SITE_ID ) ;
1716: END IF;
1717: RETURN;

Line 1743: x_return_status := FND_API.G_RET_STS_ERROR;

1739: fnd_message.set_name('ONT','ONT_OI_INL_NO_PARENT_REF');
1740: fnd_message.set_token('REFERENCE', p_customer_info_ref);
1741: oe_msg_pub.add;
1742: -- call msg routine
1743: x_return_status := FND_API.G_RET_STS_ERROR;
1744: Return;
1745: Else
1746: IF l_debug_level > 0 THEN
1747: oe_debug_pub.add( 'BEFORE CALLING CREATE ACCOUNT PROCEDURE' ) ;

Line 1770: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

1766: IF l_debug_level > 0 THEN
1767: oe_debug_pub.add( 'CUST_PARTY_ID = '||L_CUSTOMER_PARTY_ID ) ;
1768: END IF;
1769:
1770: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
1771: IF l_debug_level > 0 THEN
1772: oe_debug_pub.add( 'RETURN STATUS AFTER CREATE_ACCOUNT IS ERROR' ) ;
1773: END IF;
1774: x_return_status := l_return_status;

Line 1793: If l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1789: IF l_debug_level > 0 THEN
1790: oe_debug_pub.add( 'AFTER CREATE_CUST_RELATIONSHIP' ) ;
1791: END IF;
1792:
1793: If l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1794: IF l_debug_level > 0 THEN
1795: oe_debug_pub.add( 'RETURN ERROR MESSAGE COUNT FROM HZ ' || OE_MSG_PUB.GET ( P_MSG_INDEX => L_MSG_COUNT ) ) ;
1796: END IF;
1797: IF l_debug_level > 0 THEN

Line 1826: x_return_status := FND_API.G_RET_STS_ERROR;

1822: END IF;
1823: fnd_message.set_name('ONT','ONT_OI_INL_NO_DATA');
1824: fnd_message.set_token('REFERENCE', address_info_rec.Current_Customer_id);
1825: oe_msg_pub.add;
1826: x_return_status := FND_API.G_RET_STS_ERROR;
1827: Return;
1828: End;
1829: Else
1830: --Validate customer

Line 1836: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

1832: x_party_id => l_customer_party_id,
1833: x_account_id => l_customer_info_id,
1834: x_return_status => l_return_status
1835: );
1836: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
1837: x_return_status := l_return_status;
1838: Return;
1839: End If;
1840:

Line 1874: If l_duplicate_address <> FND_API.G_MISS_NUM Then

1870: p_ship_to_postal_code => address_info_rec.postal_code,
1871: p_ship_to_country => address_info_rec.country,
1872: p_ship_to_customer_id =>l_temp_usage_to_cust_id --bug 7299729
1873: );
1874: If l_duplicate_address <> FND_API.G_MISS_NUM Then
1875: -- Raise Error and Abort Processing
1876: IF l_debug_level > 0 THEN
1877: oe_debug_pub.add( 'TRYING TO ENTER THE SHIP TO WHICH ALREADY EXISTS' ) ;
1878: END IF;

Line 1883: x_return_status := FND_API.G_RET_STS_ERROR;

1879: fnd_message.set_name('ONT','ONT_OI_INL_DUPLICATE');
1880: fnd_message.set_token('TYPE', 'SHIP_TO ADDRESS');
1881: fnd_message.set_token('REFERENCE', p_customer_info_ref);
1882: oe_msg_pub.add;
1883: x_return_status := FND_API.G_RET_STS_ERROR;
1884: Update_Error_Flag(p_rowid => address_info_rec.rowid);
1885: Return;
1886: Else
1887: -- As the data is not duplicate but the call to oe_value_to_id

Line 1907: If l_duplicate_address <> FND_API.G_MISS_NUM Then

1903: p_invoice_to_postal_code => address_info_rec.postal_code,
1904: p_invoice_to_country => address_info_rec.country,
1905: p_invoice_to_customer_id =>l_temp_usage_to_cust_id --bug 7299729
1906: );
1907: If l_duplicate_address <> FND_API.G_MISS_NUM Then
1908: -- Raise Error and Abort Processing
1909: IF l_debug_level > 0 THEN
1910: oe_debug_pub.add( 'TRYING TO ENTER THE BILL TO WHICH ALREADY EXISTS' ) ;
1911: END IF;

Line 1916: x_return_status := FND_API.G_RET_STS_ERROR;

1912: fnd_message.set_name('ONT','ONT_OI_INL_DUPLICATE');
1913: fnd_message.set_token('TYPE', 'BILL_TO ADDRESS');
1914: fnd_message.set_token('REFERENCE', p_customer_info_ref);
1915: oe_msg_pub.add;
1916: x_return_status := FND_API.G_RET_STS_ERROR;
1917: Update_Error_Flag(p_rowid => address_info_rec.rowid);
1918: Return;
1919: Else
1920: -- As the data is not duplicate but the call to oe_value_to_id

Line 1940: If l_duplicate_address <> FND_API.G_MISS_NUM Then

1936: p_deliver_to_postal_code => address_info_rec.postal_code,
1937: p_deliver_to_country => address_info_rec.country,
1938: p_deliver_to_customer_id =>l_temp_usage_to_cust_id --bug 7299729
1939: );
1940: If l_duplicate_address <> FND_API.G_MISS_NUM Then
1941: -- Raise Error and Abort Processing
1942: IF l_debug_level > 0 THEN
1943: oe_debug_pub.add( 'TRYING TO ENTER THE DELIVER TO WHICH ALREADY EXISTS' ) ;
1944: END IF;

Line 1949: x_return_status := FND_API.G_RET_STS_ERROR;

1945: fnd_message.set_name('ONT','ONT_OI_INL_DUPLICATE');
1946: fnd_message.set_token('TYPE', 'DELIVER_TO ADDRESS');
1947: fnd_message.set_token('REFERENCE', p_customer_info_ref);
1948: oe_msg_pub.add;
1949: x_return_status := FND_API.G_RET_STS_ERROR;
1950: Update_Error_Flag(p_rowid => address_info_rec.rowid);
1951: Return;
1952: Else
1953: -- As the data is not duplicate but the call to oe_value_to_id

Line 1977: x_return_status := FND_API.G_RET_STS_ERROR;

1973: fnd_message.set_name('ONT','ONT_OI_INL_REQD');
1974: fnd_message.set_token('API_NAME', 'Create_Address');
1975: fnd_message.set_token('FIELD_REQD', 'SITE_NUMBER');
1976: oe_msg_pub.add;
1977: x_return_status := FND_API.G_RET_STS_ERROR;
1978: IF l_debug_level > 0 THEN
1979: oe_debug_pub.add( 'SPECIFY SITE NUMBER , PROFILE NO AUTO' ) ;
1980: END IF;
1981: RETURN;

Line 1995: x_return_status := FND_API.G_RET_STS_ERROR;

1991: fnd_message.set_name('ONT','ONT_OI_INL_REQD');
1992: fnd_message.set_token('API_NAME', 'Create_Address');
1993: fnd_message.set_token('FIELD_REQD', 'LOCATION_NUMBER');
1994: oe_msg_pub.add;
1995: x_return_status := FND_API.G_RET_STS_ERROR;
1996: IF l_debug_level > 0 THEN
1997: oe_debug_pub.add( 'SPECIFY LOCATION NUMBER' ) ;
1998: END IF;
1999: RETURN;

Line 2063: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

2059: -- Let us check the status of the call to hz api
2060: IF l_debug_level > 0 THEN
2061: oe_debug_pub.add( 'RETURN STATS ' || L_RETURN_STATUS ) ;
2062: END IF;
2063: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
2064: IF l_debug_level > 0 THEN
2065: oe_debug_pub.add( 'HZ CREATE_LOCATION API ERROR ' ) ;
2066: END IF;
2067: IF l_debug_level > 0 THEN

Line 2137: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

2133: -- Let us check the status of the call to hz api
2134: IF l_debug_level > 0 THEN
2135: oe_debug_pub.add( 'RETURN STATS ' || L_RETURN_STATUS ) ;
2136: END IF;
2137: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
2138: IF l_debug_level > 0 THEN
2139: oe_debug_pub.add( 'HZ CREATE_PARTY_SITE API ERROR ' ) ;
2140: END IF;
2141: IF l_debug_level > 0 THEN

Line 2228: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

2224: -- Let us check the status of the call to hz api
2225: IF l_debug_level > 0 THEN
2226: oe_debug_pub.add( 'RETURN STATS ' || L_RETURN_STATUS ) ;
2227: END IF;
2228: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
2229: IF l_debug_level > 0 THEN
2230: oe_debug_pub.add( 'HZ CREATE_ACCOUNT_SITE API ERROR ' ) ;
2231: END IF;
2232: IF l_debug_level > 0 THEN

Line 2267: p_create_profile => FND_API.G_FALSE,

2263: HZ_CUST_ACCOUNT_SITE_V2PUB.Create_Cust_Site_Use
2264: (
2265: p_cust_site_use_rec => l_acct_site_uses,
2266: p_customer_profile_rec => l_cust_profile_rec,
2267: p_create_profile => FND_API.G_FALSE,
2268: x_return_status => l_return_status,
2269: x_msg_count => l_msg_count,
2270: x_msg_data => l_msg_data,
2271: x_site_use_id => l_site_use_id_ship

Line 2277: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

2273: -- Let us check the status of the call to hz api
2274: IF l_debug_level > 0 THEN
2275: oe_debug_pub.add( 'RETURN STATS ' || L_RETURN_STATUS ) ;
2276: END IF;
2277: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
2278: IF l_debug_level > 0 THEN
2279: oe_debug_pub.add( 'HZ CREATE_SITE_USAGE API ERROR ' ) ;
2280: END IF;
2281: IF l_debug_level > 0 THEN

Line 2325: p_create_profile => FND_API.G_FALSE,

2321: HZ_CUST_ACCOUNT_SITE_V2PUB.Create_Cust_Site_Use
2322: (
2323: p_cust_site_use_rec => l_acct_site_uses,
2324: p_customer_profile_rec => l_cust_profile_rec,
2325: p_create_profile => FND_API.G_FALSE,
2326: x_return_status => l_return_status,
2327: x_msg_count => l_msg_count,
2328: x_msg_data => l_msg_data,
2329: x_site_use_id => l_site_use_id_bill

Line 2335: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

2331: -- Let us check the status of the call to hz api
2332: IF l_debug_level > 0 THEN
2333: oe_debug_pub.add( 'RETURN STATS ' || L_RETURN_STATUS ) ;
2334: END IF;
2335: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
2336: IF l_debug_level > 0 THEN
2337: oe_debug_pub.add( 'HZ CREATE_SITE_USAGE API ERROR ' ) ;
2338: END IF;
2339: IF l_debug_level > 0 THEN

Line 2379: p_create_profile => FND_API.G_FALSE,

2375: HZ_CUST_ACCOUNT_SITE_V2PUB.Create_Cust_Site_Use
2376: (
2377: p_cust_site_use_rec => l_acct_site_uses,
2378: p_customer_profile_rec => l_cust_profile_rec,
2379: p_create_profile => FND_API.G_FALSE,
2380: x_return_status => l_return_status,
2381: x_msg_count => l_msg_count,
2382: x_msg_data => l_msg_data,
2383: x_site_use_id => l_site_use_id_deliver

Line 2389: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

2385: -- Let us check the status of the call to hz api
2386: IF l_debug_level > 0 THEN
2387: oe_debug_pub.add( 'RETURN STATS ' || L_RETURN_STATUS ) ;
2388: END IF;
2389: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
2390: IF l_debug_level > 0 THEN
2391: oe_debug_pub.add( 'HZ CREATE_SITE_USAGE API ERROR ' ) ;
2392: END IF;
2393: IF l_debug_level > 0 THEN

Line 2438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2434: END IF;
2435: fnd_message.set_name('ONT','ONT_OI_INL_API_FAILED');
2436: fnd_message.set_token('API_NAME', 'Create_Address');
2437: oe_msg_pub.add;
2438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2439: Update_Error_Flag(p_rowid => address_info_rec.rowid);
2440: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Unexpected error occured: ' || sqlerrm);
2441: IF l_debug_level > 0 THEN
2442: oe_debug_pub.add( 'EXITING IN CREATE_ADDRESS PROCEDURE WITH ERROR' ) ;

Line 2456: x_return_status := FND_API.G_RET_STS_ERROR;

2452: END IF;
2453: fnd_message.set_name('ONT','ONT_OI_INL_NO_DATA');
2454: fnd_message.set_token('REFERENCE', p_customer_info_ref);
2455: oe_msg_pub.add;
2456: x_return_status := FND_API.G_RET_STS_ERROR;
2457: IF l_debug_level > 0 THEN
2458: oe_debug_pub.add( 'EXITING IN CREATE_ADDRESS PROCEDURE WITH ERROR' ) ;
2459: END IF;
2460: End If;

Line 2467: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2463: oe_debug_pub.add( 'EXITING PROCEDURE CREATE ADDRESS' ) ;
2464: END IF;
2465: Exception
2466: When Others Then
2467: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2468: IF l_debug_level > 0 THEN
2469: oe_debug_pub.add( 'PROBLEM IN CALL TO CREATE_ADDRESS. ABORT PROCESSING' ) ;
2470: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
2471: END IF;

Line 2576: x_return_status := FND_API.G_RET_STS_SUCCESS;

2572: IF l_debug_level > 0 THEN
2573: oe_debug_pub.add( 'ENTERING PROCEDURE CREATE CONTACT' ) ;
2574: END IF;
2575:
2576: x_return_status := FND_API.G_RET_STS_SUCCESS;
2577:
2578: OE_MSG_PUB.set_msg_context(
2579: p_entity_code => 'OI_INL_ADDCUST'
2580: ,p_entity_ref => null

Line 2657: x_return_status := FND_API.G_RET_STS_ERROR;

2653: If contact_rec.parent_customer_ref is Null Then
2654: IF l_debug_level > 0 THEN
2655: oe_debug_pub.add( 'NO PARENT CUSTOMER REF POPULATED. CHECK THE DATA' ) ;
2656: END IF;
2657: x_return_status := FND_API.G_RET_STS_ERROR;
2658: fnd_message.set_name('ONT','ONT_OI_INL_NO_PARENT_INFO');
2659: fnd_message.set_token('REFERENCE', p_customer_info_ref);
2660: oe_msg_pub.add;
2661: return;

Line 2685: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

2681: END IF;
2682:
2683: -- Check for the return status of the api
2684: -- to return the proper information to the called program.
2685: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
2686: IF l_debug_level > 0 THEN
2687: oe_debug_pub.add( 'RETURN STATUS IS NOT SUCCESS , AFTER CREATE ACC. FOR CONTACT' ) ;
2688: END IF;
2689: x_return_status := l_return_status;

Line 2716: x_return_status := FND_API.G_RET_STS_ERROR;

2712: END IF;
2713: fnd_message.set_name('ONT','ONT_OI_INL_NO_DATA');
2714: fnd_message.set_token('REFERENCE', contact_rec.Current_Customer_id);
2715: oe_msg_pub.add;
2716: x_return_status := FND_API.G_RET_STS_ERROR;
2717: Return;
2718: End;
2719: Else
2720: --Validate customer

Line 2726: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

2722: x_party_id => l_customer_party_id,
2723: x_account_id => l_customer_info_id,
2724: x_return_status => l_return_status
2725: );
2726: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
2727: x_return_status := l_return_status;
2728: Return;
2729: End If;
2730: End If;

Line 2745: If l_sold_to_contact <> FND_API.G_MISS_NUM Then

2741: If l_type_of_contact = 'SOLD_TO' Then
2742: l_sold_to_contact := Oe_Value_To_Id.Sold_To_Contact(
2743: p_sold_to_contact => l_contact_name,
2744: p_sold_to_org_id => l_customer_info_id);
2745: If l_sold_to_contact <> FND_API.G_MISS_NUM Then
2746: -- Raise Error and Abort Processing
2747: IF l_debug_level > 0 THEN
2748: oe_debug_pub.add( 'TRYING TO ENTER THE SOLD_TO CONTACT WHICH ALREADY EXISTS' ) ;
2749: END IF;

Line 2753: x_return_status := FND_API.G_RET_STS_ERROR;

2749: END IF;
2750: fnd_message.set_name('ONT','ONT_OI_INL_DUPLICATE');
2751: fnd_message.set_token('REFERENCE', p_customer_info_ref);
2752: oe_msg_pub.add;
2753: x_return_status := FND_API.G_RET_STS_ERROR;
2754: Update_Error_Flag(p_rowid => contact_rec.rowid);
2755: Return;
2756: Else
2757: -- As the data is not duplicate but the call to oe_value_to_id

Line 2766: If l_sold_to_contact <> FND_API.G_MISS_NUM Then

2762: Elsif l_type_of_contact = 'SHIP_TO' Then
2763: l_sold_to_contact := Oe_Value_To_Id.Ship_To_Contact(
2764: p_ship_to_contact => l_contact_name,
2765: p_ship_to_org_id => l_usage_site_id);
2766: If l_sold_to_contact <> FND_API.G_MISS_NUM Then
2767: -- Raise Error and Abort Processing
2768: IF l_debug_level > 0 THEN
2769: oe_debug_pub.add( 'TRYING TO ENTER THE SHIP_TO CONTACT WHICH ALREADY EXISTS' ) ;
2770: END IF;

Line 2774: x_return_status := FND_API.G_RET_STS_ERROR;

2770: END IF;
2771: fnd_message.set_name('ONT','ONT_OI_INL_DUPLICATE');
2772: fnd_message.set_token('REFERENCE', p_customer_info_ref);
2773: oe_msg_pub.add;
2774: x_return_status := FND_API.G_RET_STS_ERROR;
2775: Update_Error_Flag(p_rowid => contact_rec.rowid);
2776: Return;
2777: Else
2778: -- As the data is not duplicate but the call to oe_value_to_id

Line 2787: If l_sold_to_contact <> FND_API.G_MISS_NUM Then

2783: Elsif l_type_of_contact = 'BILL_TO' Then
2784: l_sold_to_contact := Oe_Value_To_Id.Invoice_To_Contact(
2785: p_invoice_to_contact => l_contact_name,
2786: p_invoice_to_org_id => l_usage_site_id);
2787: If l_sold_to_contact <> FND_API.G_MISS_NUM Then
2788: -- Raise Error and Abort Processing
2789: IF l_debug_level > 0 THEN
2790: oe_debug_pub.add( 'TRYING TO ENTER THE BILL_TO CONTACT WHICH ALREADY EXISTS' ) ;
2791: END IF;

Line 2795: x_return_status := FND_API.G_RET_STS_ERROR;

2791: END IF;
2792: fnd_message.set_name('ONT','ONT_OI_INL_DUPLICATE');
2793: fnd_message.set_token('REFERENCE', p_customer_info_ref);
2794: oe_msg_pub.add;
2795: x_return_status := FND_API.G_RET_STS_ERROR;
2796: Update_Error_Flag(p_rowid => contact_rec.rowid);
2797: Return;
2798: Else
2799: -- As the data is not duplicate but the call to oe_value_to_id

Line 2808: If l_sold_to_contact <> FND_API.G_MISS_NUM Then

2804: Elsif l_type_of_contact = 'DELIVER_TO' Then
2805: l_sold_to_contact := Oe_Value_To_Id.Deliver_To_Contact(
2806: p_deliver_to_contact => l_contact_name,
2807: p_deliver_to_org_id => l_usage_site_id);
2808: If l_sold_to_contact <> FND_API.G_MISS_NUM Then
2809: -- Raise Error and Abort Processing
2810: IF l_debug_level > 0 THEN
2811: oe_debug_pub.add( 'TRYING TO ENTER THE DELIVER_TO CONTACT WHICH ALREADY EXISTS' ) ;
2812: END IF;

Line 2816: x_return_status := FND_API.G_RET_STS_ERROR;

2812: END IF;
2813: fnd_message.set_name('ONT','ONT_OI_INL_DUPLICATE');
2814: fnd_message.set_token('REFERENCE', p_customer_info_ref);
2815: oe_msg_pub.add;
2816: x_return_status := FND_API.G_RET_STS_ERROR;
2817: Update_Error_Flag(p_rowid => contact_rec.rowid);
2818: Return;
2819: Else
2820: -- As the data is not duplicate but the call to oe_value_to_id

Line 2895: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

2891: -- Let us check the status of the call to hz api
2892: IF l_debug_level > 0 THEN
2893: oe_debug_pub.add( 'RETURN STATS ' || L_RETURN_STATUS ) ;
2894: END IF;
2895: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
2896: IF l_debug_level > 0 THEN
2897: oe_debug_pub.add( 'HZ CREATE_PERSON API ERROR ' ) ;
2898: END IF;
2899: IF l_debug_level > 0 THEN

Line 2986: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

2982: -- Let us check the status of the call to hz api
2983: IF l_debug_level > 0 THEN
2984: oe_debug_pub.add( 'RETURN STATS ' || L_RETURN_STATUS ) ;
2985: END IF;
2986: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
2987: IF l_debug_level > 0 THEN
2988: oe_debug_pub.add( 'HZ CREATE_ORG_CONTACT API ERROR ' ) ;
2989: END IF;
2990: IF l_debug_level > 0 THEN

Line 3034: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

3030: -- Let us check the status of the call to hz api
3031: IF l_debug_level > 0 THEN
3032: oe_debug_pub.add( 'RETURN STATS ' || L_RETURN_STATUS ) ;
3033: END IF;
3034: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
3035: IF l_debug_level > 0 THEN
3036: oe_debug_pub.add( 'RETURN ERROR MESSAGE FROM CONTACT EML '|| L_MSG_DATA ) ;
3037: END IF;
3038: x_return_status := l_return_status;

Line 3070: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

3066: -- Let us check the status of the call to hz api
3067: IF l_debug_level > 0 THEN
3068: oe_debug_pub.add( 'RETURN STATS ' || L_RETURN_STATUS ) ;
3069: END IF;
3070: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
3071: IF l_debug_level > 0 THEN
3072: oe_debug_pub.add( 'RETURN ERROR MESSAGE FROM CONTACT PH '|| L_MSG_DATA ) ;
3073: END IF;
3074: x_return_status := l_return_status;

Line 3113: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

3109: -- Let us check the status of the call to hz api
3110: IF l_debug_level > 0 THEN
3111: oe_debug_pub.add( 'RETURN STATS ' || L_RETURN_STATUS ) ;
3112: END IF;
3113: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
3114: IF l_debug_level > 0 THEN
3115: oe_debug_pub.add( 'HZ CREATE_CUST_ACCT_ROLES API ERROR ' ) ;
3116: END IF;
3117: IF l_debug_level > 0 THEN

Line 3188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3184: END IF;
3185: fnd_message.set_name('ONT','ONT_OI_INL_API_FAILED');
3186: fnd_message.set_token('API_NAME', 'Create_Contact');
3187: oe_msg_pub.add;
3188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3189: Update_Error_Flag(p_rowid => contact_rec.rowid);
3190: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Unexpected error occured: ' || sqlerrm);
3191: IF l_debug_level > 0 THEN
3192: oe_debug_pub.add( 'EXITING IN CREATE_CONTACT PROCEDURE WITH ERROR' ) ;

Line 3207: x_return_status := FND_API.G_RET_STS_ERROR;

3203: END IF;
3204: fnd_message.set_name('ONT','ONT_OI_INL_NO_DATA');
3205: fnd_message.set_token('REFERENCE', p_customer_info_ref);
3206: oe_msg_pub.add;
3207: x_return_status := FND_API.G_RET_STS_ERROR;
3208: IF l_debug_level > 0 THEN
3209: oe_debug_pub.add( 'EXITING IN CREATE_CONTACT PROCEDURE WITH ERROR' ) ;
3210: END IF;
3211: End If;

Line 3218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3214: oe_debug_pub.add( 'EXITING PROCEDURE CREATE CONTACT' ) ;
3215: END IF;
3216: Exception
3217: When Others Then
3218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3219: IF l_debug_level > 0 THEN
3220: oe_debug_pub.add( 'PROBLEM IN CALL TO CREATE_CONTACT. ABORT PROCESSING' ) ;
3221: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
3222: END IF;

Line 3257: l_return_status Varchar2(1) := FND_API.G_RET_STS_SUCCESS;

3253: l_contact_id Number;
3254: l_contact_name Varchar2(360);
3255: l_type_of_contact Varchar2(10) := p_usage;
3256: l_type_of_address Varchar2(10) := p_usage;
3257: l_return_status Varchar2(1) := FND_API.G_RET_STS_SUCCESS;
3258: l_usage_site_id Number;
3259: l_ship_to_org_id Number;
3260: l_bill_to_org_id Number;
3261: l_deliver_to_org_id Number;

Line 3335: x_return_status := FND_API.G_RET_STS_SUCCESS;

3331: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3332: --
3333: Begin
3334:
3335: x_return_status := FND_API.G_RET_STS_SUCCESS;
3336: -- Initialize the system paramter and profile option used
3337: -- later in processing
3338: If G_INITIALIZED = FND_API.G_FALSE Then
3339: Initialize_Global(l_return_status);

Line 3338: If G_INITIALIZED = FND_API.G_FALSE Then

3334:
3335: x_return_status := FND_API.G_RET_STS_SUCCESS;
3336: -- Initialize the system paramter and profile option used
3337: -- later in processing
3338: If G_INITIALIZED = FND_API.G_FALSE Then
3339: Initialize_Global(l_return_status);
3340: End If;
3341:
3342: -- Check for the type of entry need to be created based on the

Line 3348: If l_orig_sys_line_ref = FND_API.G_MISS_CHAR Then

3344: -- 'ADDRESS'
3345: -- Depending on that call the respective api/processing...
3346:
3347: -- Null p_orig_sys_line_ref if add ct info is called for Header
3348: If l_orig_sys_line_ref = FND_API.G_MISS_CHAR Then
3349: l_orig_sys_line_ref := Null;
3350: End If;
3351:
3352: -- { Start of if for p_customer_info_type_code

Line 3375: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

3371: END IF;
3372:
3373: -- Check for the return status of the api
3374: -- to return the proper information to the called program.
3375: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
3376: IF l_debug_level > 0 THEN
3377: oe_debug_pub.add( 'RETURN STATUS IS NOT SUCCESS , AFTER CREATE ACC.' ) ;
3378: END IF;
3379: x_return_status := l_return_status;

Line 3406: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

3402: );
3403:
3404: -- Check for the return status of the api
3405: -- to return the proper information to the called program.
3406: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
3407: IF l_debug_level > 0 THEN
3408: oe_debug_pub.add( 'RETURN STATUS IS NOT SUCCESS , AFTER CREATE CONT.' ) ;
3409: END IF;
3410: x_return_status := l_return_status;

Line 3432: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

3428: );
3429: -- Create_Address;
3430: -- Check for the return status of the api
3431: -- to return the proper information to the called program.
3432: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
3433: IF l_debug_level > 0 THEN
3434: oe_debug_pub.add( 'RETURN STATUS IS NOT SUCCESS , AFTER CREATE ADDRESS.' ) ;
3435: END IF;
3436: x_return_status := l_return_status;

Line 3461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3457: end if;
3458: -- End of if for p_customer_info_type_code }
3459: Exception
3460: When Others Then
3461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3462: IF l_debug_level > 0 THEN
3463: oe_debug_pub.add( 'PROBLEM IN CALL TO CREATE_CUSTOMER_INFO. ABORT PROCESSING' ) ;
3464: END IF;
3465: IF l_debug_level > 0 THEN

Line 3832: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3828: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Unexpected error occured: ' || sqlerrm);
3829: IF l_debug_level > 0 THEN
3830: oe_debug_pub.add( 'EXITING IN DELETE_CUSTOMER_INFO PROCEDURE WITH ERROR' ) ;
3831: END IF;
3832: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3833: End Delete_Customer_Info;
3834:
3835: END OE_INLINE_CUSTOMER_PUB;