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.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 393: x_return_status := FND_API.g_ret_sts_error;

389:
390: Exception
391:
392: When OTHERS Then
393: x_return_status := FND_API.g_ret_sts_error;
394: x_msg_count := 0;
395:
396: wf_core.context('ASO_IBE_INT', 'NotifyUserForRegistration', p_send_name);
397: raise;

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

410:
411:
412: PROCEDURE NotifyForQuotePublish(
413: p_api_version IN NUMBER,
414: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
415: p_quote_id IN NUMBER,
416: p_Send_Name IN Varchar2,
417: p_Comments IN Varchar2,
418: p_Store_Name IN Varchar2,

Line 510: x_return_status := FND_API.g_ret_sts_success;

506: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
507: ASO_QUOTE_UTIL_PVT.Debug('BEGIN');
508: END IF;
509:
510: x_return_status := FND_API.g_ret_sts_success;
511:
512:
513: FOR c_quote_rec In c_quote_header(p_quote_id) LOOP
514: l_quoteSourceSatusId := c_quote_rec.quote_status_id;

Line 526: p_init_msg_list => FND_API.G_FALSE,

522: ASO_QUOTE_UTIL_PVT.Debug('SOURCE Status done');
523: END IF;
524:
525: ASO_VALIDATE_PVT.Validate_Status_Transition(
526: p_init_msg_list => FND_API.G_FALSE,
527: p_source_status_id => l_quoteSourceSatusId,
528: p_dest_status_id => l_quoteDestStatusId,
529: x_return_status => x_return_status,
530: x_msg_count => x_msg_count,

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

533: IF l_debug = 'Y' THEN
534: ASO_QUOTE_UTIL_PVT.Debug('Calling Validate_Status_Transition done ' || x_return_status );
535: END IF;
536:
537: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
538: l_notifName := 'ASOQOTPUBLISHEXEC';
539: ELSE
540: l_notifName := 'ASOQOTPUBLISHUNEXEC';
541: FND_MSG_PUB.initialize;

Line 545: x_return_status := FND_API.g_ret_sts_success;

541: FND_MSG_PUB.initialize;
542: END IF;
543:
544: -- reset return status code
545: x_return_status := FND_API.g_ret_sts_success;
546:
547: -- check istore lookup to find message name for quoting
548: FOR c_wf_notifications In c_istore_lookup(l_notifName) LOOP
549: g_ItemType := 'IBEALERT';

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

632: IF l_debug = 'Y' THEN
633: ASO_QUOTE_UTIL_PVT.Debug('Message Name: '||l_MessageName||' Enabled: '||l_msgEnabled);
634: END IF;
635:
636: if( x_return_status= FND_API.G_RET_STS_ERROR ) then
637: raise FND_API.G_EXC_ERROR;
638: elsif( x_return_status= FND_API.G_RET_STS_UNEXP_ERROR ) then
639: raise FND_API.G_EXC_UNEXPECTED_ERROR;
640: end if;

Line 637: raise FND_API.G_EXC_ERROR;

633: ASO_QUOTE_UTIL_PVT.Debug('Message Name: '||l_MessageName||' Enabled: '||l_msgEnabled);
634: END IF;
635:
636: if( x_return_status= FND_API.G_RET_STS_ERROR ) then
637: raise FND_API.G_EXC_ERROR;
638: elsif( x_return_status= FND_API.G_RET_STS_UNEXP_ERROR ) then
639: raise FND_API.G_EXC_UNEXPECTED_ERROR;
640: end if;
641:

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

634: END IF;
635:
636: if( x_return_status= FND_API.G_RET_STS_ERROR ) then
637: raise FND_API.G_EXC_ERROR;
638: elsif( x_return_status= FND_API.G_RET_STS_UNEXP_ERROR ) then
639: raise FND_API.G_EXC_UNEXPECTED_ERROR;
640: end if;
641:
642: If l_msgEnabled = 'Y' Then

Line 639: raise FND_API.G_EXC_UNEXPECTED_ERROR;

635:
636: if( x_return_status= FND_API.G_RET_STS_ERROR ) then
637: raise FND_API.G_EXC_ERROR;
638: elsif( x_return_status= FND_API.G_RET_STS_UNEXP_ERROR ) then
639: raise FND_API.G_EXC_UNEXPECTED_ERROR;
640: end if;
641:
642: If l_msgEnabled = 'Y' Then
643: -- bug 2107290 # code Start

Line 894: x_return_status := FND_API.g_ret_sts_error;

890: IF l_debug = 'Y' THEN
891: ASO_QUOTE_UTIL_PVT.Debug('Error in NotifiyForQuotePublish');
892: END IF;
893:
894: x_return_status := FND_API.g_ret_sts_error;
895: x_msg_count := 0;
896:
897: wf_core.context('ASO_IBE_INT', 'NotifyForQuotePublish', p_send_name);
898: raise;

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

1133: ) IS
1134:
1135:
1136: P_Api_Version_Number NUMBER := 1.0;
1137: P_Init_Msg_List VARCHAR2(1) := FND_API.G_TRUE;
1138: P_Commit VARCHAR2(1) := FND_API.G_FALSE;
1139: P_Validation_Level NUMBER := FND_API.G_VALID_LEVEL_FULL;
1140:
1141: P_Control_Rec ASO_QUOTE_PUB.Control_Rec_Type

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

1134:
1135:
1136: P_Api_Version_Number NUMBER := 1.0;
1137: P_Init_Msg_List VARCHAR2(1) := FND_API.G_TRUE;
1138: P_Commit VARCHAR2(1) := FND_API.G_FALSE;
1139: P_Validation_Level NUMBER := FND_API.G_VALID_LEVEL_FULL;
1140:
1141: P_Control_Rec ASO_QUOTE_PUB.Control_Rec_Type
1142: := ASO_QUOTE_PUB.G_Miss_Control_Rec;

Line 1139: P_Validation_Level NUMBER := FND_API.G_VALID_LEVEL_FULL;

1135:
1136: P_Api_Version_Number NUMBER := 1.0;
1137: P_Init_Msg_List VARCHAR2(1) := FND_API.G_TRUE;
1138: P_Commit VARCHAR2(1) := FND_API.G_FALSE;
1139: P_Validation_Level NUMBER := FND_API.G_VALID_LEVEL_FULL;
1140:
1141: P_Control_Rec ASO_QUOTE_PUB.Control_Rec_Type
1142: := ASO_QUOTE_PUB.G_Miss_Control_Rec;
1143:

Line 1294: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

1290:
1291: procedure createStoreUser
1292: (
1293: p_api_version_number IN NUMBER,
1294: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
1295: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
1296: p_user_name IN VARCHAR2,
1297: p_user_password IN VARCHAR2,
1298: p_email_address IN VARCHAR2 DEFAULT NULL, /* Add for Bug 7334453 */

Line 1295: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

1291: procedure createStoreUser
1292: (
1293: p_api_version_number IN NUMBER,
1294: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
1295: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
1296: p_user_name IN VARCHAR2,
1297: p_user_password IN VARCHAR2,
1298: p_email_address IN VARCHAR2 DEFAULT NULL, /* Add for Bug 7334453 */
1299: p_email_language IN VARCHAR2,

Line 1364: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

1360:
1361: END IF;
1362:
1363: -- Standard call to check for call compatibility.
1364: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1365: p_api_version_number,
1366: l_api_name,
1367: G_PKG_NAME) THEN
1368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1364: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1365: p_api_version_number,
1366: l_api_name,
1367: G_PKG_NAME) THEN
1368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1369: END IF;
1370:
1371: -- Initialize message list if p_init_msg_list is set to TRUE.
1372: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1372: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1369: END IF;
1370:
1371: -- Initialize message list if p_init_msg_list is set to TRUE.
1372: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1373: FND_MSG_PUB.initialize;
1374: END IF;
1375:
1376: -- Set return status to success

Line 1377: x_return_status := FND_API.G_RET_STS_SUCCESS;

1373: FND_MSG_PUB.initialize;
1374: END IF;
1375:
1376: -- Set return status to success
1377: x_return_status := FND_API.G_RET_STS_SUCCESS;
1378:
1379: --//////////////////////////////////////////////////////////////////////////
1380: -- create user id with supplied password
1381: l_user_id := fnd_user_pkg.CreateUserId (

Line 1432: p_init_msg_list => FND_API.G_FALSE,

1428: end if;
1429:
1430:
1431: hz_person_info_v2pub.update_person_language(
1432: p_init_msg_list => FND_API.G_FALSE,
1433: p_person_language_rec => l_lang_rec1,
1434: p_object_version_number => l_object_version_number,
1435: x_return_status => l_return_status,
1436: x_msg_count => l_msg_count,

Line 1509: p_encoded => FND_API.G_FALSE,

1505:
1506: WHEN others then
1507:
1508: FND_MSG_PUB.count_and_get(
1509: p_encoded => FND_API.G_FALSE,
1510: p_count => x_msg_count,
1511: p_data => x_msg_data);
1512:
1513: if (l_debug = 'Y') then

Line 1528: WHEN fnd_api.g_exc_error

1524:
1525: END IF;
1526:
1527: EXCEPTION
1528: WHEN fnd_api.g_exc_error
1529: THEN
1530: IF l_debug = 'Y' THEN
1531: ASO_QUOTE_UTIL_PVT.Debug ('Exception FND_API.G_EXC_ERROR in createStoreUser');
1532: END IF;

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

1527: EXCEPTION
1528: WHEN fnd_api.g_exc_error
1529: THEN
1530: IF l_debug = 'Y' THEN
1531: ASO_QUOTE_UTIL_PVT.Debug ('Exception FND_API.G_EXC_ERROR in createStoreUser');
1532: END IF;
1533: aso_utility_pvt.handle_exceptions (
1534: p_api_name => l_api_name,
1535: p_pkg_name => g_pkg_name,

Line 1548: WHEN fnd_api.g_exc_unexpected_error

1544: IF l_debug = 'Y' THEN
1545: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
1546: END IF;
1547:
1548: WHEN fnd_api.g_exc_unexpected_error
1549: THEN
1550: IF l_debug = 'Y' THEN
1551: ASO_QUOTE_UTIL_PVT.Debug ('Exception FND_API.G_EXC_UNEXPECTED_ERROR in createStoreUser ');
1552: END IF;

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

1547:
1548: WHEN fnd_api.g_exc_unexpected_error
1549: THEN
1550: IF l_debug = 'Y' THEN
1551: ASO_QUOTE_UTIL_PVT.Debug ('Exception FND_API.G_EXC_UNEXPECTED_ERROR in createStoreUser ');
1552: END IF;
1553: aso_utility_pvt.handle_exceptions (
1554: p_api_name => l_api_name,
1555: p_pkg_name => g_pkg_name,

Line 1605: x_return_status := Fnd_Api.g_ret_sts_success;

1601: IF l_debug = 'Y' THEN
1602: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
1603: END IF;
1604:
1605: x_return_status := Fnd_Api.g_ret_sts_success;
1606:
1607: IF l_debug = 'Y' THEN
1608: ASO_QUOTE_UTIL_PVT.Debug('Calling FND_USER_PKG.TestUserName');
1609: ASO_QUOTE_UTIL_PVT.Debug('p_user_name '||p_user_name);

Line 1626: x_return_status := Fnd_Api.G_RET_STS_ERROR;

1622:
1623: EXCEPTION
1624:
1625: WHEN OTHERS THEN
1626: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1627: Aso_Utility_Pvt.HANDLE_EXCEPTIONS(
1628: P_API_NAME => l_api_name
1629: ,P_PKG_NAME => 'ASO_PUBLISH_MISC_INT'
1630: ,P_EXCEPTION_LEVEL => Aso_Utility_Pvt.G_EXC_OTHERS