APPS.OE_INLINE_CUSTOMER_PUB dependencies on FND_API

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

2: /* $Header: OEXPINLB.pls 120.8.12020000.2 2013/03/23 13:50:56 sujithku 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 2138: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

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

Line 2229: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

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

Line 2268: p_create_profile => FND_API.G_FALSE,

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

Line 2278: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

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

Line 2326: p_create_profile => FND_API.G_FALSE,

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

Line 2336: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

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

Line 2380: p_create_profile => FND_API.G_FALSE,

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

Line 2390: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

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

Line 2439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 2457: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 2468: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 2577: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 2658: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 2686: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

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

Line 2717: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 2727: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

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

Line 2746: If l_sold_to_contact <> FND_API.G_MISS_NUM Then

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

Line 2754: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 2767: If l_sold_to_contact <> FND_API.G_MISS_NUM Then

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

Line 2775: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 2788: If l_sold_to_contact <> FND_API.G_MISS_NUM Then

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

Line 2796: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 2809: If l_sold_to_contact <> FND_API.G_MISS_NUM Then

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

Line 2817: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 2896: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

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

Line 2987: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

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

Line 3035: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

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

Line 3071: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

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

Line 3114: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

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

Line 3189: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 3208: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 3219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

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

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

Line 3336: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 3339: If G_INITIALIZED = FND_API.G_FALSE Then

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

Line 3349: If l_orig_sys_line_ref = FND_API.G_MISS_CHAR Then

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

Line 3376: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

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

Line 3407: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

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

Line 3433: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

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

Line 3462: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 3833: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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