eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_INLINE_CUSTOMER_PUB dependencies on OE_MSG_PUB

Line 84: oe_msg_pub.add;

80: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
81: END IF;
82: fnd_message.set_name('ONT','ONT_OI_INL_API_FAILED');
83: fnd_message.set_token('API_NAME', 'Initialize_Global');
84: oe_msg_pub.add;
85: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Unexpected error occured: ' || sqlerrm);
86: IF l_debug_level > 0 THEN
87: oe_debug_pub.add( 'EXITING PROCEDURE INITIALIZE_GLOBAL' ) ;
88: END IF;

Line 85: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Unexpected error occured: ' || sqlerrm);

81: END IF;
82: fnd_message.set_name('ONT','ONT_OI_INL_API_FAILED');
83: fnd_message.set_token('API_NAME', 'Initialize_Global');
84: oe_msg_pub.add;
85: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Unexpected error occured: ' || sqlerrm);
86: IF l_debug_level > 0 THEN
87: oe_debug_pub.add( 'EXITING PROCEDURE INITIALIZE_GLOBAL' ) ;
88: END IF;
89: End Initialize_Global;

Line 142: oe_msg_pub.add;

138: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
139: END IF;
140: fnd_message.set_name('ONT','ONT_OI_INL_API_FAILED');
141: fnd_message.set_token('API_NAME', 'Validate_Party_Number');
142: oe_msg_pub.add;
143: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Unexpected error occured: ' || sqlerrm);
144: IF l_debug_level > 0 THEN
145: oe_debug_pub.add( 'EXITING VALIDATE PARTY NUMBER API WITHOUT PARTY ID' ) ;
146: END IF;

Line 143: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Unexpected error occured: ' || sqlerrm);

139: END IF;
140: fnd_message.set_name('ONT','ONT_OI_INL_API_FAILED');
141: fnd_message.set_token('API_NAME', 'Validate_Party_Number');
142: oe_msg_pub.add;
143: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Unexpected error occured: ' || sqlerrm);
144: IF l_debug_level > 0 THEN
145: oe_debug_pub.add( 'EXITING VALIDATE PARTY NUMBER API WITHOUT PARTY ID' ) ;
146: END IF;
147: End Validate_Party_Number;

Line 317: oe_debug_pub.add( 'RETURN ERROR MESSAGE COUNT FROM HZ ' || OE_MSG_PUB.GET ( P_MSG_INDEX => X_MSG_COUNT ) ) ;

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
320: oe_debug_pub.add( 'RETURN ERROR MESSAGE FROM ACC RELATE '|| X_MSG_DATA ) ;
321: END IF;

Line 323: oe_msg_pub.transfer_msg_stack;

319: IF l_debug_level > 0 THEN
320: oe_debug_pub.add( 'RETURN ERROR MESSAGE FROM ACC RELATE '|| X_MSG_DATA ) ;
321: END IF;
322: x_return_status := l_return_status;
323: oe_msg_pub.transfer_msg_stack;
324: fnd_msg_pub.delete_msg;
325: IF l_debug_level > 0 THEN
326: oe_debug_pub.add( 'EXITING PROCEDURE CREATE_CUST_RELATIONSHIP' ) ;
327: END IF;

Line 347: oe_msg_pub.add;

343: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
344: END IF;
345: fnd_message.set_name('ONT','ONT_OI_INL_API_FAILED');
346: fnd_message.set_token('API_NAME', 'Create_Cust_Relationship');
347: oe_msg_pub.add;
348: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Unexpected error occured: ' || sqlerrm);
349: IF l_debug_level > 0 THEN
350: oe_debug_pub.add( 'EXITING CREATE_CUST_RELATIONSHIP API WITH ERROR' ) ;
351: END IF;

Line 348: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Unexpected error occured: ' || sqlerrm);

344: END IF;
345: fnd_message.set_name('ONT','ONT_OI_INL_API_FAILED');
346: fnd_message.set_token('API_NAME', 'Create_Cust_Relationship');
347: oe_msg_pub.add;
348: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Unexpected error occured: ' || sqlerrm);
349: IF l_debug_level > 0 THEN
350: oe_debug_pub.add( 'EXITING CREATE_CUST_RELATIONSHIP API WITH ERROR' ) ;
351: END IF;
352: END create_cust_relationship;

Line 486: oe_debug_pub.add( 'RETURN ERROR MESSAGE COUNT FROM HZ ' || OE_MSG_PUB.GET ( P_MSG_INDEX => L_MSG_COUNT ) ) ;

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
489: oe_debug_pub.add( 'RETURN ERROR MESSAGE FROM HZ ' || L_MSG_DATA ) ;
490: END IF;

Line 492: oe_msg_pub.transfer_msg_stack;

488: IF l_debug_level > 0 THEN
489: oe_debug_pub.add( 'RETURN ERROR MESSAGE FROM HZ ' || L_MSG_DATA ) ;
490: END IF;
491: x_return_status := l_return_status;
492: oe_msg_pub.transfer_msg_stack;
493: fnd_msg_pub.delete_msg;
494: IF l_debug_level > 0 THEN
495: oe_debug_pub.add( 'EXITING CREATE ROLE RESPONSIBILITY API WITH ERROR' ) ;
496: END IF;

Line 537: oe_msg_pub.add;

533: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
534: END IF;
535: fnd_message.set_name('ONT','ONT_OI_INL_API_FAILED');
536: fnd_message.set_token('API_NAME', 'Check_and_Create_Contact');
537: oe_msg_pub.add;
538: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Unexpected error occured: ' || sqlerrm);
539: IF l_debug_level > 0 THEN
540: oe_debug_pub.add( 'EXITING CHECK AND CREATE AND CREATE CONTACT API' ) ;
541: END IF;

Line 538: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Unexpected error occured: ' || sqlerrm);

534: END IF;
535: fnd_message.set_name('ONT','ONT_OI_INL_API_FAILED');
536: fnd_message.set_token('API_NAME', 'Check_and_Create_Contact');
537: oe_msg_pub.add;
538: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Unexpected error occured: ' || sqlerrm);
539: IF l_debug_level > 0 THEN
540: oe_debug_pub.add( 'EXITING CHECK AND CREATE AND CREATE CONTACT API' ) ;
541: END IF;
542:

Line 612: oe_debug_pub.add( 'RETURN ERROR MESSAGE COUNT FROM HZ ' || OE_MSG_PUB.GET ( P_MSG_INDEX => X_MSG_COUNT ) ) ;

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
615: oe_debug_pub.add( 'RETURN ERROR MESSAGE FROM HZ ' || X_MSG_DATA ) ;
616: END IF;

Line 618: oe_msg_pub.transfer_msg_stack;

614: IF l_debug_level > 0 THEN
615: oe_debug_pub.add( 'RETURN ERROR MESSAGE FROM HZ ' || X_MSG_DATA ) ;
616: END IF;
617: x_return_status := l_return_status;
618: oe_msg_pub.transfer_msg_stack;
619: fnd_msg_pub.delete_msg;
620: IF l_debug_level > 0 THEN
621: oe_debug_pub.add( 'EXITING CREATE CONTACT POINT API WITH ERROR' ) ;
622: END IF;

Line 654: oe_debug_pub.add( 'RETURN ERROR MESSAGE COUNT FROM HZ ' || OE_MSG_PUB.GET ( P_MSG_INDEX => X_MSG_COUNT ) ) ;

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
657: oe_debug_pub.add( 'RETURN ERROR MESSAGE FROM HZ ' || X_MSG_DATA ) ;
658: END IF;

Line 660: oe_msg_pub.transfer_msg_stack;

656: IF l_debug_level > 0 THEN
657: oe_debug_pub.add( 'RETURN ERROR MESSAGE FROM HZ ' || X_MSG_DATA ) ;
658: END IF;
659: x_return_status := l_return_status;
660: oe_msg_pub.transfer_msg_stack;
661: fnd_msg_pub.delete_msg;
662: IF l_debug_level > 0 THEN
663: oe_debug_pub.add( 'EXITING CREATE CONTACT POINT API WITH ERROR' ) ;
664: END IF;

Line 684: oe_msg_pub.add;

680: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
681: END IF;
682: fnd_message.set_name('ONT','ONT_OI_INL_API_FAILED');
683: fnd_message.set_token('API_NAME', 'Create_Contact_Point');
684: oe_msg_pub.add;
685: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Unexpected error occured: ' || sqlerrm);
686: IF l_debug_level > 0 THEN
687: oe_debug_pub.add( 'EXITING CREATE CONTACT POINT API WITH ERROR' ) ;
688: END IF;

Line 685: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Unexpected error occured: ' || sqlerrm);

681: END IF;
682: fnd_message.set_name('ONT','ONT_OI_INL_API_FAILED');
683: fnd_message.set_token('API_NAME', 'Create_Contact_Point');
684: oe_msg_pub.add;
685: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Unexpected error occured: ' || sqlerrm);
686: IF l_debug_level > 0 THEN
687: oe_debug_pub.add( 'EXITING CREATE CONTACT POINT API WITH ERROR' ) ;
688: END IF;
689:

Line 808: OE_MSG_PUB.set_msg_context(

804: If OE_ORDER_IMPORT_SPECIFIC_PVT.G_ONT_ADD_CUSTOMER = 'Y' Then
805: IF l_debug_level > 0 THEN
806: oe_debug_pub.add( 'ADD CUSTOMER PRIVILEGE IS THERE' ) ;
807: END IF;
808: OE_MSG_PUB.set_msg_context(
809: p_entity_code => 'OI_INL_ADDCUST'
810: ,p_entity_ref => null
811: ,p_entity_id => null
812: ,p_header_id => null

Line 873: oe_msg_pub.add;

869: END IF;
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

Line 881: oe_msg_pub.delete_msg(oe_msg_pub.g_msg_count);

877: Else
878: -- As the data is not duplicate but the call to oe_value_to_id
879: -- has entered one error message in stack(necessary evil!)
880: -- What to do => here is solution delete it
881: oe_msg_pub.delete_msg(oe_msg_pub.g_msg_count);
882: End if; -- Duplicate account check
883: -- End Check for the Duplicate Information }
884:
885: -- { Start Check for the Required Information

Line 895: oe_msg_pub.add;

891: END IF;
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:

Line 909: oe_msg_pub.add;

905: END IF;
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:

Line 923: oe_msg_pub.add;

919: END IF;
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 }

Line 962: oe_msg_pub.add;

958: IF l_debug_level > 0 THEN
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;

Line 1086: oe_debug_pub.add( 'RETURN ERROR MESSAGE COUNT FROM HZ ' || OE_MSG_PUB.GET ( P_MSG_INDEX => L_MSG_COUNT ) ) ;

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
1089: oe_debug_pub.add( 'RETURN ERROR MESSAGE FROM HZ ' || L_MSG_DATA ) ;
1090: END IF;

Line 1096: oe_msg_pub.transfer_msg_stack;

1092: IF l_debug_level > 0 THEN
1093: oe_debug_pub.add( 'EXITING IN CREATE_ACCOUNT PROCEDURE WITH ERROR' ) ;
1094: END IF;
1095: Update_Error_Flag(p_rowid => customer_rec.rowid);
1096: oe_msg_pub.transfer_msg_stack;
1097: fnd_msg_pub.delete_msg;
1098: return;
1099: Else
1100: IF l_debug_level > 0 THEN

Line 1240: oe_debug_pub.add( 'RETURN ERROR MESSAGE COUNT FROM HZ ' || OE_MSG_PUB.GET ( P_MSG_INDEX => L_MSG_COUNT ) ) ;

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
1243: oe_debug_pub.add( 'RETURN ERROR MESSAGE FROM HZ ' || L_MSG_DATA ) ;
1244: END IF;

Line 1250: oe_msg_pub.transfer_msg_stack;

1246: IF l_debug_level > 0 THEN
1247: oe_debug_pub.add( 'EXITING IN CREATE_ACCOUNT PROCEDURE WITH ERROR' ) ;
1248: END IF;
1249: Update_Error_Flag(p_rowid => customer_rec.rowid);
1250: oe_msg_pub.transfer_msg_stack;
1251: fnd_msg_pub.delete_msg;
1252: return;
1253: Else
1254: IF l_debug_level > 0 THEN

Line 1357: oe_msg_pub.add;

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' ) ;
1360: END IF;
1361: Update_Error_Flag(p_rowid => customer_rec.rowid);

Line 1378: oe_msg_pub.add;

1374: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
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

Line 1381: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Unexpected error occured: ' || sqlerrm);

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' ) ;
1384: END IF;
1385: End;

Line 1395: oe_msg_pub.add;

1391: oe_debug_pub.add( 'NO RECORD FOUND FOR THE PASSED REF , PLEASE CHECK DATA' ) ;
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;

Line 1408: oe_msg_pub.add;

1404: oe_debug_pub.add( 'ADD CUSTOMER PRIVILEGE IS NOT THERE' ) ;
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

Line 1421: oe_msg_pub.add;

1417: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
1418: END IF;
1419: fnd_message.set_name('ONT','ONT_OI_INL_API_FAILED');
1420: fnd_message.set_token('API_NAME', 'Create_Account');
1421: oe_msg_pub.add;
1422: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Unexpected error occured: ' || sqlerrm);
1423: IF l_debug_level > 0 THEN
1424: oe_debug_pub.add( 'EXITING IN CREATE_ACCOUNT PROCEDURE WITH ERROR' ) ;
1425: END IF;

Line 1422: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Unexpected error occured: ' || sqlerrm);

1418: END IF;
1419: fnd_message.set_name('ONT','ONT_OI_INL_API_FAILED');
1420: fnd_message.set_token('API_NAME', 'Create_Account');
1421: oe_msg_pub.add;
1422: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Unexpected error occured: ' || sqlerrm);
1423: IF l_debug_level > 0 THEN
1424: oe_debug_pub.add( 'EXITING IN CREATE_ACCOUNT PROCEDURE WITH ERROR' ) ;
1425: END IF;
1426: End Create_Account;

Line 1462: oe_msg_pub.add;

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');
1461: fnd_message.set_token('REFERENCE', p_customer_number);
1462: oe_msg_pub.add;
1463: IF l_debug_level > 0 THEN
1464: oe_debug_pub.add( 'EXITING IN CREATE_ACCOUNT PROCEDURE WITH ERROR' ) ;
1465: END IF;
1466: End validate_customer_number;

Line 1591: OE_MSG_PUB.set_msg_context(

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
1594: ,p_entity_id => null
1595: ,p_header_id => null

Line 1624: oe_msg_pub.add;

1620: END IF;
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

Line 1635: oe_msg_pub.add;

1631: END IF;
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

Line 1646: oe_msg_pub.add;

1642: END IF;
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:

Line 1741: oe_msg_pub.add;

1737: oe_debug_pub.add( 'PARENT_CUSTOMER_INFO_REF IS NULL' ) ;
1738: END IF;
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

Line 1795: oe_debug_pub.add( 'RETURN ERROR MESSAGE COUNT FROM HZ ' || OE_MSG_PUB.GET ( P_MSG_INDEX => L_MSG_COUNT ) ) ;

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
1798: oe_debug_pub.add( 'RETURN ERROR MESSAGE FROM HZ ' || L_MSG_DATA ) ;
1799: END IF;

Line 1825: oe_msg_pub.add;

1821: oe_debug_pub.add( 'NO RECORD FOUND FOR THE PASSED EXISTING CUSTOMER , PLEASE CHECK DATA' ) ;
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

Line 1882: oe_msg_pub.add;

1878: END IF;
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

Line 1890: oe_msg_pub.delete_msg(oe_msg_pub.g_msg_count);

1886: Else
1887: -- As the data is not duplicate but the call to oe_value_to_id
1888: -- has entered one error message in stack(necessary evil!)
1889: -- What to do => here is solution delete it
1890: oe_msg_pub.delete_msg(oe_msg_pub.g_msg_count);
1891: End if; -- duplicate ship_to_org check
1892: Elsif p_type_of_address = 'BILL_TO' Then
1893: l_duplicate_address := Oe_Value_To_Id.Invoice_To_Org(
1894: p_invoice_to_address1 => address_info_rec.address1,

Line 1915: oe_msg_pub.add;

1911: END IF;
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

Line 1923: oe_msg_pub.delete_msg(oe_msg_pub.g_msg_count);

1919: Else
1920: -- As the data is not duplicate but the call to oe_value_to_id
1921: -- has entered one error message in stack(necessary evil!)
1922: -- What to do => here is solution delete it
1923: oe_msg_pub.delete_msg(oe_msg_pub.g_msg_count);
1924: End if; -- duplicate bill_to_org check
1925: Elsif p_type_of_address = 'DELIVER_TO' Then
1926: l_duplicate_address := Oe_Value_To_Id.Deliver_To_Org(
1927: p_deliver_to_address1 => address_info_rec.address1,

Line 1948: oe_msg_pub.add;

1944: END IF;
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

Line 1956: oe_msg_pub.delete_msg(oe_msg_pub.g_msg_count);

1952: Else
1953: -- As the data is not duplicate but the call to oe_value_to_id
1954: -- has entered one error message in stack(necessary evil!)
1955: -- What to do => here is solution delete it
1956: oe_msg_pub.delete_msg(oe_msg_pub.g_msg_count);
1957: End if; -- duplicate deliver_to_org check
1958: End If;
1959: -- End Of If For duplicate checking}
1960: END IF; ----end of skip duplicate check --bug 7299729

Line 1976: oe_msg_pub.add;

1972: THEN
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;

Line 1994: oe_msg_pub.add;

1990: THEN
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;

Line 2068: oe_debug_pub.add( 'RETURN ERROR MESSAGE COUNT FROM HZ ' || OE_MSG_PUB.GET ( P_MSG_INDEX => L_MSG_COUNT ) ) ;

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
2068: oe_debug_pub.add( 'RETURN ERROR MESSAGE COUNT FROM HZ ' || OE_MSG_PUB.GET ( P_MSG_INDEX => L_MSG_COUNT ) ) ;
2069: END IF;
2070: IF l_debug_level > 0 THEN
2071: oe_debug_pub.add( 'RETURN ERROR MESSAGE FROM HZ ' || L_MSG_DATA ) ;
2072: END IF;

Line 2078: oe_msg_pub.transfer_msg_stack;

2074: IF l_debug_level > 0 THEN
2075: oe_debug_pub.add( 'EXITING IN CREATE_ADDRESS PROCEDURE WITH ERROR' ) ;
2076: END IF;
2077: Update_Error_Flag(p_rowid => address_info_rec.rowid);
2078: oe_msg_pub.transfer_msg_stack;
2079: fnd_msg_pub.delete_msg;
2080: return;
2081: End If;
2082:

Line 2142: oe_debug_pub.add( 'RETURN ERROR MESSAGE COUNT FROM HZ ' || OE_MSG_PUB.GET ( P_MSG_INDEX => L_MSG_COUNT ) ) ;

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
2142: oe_debug_pub.add( 'RETURN ERROR MESSAGE COUNT FROM HZ ' || OE_MSG_PUB.GET ( P_MSG_INDEX => L_MSG_COUNT ) ) ;
2143: END IF;
2144: IF l_debug_level > 0 THEN
2145: oe_debug_pub.add( 'RETURN ERROR MESSAGE FROM HZ ' || L_MSG_DATA ) ;
2146: END IF;

Line 2152: oe_msg_pub.transfer_msg_stack;

2148: IF l_debug_level > 0 THEN
2149: oe_debug_pub.add( 'EXITING IN CREATE_ADDRESS PROCEDURE WITH ERROR' ) ;
2150: END IF;
2151: Update_Error_Flag(p_rowid => address_info_rec.rowid);
2152: oe_msg_pub.transfer_msg_stack;
2153: fnd_msg_pub.delete_msg;
2154: return;
2155: End If;
2156:

Line 2233: oe_debug_pub.add( 'RETURN ERROR MESSAGE COUNT FROM HZ ' || OE_MSG_PUB.GET ( P_MSG_INDEX => L_MSG_COUNT ) ) ;

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
2233: oe_debug_pub.add( 'RETURN ERROR MESSAGE COUNT FROM HZ ' || OE_MSG_PUB.GET ( P_MSG_INDEX => L_MSG_COUNT ) ) ;
2234: END IF;
2235: IF l_debug_level > 0 THEN
2236: oe_debug_pub.add( 'RETURN ERROR MESSAGE FROM HZ ' || L_MSG_DATA ) ;
2237: END IF;

Line 2243: oe_msg_pub.transfer_msg_stack;

2239: IF l_debug_level > 0 THEN
2240: oe_debug_pub.add( 'EXITING IN CREATE_ADDRESS PROCEDURE WITH ERROR' ) ;
2241: END IF;
2242: Update_Error_Flag(p_rowid => address_info_rec.rowid);
2243: oe_msg_pub.transfer_msg_stack;
2244: fnd_msg_pub.delete_msg;
2245: return;
2246: End If;
2247:

Line 2282: oe_debug_pub.add( 'RETURN ERROR MESSAGE COUNT FROM HZ ' || OE_MSG_PUB.GET ( P_MSG_INDEX => L_MSG_COUNT ) ) ;

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
2282: oe_debug_pub.add( 'RETURN ERROR MESSAGE COUNT FROM HZ ' || OE_MSG_PUB.GET ( P_MSG_INDEX => L_MSG_COUNT ) ) ;
2283: END IF;
2284: IF l_debug_level > 0 THEN
2285: oe_debug_pub.add( 'RETURN ERROR MESSAGE FROM HZ ' || L_MSG_DATA ) ;
2286: END IF;

Line 2292: oe_msg_pub.transfer_msg_stack;

2288: IF l_debug_level > 0 THEN
2289: oe_debug_pub.add( 'EXITING IN CREATE_ADDRESS PROCEDURE WITH ERROR' ) ;
2290: END IF;
2291: Update_Error_Flag(p_rowid => address_info_rec.rowid);
2292: oe_msg_pub.transfer_msg_stack;
2293: fnd_msg_pub.delete_msg;
2294: return;
2295: End If;
2296:

Line 2340: oe_debug_pub.add( 'RETURN ERROR MESSAGE COUNT FROM HZ ' || OE_MSG_PUB.GET ( P_MSG_INDEX => L_MSG_COUNT ) ) ;

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
2340: oe_debug_pub.add( 'RETURN ERROR MESSAGE COUNT FROM HZ ' || OE_MSG_PUB.GET ( P_MSG_INDEX => L_MSG_COUNT ) ) ;
2341: END IF;
2342: IF l_debug_level > 0 THEN
2343: oe_debug_pub.add( 'RETURN ERROR MESSAGE FROM HZ ' || L_MSG_DATA ) ;
2344: END IF;

Line 2350: oe_msg_pub.transfer_msg_stack;

2346: IF l_debug_level > 0 THEN
2347: oe_debug_pub.add( 'EXITING IN CREATE_ADDRESS PROCEDURE WITH ERROR' ) ;
2348: END IF;
2349: Update_Error_Flag(p_rowid => address_info_rec.rowid);
2350: oe_msg_pub.transfer_msg_stack;
2351: fnd_msg_pub.delete_msg;
2352: return;
2353: End If;
2354:

Line 2394: oe_debug_pub.add( 'RETURN ERROR MESSAGE COUNT FROM HZ ' || OE_MSG_PUB.GET ( P_MSG_INDEX => L_MSG_COUNT ) ) ;

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
2394: oe_debug_pub.add( 'RETURN ERROR MESSAGE COUNT FROM HZ ' || OE_MSG_PUB.GET ( P_MSG_INDEX => L_MSG_COUNT ) ) ;
2395: END IF;
2396: IF l_debug_level > 0 THEN
2397: oe_debug_pub.add( 'RETURN ERROR MESSAGE FROM HZ ' || L_MSG_DATA ) ;
2398: END IF;

Line 2407: oe_msg_pub.transfer_msg_stack;

2403: IF l_debug_level > 0 THEN
2404: oe_debug_pub.add( 'EXITING IN CREATE_ADDRESS PROCEDURE WITH ERROR' ) ;
2405: END IF;
2406: Update_Error_Flag(p_rowid => address_info_rec.rowid);
2407: oe_msg_pub.transfer_msg_stack;
2408: fnd_msg_pub.delete_msg;
2409: return;
2410: End If;
2411:

Line 2437: oe_msg_pub.add;

2433: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
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

Line 2440: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Unexpected error occured: ' || sqlerrm);

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' ) ;
2443: END IF;
2444:

Line 2455: oe_msg_pub.add;

2451: oe_debug_pub.add( 'NO RECORD FOUND FOR THE PASSED REF , PLEASE CHECK DATA' ) ;
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;

Line 2474: oe_msg_pub.add;

2470: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
2471: END IF;
2472: fnd_message.set_name('ONT','ONT_OI_INL_API_FAILED');
2473: fnd_message.set_token('API_NAME', 'Create_Address');
2474: oe_msg_pub.add;
2475: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Unexpected error occured: ' || sqlerrm);
2476: IF l_debug_level > 0 THEN
2477: oe_debug_pub.add( 'EXITING IN CREATE_ADDRESS PROCEDURE WITH ERROR' ) ;
2478: END IF;

Line 2475: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Unexpected error occured: ' || sqlerrm);

2471: END IF;
2472: fnd_message.set_name('ONT','ONT_OI_INL_API_FAILED');
2473: fnd_message.set_token('API_NAME', 'Create_Address');
2474: oe_msg_pub.add;
2475: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Unexpected error occured: ' || sqlerrm);
2476: IF l_debug_level > 0 THEN
2477: oe_debug_pub.add( 'EXITING IN CREATE_ADDRESS PROCEDURE WITH ERROR' ) ;
2478: END IF;
2479:

Line 2578: OE_MSG_PUB.set_msg_context(

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
2581: ,p_entity_id => null
2582: ,p_header_id => null

Line 2660: oe_msg_pub.add;

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;
2662: End If;
2663: -- End of if parent rec is passed or not}
2664:

Line 2715: oe_msg_pub.add;

2711: oe_debug_pub.add( 'NO RECORD FOUND FOR THE PASSED EXISTING CUSTOMER , PLEASE CHECK DATA' ) ;
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

Line 2752: oe_msg_pub.add;

2748: oe_debug_pub.add( 'TRYING TO ENTER THE SOLD_TO CONTACT WHICH ALREADY EXISTS' ) ;
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

Line 2760: oe_msg_pub.delete_msg(oe_msg_pub.g_msg_count);

2756: Else
2757: -- As the data is not duplicate but the call to oe_value_to_id
2758: -- has entered one error message in stack(necessary evil!)
2759: -- What to do => here is solution delete it
2760: oe_msg_pub.delete_msg(oe_msg_pub.g_msg_count);
2761: End if; -- duplicate sold_to contact check
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,

Line 2773: oe_msg_pub.add;

2769: oe_debug_pub.add( 'TRYING TO ENTER THE SHIP_TO CONTACT WHICH ALREADY EXISTS' ) ;
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

Line 2781: oe_msg_pub.delete_msg(oe_msg_pub.g_msg_count);

2777: Else
2778: -- As the data is not duplicate but the call to oe_value_to_id
2779: -- has entered one error message in stack(necessary evil!)
2780: -- What to do => here is solution delete it
2781: oe_msg_pub.delete_msg(oe_msg_pub.g_msg_count);
2782: End if; -- duplicate ship_to contact check
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,

Line 2794: oe_msg_pub.add;

2790: oe_debug_pub.add( 'TRYING TO ENTER THE BILL_TO CONTACT WHICH ALREADY EXISTS' ) ;
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

Line 2802: oe_msg_pub.delete_msg(oe_msg_pub.g_msg_count);

2798: Else
2799: -- As the data is not duplicate but the call to oe_value_to_id
2800: -- has entered one error message in stack(necessary evil!)
2801: -- What to do => here is solution delete it
2802: oe_msg_pub.delete_msg(oe_msg_pub.g_msg_count);
2803: End if; -- duplicate bill_to contact check
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,

Line 2815: oe_msg_pub.add;

2811: oe_debug_pub.add( 'TRYING TO ENTER THE DELIVER_TO CONTACT WHICH ALREADY EXISTS' ) ;
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

Line 2823: oe_msg_pub.delete_msg(oe_msg_pub.g_msg_count);

2819: Else
2820: -- As the data is not duplicate but the call to oe_value_to_id
2821: -- has entered one error message in stack(necessary evil!)
2822: -- What to do => here is solution delete it
2823: oe_msg_pub.delete_msg(oe_msg_pub.g_msg_count);
2824: End if; -- duplicate deliver_to contact check
2825: End if;
2826: -- End of If for duplicate contact check}
2827:

Line 2900: oe_debug_pub.add( 'RETURN ERROR MESSAGE COUNT FROM HZ ' || OE_MSG_PUB.GET ( P_MSG_INDEX => L_MSG_COUNT ) ) ;

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
2900: oe_debug_pub.add( 'RETURN ERROR MESSAGE COUNT FROM HZ ' || OE_MSG_PUB.GET ( P_MSG_INDEX => L_MSG_COUNT ) ) ;
2901: END IF;
2902: IF l_debug_level > 0 THEN
2903: oe_debug_pub.add( 'RETURN ERROR MESSAGE FROM HZ ' || L_MSG_DATA ) ;
2904: END IF;

Line 2910: oe_msg_pub.transfer_msg_stack;

2906: IF l_debug_level > 0 THEN
2907: oe_debug_pub.add( 'EXITING IN CREATE_CONTACT PROCEDURE WITH ERROR' ) ;
2908: END IF;
2909: Update_Error_Flag(p_rowid => contact_rec.rowid);
2910: oe_msg_pub.transfer_msg_stack;
2911: fnd_msg_pub.delete_msg;
2912: return;
2913: End If;
2914:

Line 2991: oe_debug_pub.add( 'RETURN ERROR MESSAGE COUNT FROM HZ ' || OE_MSG_PUB.GET ( P_MSG_INDEX => L_MSG_COUNT ) ) ;

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
2991: oe_debug_pub.add( 'RETURN ERROR MESSAGE COUNT FROM HZ ' || OE_MSG_PUB.GET ( P_MSG_INDEX => L_MSG_COUNT ) ) ;
2992: END IF;
2993: IF l_debug_level > 0 THEN
2994: oe_debug_pub.add( 'RETURN ERROR MESSAGE FROM HZ ' || L_MSG_DATA ) ;
2995: END IF;

Line 3001: oe_msg_pub.transfer_msg_stack;

2997: IF l_debug_level > 0 THEN
2998: oe_debug_pub.add( 'EXITING IN CREATE_CONTACT PROCEDURE WITH ERROR' ) ;
2999: END IF;
3000: Update_Error_Flag(p_rowid => contact_rec.rowid);
3001: oe_msg_pub.transfer_msg_stack;
3002: fnd_msg_pub.delete_msg;
3003: return;
3004: End If;
3005:

Line 3118: oe_debug_pub.add( 'RETURN ERROR MESSAGE COUNT FROM HZ ' || OE_MSG_PUB.GET ( P_MSG_INDEX => L_MSG_COUNT ) ) ;

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
3118: oe_debug_pub.add( 'RETURN ERROR MESSAGE COUNT FROM HZ ' || OE_MSG_PUB.GET ( P_MSG_INDEX => L_MSG_COUNT ) ) ;
3119: END IF;
3120: IF l_debug_level > 0 THEN
3121: oe_debug_pub.add( 'RETURN ERROR MESSAGE FROM HZ ' || L_MSG_DATA ) ;
3122: END IF;

Line 3128: oe_msg_pub.transfer_msg_stack;

3124: IF l_debug_level > 0 THEN
3125: oe_debug_pub.add( 'EXITING IN CREATE_CONTACT PROCEDURE WITH ERROR' ) ;
3126: END IF;
3127: Update_Error_Flag(p_rowid => contact_rec.rowid);
3128: oe_msg_pub.transfer_msg_stack;
3129: fnd_msg_pub.delete_msg;
3130: return;
3131: End If;
3132: IF l_debug_level > 0 THEN

Line 3187: oe_msg_pub.add;

3183: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
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

Line 3190: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Unexpected error occured: ' || sqlerrm);

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' ) ;
3193: END IF;
3194: End;

Line 3206: oe_msg_pub.add;

3202: oe_debug_pub.add( 'NO RECORD FOUND FOR THE PASSED REF , PLEASE CHECK DATA' ) ;
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;

Line 3225: oe_msg_pub.add;

3221: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
3222: END IF;
3223: fnd_message.set_name('ONT','ONT_OI_INL_API_FAILED');
3224: fnd_message.set_token('API_NAME', 'Create_Contact');
3225: oe_msg_pub.add;
3226: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Unexpected error occured: ' || sqlerrm);
3227: IF l_debug_level > 0 THEN
3228: oe_debug_pub.add( 'EXITING IN CREATE_CONTACT PROCEDURE WITH ERROR' ) ;
3229: END IF;

Line 3226: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Unexpected error occured: ' || sqlerrm);

3222: END IF;
3223: fnd_message.set_name('ONT','ONT_OI_INL_API_FAILED');
3224: fnd_message.set_token('API_NAME', 'Create_Contact');
3225: oe_msg_pub.add;
3226: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Unexpected error occured: ' || sqlerrm);
3227: IF l_debug_level > 0 THEN
3228: oe_debug_pub.add( 'EXITING IN CREATE_CONTACT PROCEDURE WITH ERROR' ) ;
3229: END IF;
3230: End Create_Contact;

Line 3470: oe_msg_pub.add;

3466: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
3467: END IF;
3468: fnd_message.set_name('ONT','ONT_OI_INL_API_FAILED');
3469: fnd_message.set_token('API_NAME', 'Create_Customer_Info');
3470: oe_msg_pub.add;
3471: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Unexpected error occured: ' || sqlerrm);
3472: IF l_debug_level > 0 THEN
3473: oe_debug_pub.add( 'EXITING IN CREATE_CUSTOMER_INFO PROCEDURE WITH ERROR' ) ;
3474: END IF;

Line 3471: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Unexpected error occured: ' || sqlerrm);

3467: END IF;
3468: fnd_message.set_name('ONT','ONT_OI_INL_API_FAILED');
3469: fnd_message.set_token('API_NAME', 'Create_Customer_Info');
3470: oe_msg_pub.add;
3471: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Unexpected error occured: ' || sqlerrm);
3472: IF l_debug_level > 0 THEN
3473: oe_debug_pub.add( 'EXITING IN CREATE_CUSTOMER_INFO PROCEDURE WITH ERROR' ) ;
3474: END IF;
3475:

Line 3827: oe_msg_pub.add;

3823: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
3824: END IF;
3825: fnd_message.set_name('ONT','ONT_OI_INL_API_FAILED');
3826: fnd_message.set_token('API_NAME', 'Delete_Customer_Info');
3827: oe_msg_pub.add;
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;

Line 3828: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Unexpected error occured: ' || sqlerrm);

3824: END IF;
3825: fnd_message.set_name('ONT','ONT_OI_INL_API_FAILED');
3826: fnd_message.set_token('API_NAME', 'Delete_Customer_Info');
3827: oe_msg_pub.add;
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;