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.

[Home] [Help]

APPS.ASO_PUBLISH_MISC_INT dependencies on FND_API

Line 54: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

50:
51:
52: PROCEDURE NotifyUserForRegistration(
53: p_api_version IN NUMBER,
54: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
55: p_quote_id IN NUMBER,
56: p_Send_Name IN Varchar2,
57: p_Store_Name IN Varchar2,
58: p_Store_Website IN Varchar2,

Line 142: x_return_status := FND_API.g_ret_sts_success;

138: IF l_debug = 'Y' THEN
139: ASO_QUOTE_UTIL_PVT.Debug('BEGIN');
140: END IF;
141:
142: x_return_status := FND_API.g_ret_sts_success;
143:
144: -- check istore lookup to find message name for quoting
145: FOR c_wf_notifications In c_istore_lookup(l_notifName) LOOP
146: g_ItemType := 'IBEALERT';

Line 222: if( x_return_status= FND_API.G_RET_STS_ERROR ) then

218: IF l_debug = 'Y' THEN
219: ASO_QUOTE_UTIL_PVT.Debug('Message Name: '||l_MessageName||' Enabled: '||l_msgEnabled);
220: END IF;
221:
222: if( x_return_status= FND_API.G_RET_STS_ERROR ) then
223: raise FND_API.G_EXC_ERROR;
224: elsif( x_return_status= FND_API.G_RET_STS_UNEXP_ERROR ) then
225: raise FND_API.G_EXC_UNEXPECTED_ERROR;
226: end if;

Line 223: raise FND_API.G_EXC_ERROR;

219: ASO_QUOTE_UTIL_PVT.Debug('Message Name: '||l_MessageName||' Enabled: '||l_msgEnabled);
220: END IF;
221:
222: if( x_return_status= FND_API.G_RET_STS_ERROR ) then
223: raise FND_API.G_EXC_ERROR;
224: elsif( x_return_status= FND_API.G_RET_STS_UNEXP_ERROR ) then
225: raise FND_API.G_EXC_UNEXPECTED_ERROR;
226: end if;
227:

Line 224: elsif( x_return_status= FND_API.G_RET_STS_UNEXP_ERROR ) then

220: END IF;
221:
222: if( x_return_status= FND_API.G_RET_STS_ERROR ) then
223: raise FND_API.G_EXC_ERROR;
224: elsif( x_return_status= FND_API.G_RET_STS_UNEXP_ERROR ) then
225: raise FND_API.G_EXC_UNEXPECTED_ERROR;
226: end if;
227:
228: -- bug 5221658, setting the notification preference and e-mail so the

Line 225: raise FND_API.G_EXC_UNEXPECTED_ERROR;

221:
222: if( x_return_status= FND_API.G_RET_STS_ERROR ) then
223: raise FND_API.G_EXC_ERROR;
224: elsif( x_return_status= FND_API.G_RET_STS_UNEXP_ERROR ) then
225: raise FND_API.G_EXC_UNEXPECTED_ERROR;
226: end if;
227:
228: -- bug 5221658, setting the notification preference and e-mail so the
229: -- the new fnd user created gets the notification by e-mail

Line 410: x_return_status := FND_API.g_ret_sts_error;

406:
407: Exception
408:
409: When OTHERS Then
410: x_return_status := FND_API.g_ret_sts_error;
411: x_msg_count := 0;
412:
413: wf_core.context('ASO_IBE_INT', 'NotifyUserForRegistration', p_send_name);
414: raise;

Line 431: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

427:
428:
429: PROCEDURE NotifyForQuotePublish(
430: p_api_version IN NUMBER,
431: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
432: p_quote_id IN NUMBER,
433: p_Send_Name IN Varchar2,
434: p_Comments IN Varchar2,
435: p_Store_Name IN Varchar2,

Line 527: x_return_status := FND_API.g_ret_sts_success;

523: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
524: ASO_QUOTE_UTIL_PVT.Debug('BEGIN');
525: END IF;
526:
527: x_return_status := FND_API.g_ret_sts_success;
528:
529:
530: FOR c_quote_rec In c_quote_header(p_quote_id) LOOP
531: l_quoteSourceSatusId := c_quote_rec.quote_status_id;

Line 543: p_init_msg_list => FND_API.G_FALSE,

539: ASO_QUOTE_UTIL_PVT.Debug('SOURCE Status done');
540: END IF;
541:
542: ASO_VALIDATE_PVT.Validate_Status_Transition(
543: p_init_msg_list => FND_API.G_FALSE,
544: p_source_status_id => l_quoteSourceSatusId,
545: p_dest_status_id => l_quoteDestStatusId,
546: x_return_status => x_return_status,
547: x_msg_count => x_msg_count,

Line 554: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

550: IF l_debug = 'Y' THEN
551: ASO_QUOTE_UTIL_PVT.Debug('Calling Validate_Status_Transition done ' || x_return_status );
552: END IF;
553:
554: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
555: l_notifName := 'ASOQOTPUBLISHEXEC';
556: ELSE
557: l_notifName := 'ASOQOTPUBLISHUNEXEC';
558: FND_MSG_PUB.initialize;

Line 562: x_return_status := FND_API.g_ret_sts_success;

558: FND_MSG_PUB.initialize;
559: END IF;
560:
561: -- reset return status code
562: x_return_status := FND_API.g_ret_sts_success;
563:
564: -- check istore lookup to find message name for quoting
565: FOR c_wf_notifications In c_istore_lookup(l_notifName) LOOP
566: g_ItemType := 'IBEALERT';

Line 653: if( x_return_status= FND_API.G_RET_STS_ERROR ) then

649: IF l_debug = 'Y' THEN
650: ASO_QUOTE_UTIL_PVT.Debug('Message Name: '||l_MessageName||' Enabled: '||l_msgEnabled);
651: END IF;
652:
653: if( x_return_status= FND_API.G_RET_STS_ERROR ) then
654: raise FND_API.G_EXC_ERROR;
655: elsif( x_return_status= FND_API.G_RET_STS_UNEXP_ERROR ) then
656: raise FND_API.G_EXC_UNEXPECTED_ERROR;
657: end if;

Line 654: raise FND_API.G_EXC_ERROR;

650: ASO_QUOTE_UTIL_PVT.Debug('Message Name: '||l_MessageName||' Enabled: '||l_msgEnabled);
651: END IF;
652:
653: if( x_return_status= FND_API.G_RET_STS_ERROR ) then
654: raise FND_API.G_EXC_ERROR;
655: elsif( x_return_status= FND_API.G_RET_STS_UNEXP_ERROR ) then
656: raise FND_API.G_EXC_UNEXPECTED_ERROR;
657: end if;
658:

Line 655: elsif( x_return_status= FND_API.G_RET_STS_UNEXP_ERROR ) then

651: END IF;
652:
653: if( x_return_status= FND_API.G_RET_STS_ERROR ) then
654: raise FND_API.G_EXC_ERROR;
655: elsif( x_return_status= FND_API.G_RET_STS_UNEXP_ERROR ) then
656: raise FND_API.G_EXC_UNEXPECTED_ERROR;
657: end if;
658:
659: If l_msgEnabled = 'Y' Then

Line 656: raise FND_API.G_EXC_UNEXPECTED_ERROR;

652:
653: if( x_return_status= FND_API.G_RET_STS_ERROR ) then
654: raise FND_API.G_EXC_ERROR;
655: elsif( x_return_status= FND_API.G_RET_STS_UNEXP_ERROR ) then
656: raise FND_API.G_EXC_UNEXPECTED_ERROR;
657: end if;
658:
659: If l_msgEnabled = 'Y' Then
660: -- bug 2107290 # code Start

Line 925: x_return_status := FND_API.g_ret_sts_error;

921: IF l_debug = 'Y' THEN
922: ASO_QUOTE_UTIL_PVT.Debug('Error in NotifiyForQuotePublish');
923: END IF;
924:
925: x_return_status := FND_API.g_ret_sts_error;
926: x_msg_count := 0;
927:
928: wf_core.context('ASO_IBE_INT', 'NotifyForQuotePublish', p_send_name);
929: raise;

Line 1168: P_Init_Msg_List VARCHAR2(1) := FND_API.G_TRUE;

1164: ) IS
1165:
1166:
1167: P_Api_Version_Number NUMBER := 1.0;
1168: P_Init_Msg_List VARCHAR2(1) := FND_API.G_TRUE;
1169: P_Commit VARCHAR2(1) := FND_API.G_FALSE;
1170: P_Validation_Level NUMBER := FND_API.G_VALID_LEVEL_FULL;
1171:
1172: P_Control_Rec ASO_QUOTE_PUB.Control_Rec_Type

Line 1169: P_Commit VARCHAR2(1) := FND_API.G_FALSE;

1165:
1166:
1167: P_Api_Version_Number NUMBER := 1.0;
1168: P_Init_Msg_List VARCHAR2(1) := FND_API.G_TRUE;
1169: P_Commit VARCHAR2(1) := FND_API.G_FALSE;
1170: P_Validation_Level NUMBER := FND_API.G_VALID_LEVEL_FULL;
1171:
1172: P_Control_Rec ASO_QUOTE_PUB.Control_Rec_Type
1173: := ASO_QUOTE_PUB.G_Miss_Control_Rec;

Line 1170: P_Validation_Level NUMBER := FND_API.G_VALID_LEVEL_FULL;

1166:
1167: P_Api_Version_Number NUMBER := 1.0;
1168: P_Init_Msg_List VARCHAR2(1) := FND_API.G_TRUE;
1169: P_Commit VARCHAR2(1) := FND_API.G_FALSE;
1170: P_Validation_Level NUMBER := FND_API.G_VALID_LEVEL_FULL;
1171:
1172: P_Control_Rec ASO_QUOTE_PUB.Control_Rec_Type
1173: := ASO_QUOTE_PUB.G_Miss_Control_Rec;
1174:

Line 1325: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

1321:
1322: procedure createStoreUser
1323: (
1324: p_api_version_number IN NUMBER,
1325: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
1326: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
1327: p_user_name IN VARCHAR2,
1328: p_user_password IN VARCHAR2,
1329: p_email_address IN VARCHAR2 DEFAULT NULL, /* Add for Bug 7334453 */

Line 1326: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

1322: procedure createStoreUser
1323: (
1324: p_api_version_number IN NUMBER,
1325: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
1326: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
1327: p_user_name IN VARCHAR2,
1328: p_user_password IN VARCHAR2,
1329: p_email_address IN VARCHAR2 DEFAULT NULL, /* Add for Bug 7334453 */
1330: p_email_language IN VARCHAR2,

Line 1395: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

1391:
1392: END IF;
1393:
1394: -- Standard call to check for call compatibility.
1395: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1396: p_api_version_number,
1397: l_api_name,
1398: G_PKG_NAME) THEN
1399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1395: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1396: p_api_version_number,
1397: l_api_name,
1398: G_PKG_NAME) THEN
1399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1400: END IF;
1401:
1402: -- Initialize message list if p_init_msg_list is set to TRUE.
1403: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1403: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1400: END IF;
1401:
1402: -- Initialize message list if p_init_msg_list is set to TRUE.
1403: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1404: FND_MSG_PUB.initialize;
1405: END IF;
1406:
1407: -- Set return status to success

Line 1408: x_return_status := FND_API.G_RET_STS_SUCCESS;

1404: FND_MSG_PUB.initialize;
1405: END IF;
1406:
1407: -- Set return status to success
1408: x_return_status := FND_API.G_RET_STS_SUCCESS;
1409:
1410: --//////////////////////////////////////////////////////////////////////////
1411: -- create user id with supplied password
1412: l_user_id := fnd_user_pkg.CreateUserId (

Line 1463: p_init_msg_list => FND_API.G_FALSE,

1459: end if;
1460:
1461:
1462: hz_person_info_v2pub.update_person_language(
1463: p_init_msg_list => FND_API.G_FALSE,
1464: p_person_language_rec => l_lang_rec1,
1465: p_object_version_number => l_object_version_number,
1466: x_return_status => l_return_status,
1467: x_msg_count => l_msg_count,

Line 1540: p_encoded => FND_API.G_FALSE,

1536:
1537: WHEN others then
1538:
1539: FND_MSG_PUB.count_and_get(
1540: p_encoded => FND_API.G_FALSE,
1541: p_count => x_msg_count,
1542: p_data => x_msg_data);
1543:
1544: if (l_debug = 'Y') then

Line 1559: WHEN fnd_api.g_exc_error

1555:
1556: END IF;
1557:
1558: EXCEPTION
1559: WHEN fnd_api.g_exc_error
1560: THEN
1561: IF l_debug = 'Y' THEN
1562: ASO_QUOTE_UTIL_PVT.Debug ('Exception FND_API.G_EXC_ERROR in createStoreUser');
1563: END IF;

Line 1562: ASO_QUOTE_UTIL_PVT.Debug ('Exception FND_API.G_EXC_ERROR in createStoreUser');

1558: EXCEPTION
1559: WHEN fnd_api.g_exc_error
1560: THEN
1561: IF l_debug = 'Y' THEN
1562: ASO_QUOTE_UTIL_PVT.Debug ('Exception FND_API.G_EXC_ERROR in createStoreUser');
1563: END IF;
1564: aso_utility_pvt.handle_exceptions (
1565: p_api_name => l_api_name,
1566: p_pkg_name => g_pkg_name,

Line 1579: WHEN fnd_api.g_exc_unexpected_error

1575: IF l_debug = 'Y' THEN
1576: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
1577: END IF;
1578:
1579: WHEN fnd_api.g_exc_unexpected_error
1580: THEN
1581: IF l_debug = 'Y' THEN
1582: ASO_QUOTE_UTIL_PVT.Debug ('Exception FND_API.G_EXC_UNEXPECTED_ERROR in createStoreUser ');
1583: END IF;

Line 1582: ASO_QUOTE_UTIL_PVT.Debug ('Exception FND_API.G_EXC_UNEXPECTED_ERROR in createStoreUser ');

1578:
1579: WHEN fnd_api.g_exc_unexpected_error
1580: THEN
1581: IF l_debug = 'Y' THEN
1582: ASO_QUOTE_UTIL_PVT.Debug ('Exception FND_API.G_EXC_UNEXPECTED_ERROR in createStoreUser ');
1583: END IF;
1584: aso_utility_pvt.handle_exceptions (
1585: p_api_name => l_api_name,
1586: p_pkg_name => g_pkg_name,

Line 1636: x_return_status := Fnd_Api.g_ret_sts_success;

1632: IF l_debug = 'Y' THEN
1633: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
1634: END IF;
1635:
1636: x_return_status := Fnd_Api.g_ret_sts_success;
1637:
1638: IF l_debug = 'Y' THEN
1639: ASO_QUOTE_UTIL_PVT.Debug('Calling FND_USER_PKG.TestUserName');
1640: ASO_QUOTE_UTIL_PVT.Debug('p_user_name '||p_user_name);

Line 1657: x_return_status := Fnd_Api.G_RET_STS_ERROR;

1653:
1654: EXCEPTION
1655:
1656: WHEN OTHERS THEN
1657: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1658: Aso_Utility_Pvt.HANDLE_EXCEPTIONS(
1659: P_API_NAME => l_api_name
1660: ,P_PKG_NAME => 'ASO_PUBLISH_MISC_INT'
1661: ,P_EXCEPTION_LEVEL => Aso_Utility_Pvt.G_EXC_OTHERS