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_CUSTOMER_INFO_PVT dependencies on OE_MSG_PUB

Line 76: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

72: oe_debug_pub.add( 'PROBLEM IN CALL TO INITIALIZE_GLOBAL. ABORT PROCESSING'||SQLERRM ) ;
73: END IF;
74: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
75:
76: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
77: THEN
78: OE_MSG_PUB.Add_Exc_Msg
79: ( G_PKG_NAME
80: , 'Initialize_Global'

Line 78: OE_MSG_PUB.Add_Exc_Msg

74: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
75:
76: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
77: THEN
78: OE_MSG_PUB.Add_Exc_Msg
79: ( G_PKG_NAME
80: , 'Initialize_Global'
81: );
82: END IF;

Line 330: oe_msg_pub.add;

326: IF G_ONT_ADD_CUSTOMER = 'N' THEN /* Nothing allowed */
327:
328: fnd_message.set_name('ONT','ONT_OI_INL_SET_PARAMETER');
329: fnd_message.set_token('TYPE', 'Customers, Addresses or Contacts');
330: oe_msg_pub.add;
331: x_return_status := FND_API.G_RET_STS_ERROR;
332: RETURN;
333:
334: ELSIF G_ONT_ADD_CUSTOMER = 'P' THEN /* Address and contact can be added to an exisiting customer */

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

370: , x_customer_id => l_new_sold_to_org_id
371: );
372:
373: IF l_new_sold_to_org_id = FND_API.G_MISS_NUM THEN
374: oe_msg_pub.delete_msg(oe_msg_pub.g_msg_count);
375: ELSE
376: x_sold_to_customer_id := l_new_sold_to_org_id;
377: p_customer_info_tbl(l_sold_to_cust_index).new_account_id := l_new_sold_to_org_id;
378: END IF;

Line 452: oe_msg_pub.transfer_msg_stack;

448: oe_debug_pub.add(' Create_account : x_msg_data :'||x_msg_data);
449: END IF;
450:
451: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
452: oe_msg_pub.transfer_msg_stack;
453: RETURN;
454: END IF;
455:
456:

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

491: , x_customer_id => l_new_ship_to_customer_id
492: );
493:
494: IF l_new_ship_to_customer_id = FND_API.G_MISS_NUM THEN
495: oe_msg_pub.delete_msg(oe_msg_pub.g_msg_count);
496: ELSE
497: x_ship_to_customer_id := l_new_ship_to_customer_id;
498: p_customer_info_tbl(l_ship_to_cust_index).new_account_id := l_new_ship_to_customer_id;
499: END IF;

Line 571: oe_msg_pub.transfer_msg_stack;

567: oe_debug_pub.add(' Create_account : x_msg_data :'||x_msg_data);
568: END IF;
569:
570: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
571: oe_msg_pub.transfer_msg_stack;
572: RETURN;
573: END IF;
574: END IF;
575:

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

597: );
598:
599:
600: IF l_new_bill_to_customer_id = FND_API.G_MISS_NUM THEN
601: oe_msg_pub.delete_msg(oe_msg_pub.g_msg_count);
602: ELSE
603: x_bill_to_customer_id := l_new_bill_to_customer_id;
604: p_customer_info_tbl(l_bill_to_cust_index).new_account_id := l_new_bill_to_customer_id;
605: END IF;

Line 679: oe_msg_pub.transfer_msg_stack;

675: oe_debug_pub.add(' Create_account : x_msg_data :'||x_msg_data);
676: END IF;
677:
678: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
679: oe_msg_pub.transfer_msg_stack;
680: RETURN;
681: END IF;
682:
683: END IF;

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

707: );
708:
709:
710: IF l_new_deliver_to_cust_id = FND_API.G_MISS_NUM THEN
711: oe_msg_pub.delete_msg(oe_msg_pub.g_msg_count);
712: ELSE
713: x_deliver_to_customer_id := l_new_deliver_to_cust_id;
714: p_customer_info_tbl(l_deliver_to_cust_index).new_account_id := l_new_deliver_to_cust_id;
715: END IF;

Line 792: oe_msg_pub.transfer_msg_stack;

788: END IF;
789:
790:
791: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
792: oe_msg_pub.transfer_msg_stack;
793: RETURN;
794: END IF;
795:
796: END IF;

Line 821: oe_msg_pub.transfer_msg_stack;

817: oe_debug_pub.add('Create_relationships :x_msg_data : '||x_msg_data);
818: END IF;
819:
820: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
821: oe_msg_pub.transfer_msg_stack;
822: RETURN;
823: END IF;
824:
825: END IF;

Line 876: OE_MSG_PUB.Add;

872: IF NOT IS_VALID_ID( p_customer_id => l_customer_id ) THEN
873: x_return_status := FND_API.G_RET_STS_ERROR;
874: FND_MESSAGE.set_name('ONT','OE_INVALID_ATTRIBUTE');
875: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CUSTOMER_ID');
876: OE_MSG_PUB.Add;
877: RETURN;
878: END IF;
879:
880:

Line 952: OE_MSG_PUB.Add;

948: IF NOT IS_VALID_ID( p_customer_id => l_customer_id ) THEN
949: x_return_status := FND_API.G_RET_STS_ERROR;
950: FND_MESSAGE.set_name('ONT','OE_INVALID_ATTRIBUTE');
951: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CUSTOMER_ID');
952: OE_MSG_PUB.Add;
953: RETURN;
954: END IF;
955:
956:

Line 1027: OE_MSG_PUB.Add;

1023: IF NOT IS_VALID_ID( p_customer_id => l_customer_id ) THEN
1024: x_return_status := FND_API.G_RET_STS_ERROR;
1025: FND_MESSAGE.set_name('ONT','OE_INVALID_ATTRIBUTE');
1026: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CUSTOMER_ID');
1027: OE_MSG_PUB.Add;
1028: RETURN;
1029: END IF;
1030:
1031:

Line 1102: OE_MSG_PUB.Add;

1098: IF NOT IS_VALID_ID( p_customer_id => l_customer_id ) THEN
1099: x_return_status := FND_API.G_RET_STS_ERROR;
1100: FND_MESSAGE.set_name('ONT','OE_INVALID_ATTRIBUTE');
1101: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CUSTOMER_ID');
1102: OE_MSG_PUB.Add;
1103: RETURN;
1104: END IF;
1105:
1106: Create_Addresses (

Line 1181: OE_MSG_PUB.Add;

1177: IF NOT IS_VALID_ID( p_customer_id => l_customer_id ) THEN
1178: x_return_status := FND_API.G_RET_STS_ERROR;
1179: FND_MESSAGE.set_name('ONT','OE_INVALID_ATTRIBUTE');
1180: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CUSTOMER_ID');
1181: OE_MSG_PUB.Add;
1182: RETURN;
1183: END IF;
1184:
1185: Create_Contact ( p_customer_info_tbl => p_customer_info_tbl

Line 1200: oe_msg_pub.transfer_msg_stack;

1196: , x_msg_data => x_msg_data
1197: );
1198:
1199: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1200: oe_msg_pub.transfer_msg_stack;
1201: x_return_status := FND_API.G_RET_STS_ERROR;
1202: RETURN;
1203: END IF;
1204:

Line 1252: OE_MSG_PUB.Add;

1248: IF NOT IS_VALID_ID( p_customer_id => l_customer_id ) THEN
1249: x_return_status := FND_API.G_RET_STS_ERROR;
1250: FND_MESSAGE.set_name('ONT','OE_INVALID_ATTRIBUTE');
1251: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CUSTOMER_ID');
1252: OE_MSG_PUB.Add;
1253: RETURN;
1254: END IF;
1255:
1256: Create_Contact ( p_customer_info_tbl => p_customer_info_tbl

Line 1271: oe_msg_pub.transfer_msg_stack;

1267: , x_msg_data => x_msg_data
1268: );
1269:
1270: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1271: oe_msg_pub.transfer_msg_stack;
1272: x_return_status := FND_API.G_RET_STS_ERROR;
1273: RETURN;
1274: END IF;
1275:

Line 1325: OE_MSG_PUB.Add;

1321: IF NOT IS_VALID_ID( p_customer_id => l_customer_id ) THEN
1322: x_return_status := FND_API.G_RET_STS_ERROR;
1323: FND_MESSAGE.set_name('ONT','OE_INVALID_ATTRIBUTE');
1324: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CUSTOMER_ID');
1325: OE_MSG_PUB.Add;
1326: RETURN;
1327: END IF;
1328:
1329: Create_Contact ( p_customer_info_tbl => p_customer_info_tbl

Line 1344: oe_msg_pub.transfer_msg_stack;

1340: , x_msg_data => x_msg_data
1341: );
1342:
1343: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1344: oe_msg_pub.transfer_msg_stack;
1345: x_return_status := FND_API.G_RET_STS_ERROR;
1346: RETURN;
1347: END IF;
1348:

Line 1397: OE_MSG_PUB.Add;

1393: IF NOT IS_VALID_ID( p_customer_id => l_customer_id ) THEN
1394: x_return_status := FND_API.G_RET_STS_ERROR;
1395: FND_MESSAGE.set_name('ONT','OE_INVALID_ATTRIBUTE');
1396: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CUSTOMER_ID');
1397: OE_MSG_PUB.Add;
1398: RETURN;
1399: END IF;
1400:
1401: Create_Contact ( p_customer_info_tbl => p_customer_info_tbl

Line 1416: oe_msg_pub.transfer_msg_stack;

1412: , x_msg_data => x_msg_data
1413: );
1414:
1415: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1416: oe_msg_pub.transfer_msg_stack;
1417: x_return_status := FND_API.G_RET_STS_ERROR;
1418: RETURN;
1419: END IF;
1420:

Line 1440: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1436: END IF;
1437:
1438: x_return_status := FND_API.G_RET_STS_ERROR;
1439:
1440: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1441: THEN
1442: OE_MSG_PUB.Add_Exc_Msg
1443: ( G_PKG_NAME
1444: , 'get_customer_info_ids'

Line 1442: OE_MSG_PUB.Add_Exc_Msg

1438: x_return_status := FND_API.G_RET_STS_ERROR;
1439:
1440: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1441: THEN
1442: OE_MSG_PUB.Add_Exc_Msg
1443: ( G_PKG_NAME
1444: , 'get_customer_info_ids'
1445: );
1446: END IF;

Line 1448: OE_MSG_PUB.Count_And_Get

1444: , 'get_customer_info_ids'
1445: );
1446: END IF;
1447:
1448: OE_MSG_PUB.Count_And_Get
1449: ( p_count => x_msg_count
1450: , p_data => x_msg_data
1451: );
1452:

Line 1524: OE_MSG_PUB.Add;

1520: l_party_id := l_customer_info_rec.party_id;
1521: ELSE
1522: FND_MESSAGE.set_name('ONT','OE_INVALID_ATTRIBUTE');
1523: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','PARTY_ID');
1524: OE_MSG_PUB.Add;
1525: x_return_status := FND_API.G_RET_STS_ERROR;
1526:
1527: END IF;
1528: END IF;

Line 1687: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1683: Exception
1684: WHEN OTHERS THEN
1685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1686:
1687: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1688: THEN
1689: OE_MSG_PUB.Add_Exc_Msg
1690: ( G_PKG_NAME
1691: , 'Create_account'

Line 1689: OE_MSG_PUB.Add_Exc_Msg

1685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1686:
1687: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1688: THEN
1689: OE_MSG_PUB.Add_Exc_Msg
1690: ( G_PKG_NAME
1691: , 'Create_account'
1692: );
1693: END IF;

Line 1818: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1814: Exception
1815: WHEN OTHERS THEN
1816: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1817:
1818: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1819: THEN
1820: OE_MSG_PUB.Add_Exc_Msg
1821: ( G_PKG_NAME
1822: , 'Create_relationships'

Line 1820: OE_MSG_PUB.Add_Exc_Msg

1816: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1817:
1818: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1819: THEN
1820: OE_MSG_PUB.Add_Exc_Msg
1821: ( G_PKG_NAME
1822: , 'Create_relationships'
1823: );
1824: END IF;

Line 1985: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1981: IF l_debug_level > 0 THEN
1982: oe_debug_pub.add('Unexpected error in OE_CUSTOMER_INFO_PVT.Create_Party_Site '||SQLERRM);
1983: END IF;
1984:
1985: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1986: THEN
1987: OE_MSG_PUB.Add_Exc_Msg
1988: ( G_PKG_NAME
1989: , 'Create_Party_Site'

Line 1987: OE_MSG_PUB.Add_Exc_Msg

1983: END IF;
1984:
1985: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1986: THEN
1987: OE_MSG_PUB.Add_Exc_Msg
1988: ( G_PKG_NAME
1989: , 'Create_Party_Site'
1990: );
1991: END IF;

Line 2079: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2075: IF l_debug_level > 0 THEN
2076: oe_debug_pub.add('Unexpected error in OE_CUSTOMER_INFO_PVT.Create_Cust_Account_Site '||SQLERRM);
2077: END IF;
2078:
2079: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2080: THEN
2081: OE_MSG_PUB.Add_Exc_Msg
2082: ( G_PKG_NAME
2083: , 'Create_Cust_Account_Site'

Line 2081: OE_MSG_PUB.Add_Exc_Msg

2077: END IF;
2078:
2079: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2080: THEN
2081: OE_MSG_PUB.Add_Exc_Msg
2082: ( G_PKG_NAME
2083: , 'Create_Cust_Account_Site'
2084: );
2085: END IF;

Line 2154: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2150: IF l_debug_level > 0 THEN
2151: oe_debug_pub.add('Unexpected error in OE_CUSTOMER_INFO_PVT.Create_Acct_Site_Uses '||SQLERRM);
2152: END IF;
2153:
2154: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2155: THEN
2156: OE_MSG_PUB.Add_Exc_Msg
2157: ( G_PKG_NAME
2158: , 'Create_Acct_Site_Uses'

Line 2156: OE_MSG_PUB.Add_Exc_Msg

2152: END IF;
2153:
2154: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2155: THEN
2156: OE_MSG_PUB.Add_Exc_Msg
2157: ( G_PKG_NAME
2158: , 'Create_Acct_Site_Uses'
2159: );
2160: END IF;

Line 2216: oe_msg_pub.transfer_msg_stack;

2212: END IF;
2213:
2214: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2215: x_party_site_id := FND_API.G_MISS_NUM;
2216: oe_msg_pub.transfer_msg_stack;
2217: RETURN;
2218: END IF;
2219:
2220:

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

2415: , p_site_usage => p_address_usage
2416: , x_site_usage_id => x_site_use_id);
2417:
2418: IF x_site_use_id = FND_API.G_MISS_NUM THEN
2419: oe_msg_pub.delete_msg(oe_msg_pub.g_msg_count);
2420: ELSE
2421: IF p_address_usage = 'SHIP_TO' THEN
2422: x_ship_to_org_id := x_site_use_id;
2423: ELSIF p_address_usage ='BILL_TO' THEN

Line 2454: oe_msg_pub.transfer_msg_stack;

2450: oe_debug_pub.add('Update_Location :x_msg_data'||x_msg_data);
2451: END IF;
2452:
2453: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2454: oe_msg_pub.transfer_msg_stack;
2455: RETURN;
2456: END IF;
2457:
2458: x_site_use_id := l_addr_rec.site_use_id;

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

2484: , p_site_usage => p_address_usage
2485: , x_site_usage_id => x_site_use_id);
2486:
2487: IF x_site_use_id = FND_API.G_MISS_NUM THEN
2488: oe_msg_pub.delete_msg(oe_msg_pub.g_msg_count);
2489: ELSE
2490: IF p_address_usage = 'SHIP_TO' THEN
2491: x_ship_to_org_id := x_site_use_id;
2492: ELSIF p_address_usage ='BILL_TO' THEN

Line 2557: oe_msg_pub.transfer_msg_stack;

2553: oe_debug_pub.add(p_address_usage||': Create_Acct_Site_Uses:x_site_use_id'||x_site_use_id);
2554: END IF;
2555:
2556: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2557: oe_msg_pub.transfer_msg_stack;
2558: RETURN;
2559: END IF;
2560:
2561: ELSE

Line 2579: oe_msg_pub.transfer_msg_stack;

2575: x_msg_data =>x_msg_data
2576: );
2577:
2578: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2579: oe_msg_pub.transfer_msg_stack;
2580: RETURN;
2581: END IF;
2582:
2583: END IF;

Line 2614: oe_msg_pub.transfer_msg_stack;

2610: oe_debug_pub.add(p_address_usage||': Create_Cust_Account_Site:x_ship_account_site_id'||x_ship_account_site_id);
2611: END IF;
2612:
2613: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2614: oe_msg_pub.transfer_msg_stack;
2615: RETURN;
2616: END IF;
2617:
2618: Create_Acct_Site_Uses(

Line 2636: oe_msg_pub.transfer_msg_stack;

2632: oe_debug_pub.add(p_address_usage||': Create_Acct_Site_Uses:x_site_use_id'||x_site_use_id);
2633: END IF;
2634:
2635: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2636: oe_msg_pub.transfer_msg_stack;
2637: RETURN;
2638: END IF;
2639:
2640:

Line 2673: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2669: EXCEPTION
2670: WHEN OTHERS THEN
2671: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2672:
2673: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2674: THEN
2675: OE_MSG_PUB.Add_Exc_Msg
2676: ( G_PKG_NAME
2677: , 'Create_Addresses'

Line 2675: OE_MSG_PUB.Add_Exc_Msg

2671: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2672:
2673: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2674: THEN
2675: OE_MSG_PUB.Add_Exc_Msg
2676: ( G_PKG_NAME
2677: , 'Create_Addresses'
2678: );
2679: END IF;

Line 2695: oe_msg_pub.add;

2691: IF p_customer_record.customer_type IS NULL THEN
2692: fnd_message.set_name('ONT','ONT_PO_INL_REQD');
2693: fnd_message.set_token('API_NAME', 'CREATE_ACCOUNT');
2694: fnd_message.set_token('FIELD_REQD', 'CUSTOMER_TYPE');
2695: oe_msg_pub.add;
2696: x_return_status := FND_API.G_RET_STS_ERROR;
2697:
2698: IF l_debug_level > 0 THEN
2699: oe_debug_pub.add( 'CUSTOMER TYPE REQUIRED BUT NOT ENTERED' ) ;

Line 2712: oe_msg_pub.add;

2708: THEN
2709: fnd_message.set_name('ONT','ONT_PO_INL_REQD');
2710: fnd_message.set_token('API_NAME', 'CREATE_ACCOUNT');
2711: fnd_message.set_token('FIELD_REQD', 'ORGANIZATION_NAME');
2712: oe_msg_pub.add;
2713: x_return_status := FND_API.G_RET_STS_ERROR;
2714:
2715: IF l_debug_level > 0 THEN
2716: oe_debug_pub.add( 'ORGANIZATION NAME REQUIRED BUT NOT ENTERED' ) ;

Line 2731: oe_msg_pub.add;

2727: THEN
2728: fnd_message.set_name('ONT','ONT_PO_INL_REQD');
2729: fnd_message.set_token('API_NAME', 'CREATE_ACCOUNT');
2730: fnd_message.set_token('FIELD_REQD', 'PERSON_FIRST_NAME');
2731: oe_msg_pub.add;
2732: x_return_status := FND_API.G_RET_STS_ERROR;
2733:
2734: IF l_debug_level > 0 THEN
2735: oe_debug_pub.add( 'PERSON FIRST/LAST NAME REQUIRED BUT NOT ENTERED' ) ;

Line 2747: oe_msg_pub.add;

2743: p_customer_record.email_address is NULL THEN
2744: fnd_message.set_name('ONT','ONT_PO_INL_REQD');
2745: fnd_message.set_token('API_NAME', 'CREATE_ACCOUNT');
2746: fnd_message.set_token('FIELD_REQD', 'EMAIL_ADDRESS');
2747: oe_msg_pub.add;
2748: x_return_status := FND_API.G_RET_STS_ERROR;
2749:
2750: IF l_debug_level > 0 THEN
2751: oe_debug_pub.add( 'EMAIL REQUIRED BUT NOT ENTERED' ) ;

Line 2761: oe_msg_pub.add;

2757:
2758: fnd_message.set_name('ONT','ONT_PO_INL_REQD');
2759: fnd_message.set_token('API_NAME', 'CREATE_ACCOUNT');
2760: fnd_message.set_token('FIELD_REQD', 'PARTY_NUMBER');
2761: oe_msg_pub.add;
2762: x_return_status := FND_API.G_RET_STS_ERROR;
2763:
2764: IF l_debug_level > 0 THEN
2765: oe_debug_pub.add( 'PARTY NUMBER REQUIRED BUT NOT ENTERED' ) ;

Line 2776: oe_msg_pub.add;

2772:
2773: fnd_message.set_name('ONT','ONT_PO_INL_REQD');
2774: fnd_message.set_token('API_NAME', 'CREATE_ACCOUNT');
2775: fnd_message.set_token('FIELD_REQD', 'CUSTOMER_NUMBER');
2776: oe_msg_pub.add;
2777: x_return_status := FND_API.G_RET_STS_ERROR;
2778:
2779: IF l_debug_level > 0 THEN
2780: oe_debug_pub.add( 'CUSTOMER NUMBER REQUIRED BUT NOT ENTERED' ) ;

Line 2801: OE_MSG_PUB.Add;

2797:
2798: IF p_customer_record.customer_type NOT IN ('ORGANIZATION','PERSON') THEN
2799: FND_MESSAGE.set_name('ONT','OE_INVALID_ATTRIBUTE');
2800: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','PARTY_ID');
2801: OE_MSG_PUB.Add;
2802: x_return_status := FND_API.G_RET_STS_ERROR;
2803: END IF;
2804:
2805: EXCEPTION

Line 3067: oe_msg_pub.add;

3063: THEN
3064: fnd_message.set_name('ONT','ONT_PO_INL_REQD');
3065: fnd_message.set_token('API_NAME', 'CREATE_CONTACT');
3066: fnd_message.set_token('FIELD_REQD', 'PERSON_FIRST_NAME');
3067: oe_msg_pub.add;
3068: x_return_status := FND_API.G_RET_STS_ERROR;
3069:
3070: END IF;
3071:

Line 3089: oe_msg_pub.add;

3085: IF p_contact_record.contact_number IS NULL THEN
3086: fnd_message.set_name('ONT','ONT_PO_INL_REQD');
3087: fnd_message.set_token('API_NAME', 'CREATE_CONTACT');
3088: fnd_message.set_token('FIELD_REQD', 'CONTACT_NUMBER');
3089: oe_msg_pub.add;
3090: x_return_status := FND_API.G_RET_STS_ERROR;
3091: END IF;
3092: END IF;
3093:

Line 3169: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3165: EXCEPTION
3166: WHEN OTHERS THEN
3167: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3168:
3169: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3170: THEN
3171: OE_MSG_PUB.Add_Exc_Msg
3172: ( G_PKG_NAME
3173: , 'Update_Location'

Line 3171: OE_MSG_PUB.Add_Exc_Msg

3167: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3168:
3169: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3170: THEN
3171: OE_MSG_PUB.Add_Exc_Msg
3172: ( G_PKG_NAME
3173: , 'Update_Location'
3174: );
3175: END IF;

Line 3250: OE_MSG_PUB.Add;

3246: oe_debug_pub.add('Unable to retrive the location_id for the site_use_id :'||p_site_use_id||'and site_usage_code :'||p_site_usage_code);
3247: END IF;
3248: FND_MESSAGE.set_name('ONT','OE_INVALID_ATTRIBUTE');
3249: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','SITE_USE_ID');
3250: OE_MSG_PUB.Add;
3251: return FND_API.G_MISS_NUM;
3252: END Get_Location_id;
3253:
3254:

Line 3332: oe_msg_pub.transfer_msg_stack;

3328:
3329: END IF;
3330:
3331: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3332: oe_msg_pub.transfer_msg_stack;
3333: RETURN;
3334: END IF;
3335:
3336:

Line 3358: oe_msg_pub.transfer_msg_stack;

3354:
3355: END IF;
3356:
3357: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3358: oe_msg_pub.transfer_msg_stack;
3359: RETURN;
3360: END IF;
3361:
3362: IF p_customer_rec.phone_number IS NOT NULL Then

Line 3379: oe_msg_pub.transfer_msg_stack;

3375: );
3376: END IF;
3377:
3378: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3379: oe_msg_pub.transfer_msg_stack;
3380: RETURN;
3381: END IF;
3382:
3383: IF p_customer_rec.customer_number IS NOT NULL

Line 3403: oe_msg_pub.transfer_msg_stack;

3399: END IF;
3400:
3401:
3402: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3403: oe_msg_pub.transfer_msg_stack;
3404: RETURN;
3405: END IF;
3406:
3407: IF l_debug_level > 0 THEN

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

3465: , p_site_usage_id => l_site_use_id
3466: , x_contact_id => x_contact_id
3467: );
3468: IF x_contact_id = FND_API.G_MISS_NUM THEN
3469: oe_msg_pub.delete_msg(oe_msg_pub.g_msg_count);
3470: ELSE
3471: IF p_usage_code = 'SOLD_TO' THEN
3472: x_sold_to_contact_id := x_contact_id;
3473: ELSIF p_usage_code = 'SHIP_TO' THEN

Line 3500: oe_msg_pub.transfer_msg_stack;

3496: oe_debug_pub.add('Update_Location :x_msg_data'||x_msg_data);
3497: END IF;
3498:
3499: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3500: oe_msg_pub.transfer_msg_stack;
3501: RETURN;
3502: END IF;
3503:
3504:

Line 3609: oe_msg_pub.transfer_msg_stack;

3605:
3606: END IF;
3607:
3608: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3609: oe_msg_pub.transfer_msg_stack;
3610: RETURN;
3611: END IF;
3612:
3613: IF p_usage_code = 'SOLD_TO' THEN

Line 3637: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3633: WHEN OTHERS THEN
3634:
3635: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3636:
3637: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3638: THEN
3639: OE_MSG_PUB.Add_Exc_Msg
3640: ( G_PKG_NAME
3641: , 'Create_Contact'

Line 3639: OE_MSG_PUB.Add_Exc_Msg

3635: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3636:
3637: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3638: THEN
3639: OE_MSG_PUB.Add_Exc_Msg
3640: ( G_PKG_NAME
3641: , 'Create_Contact'
3642: );
3643: END IF;

Line 3913: OE_MSG_PUB.Add;

3909: Exception
3910: WHEN OTHERS THEN
3911: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3912: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CONTACT_ID');
3913: OE_MSG_PUB.Add;
3914: x_return_status := FND_API.G_RET_STS_ERROR;
3915: End;
3916:
3917: l_party_rec.party_id := l_party_id;

Line 3938: oe_msg_pub.transfer_msg_stack;

3934:
3935:
3936:
3937: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3938: oe_msg_pub.transfer_msg_stack;
3939: RETURN;
3940: END IF;
3941:
3942:

Line 3964: oe_msg_pub.transfer_msg_stack;

3960:
3961: END IF;
3962:
3963: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3964: oe_msg_pub.transfer_msg_stack;
3965: RETURN;
3966: END IF;
3967:
3968: IF p_contact_rec.phone_number IS NOT NULL Then

Line 3985: oe_msg_pub.transfer_msg_stack;

3981: );
3982: END IF;
3983:
3984: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3985: oe_msg_pub.transfer_msg_stack;
3986: RETURN;
3987: END IF;
3988:
3989:

Line 4002: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3998: EXCEPTION
3999: WHEN OTHERS THEN
4000: x_return_status := FND_API.G_RET_STS_ERROR;
4001:
4002: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4003: THEN
4004: OE_MSG_PUB.Add_Exc_Msg
4005: ( G_PKG_NAME
4006: , 'Update_Contact'

Line 4004: OE_MSG_PUB.Add_Exc_Msg

4000: x_return_status := FND_API.G_RET_STS_ERROR;
4001:
4002: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4003: THEN
4004: OE_MSG_PUB.Add_Exc_Msg
4005: ( G_PKG_NAME
4006: , 'Update_Contact'
4007: );
4008: END IF;