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.IBE_WORKFLOW_PVT dependencies on FND_API

Line 128: l_true VARCHAR2(1) := FND_API.G_TRUE;

124: | 07-MAY-2012 scnagara 13767382 procedure get_sales_assist_rsn_meaning - changed to use aso_lookups view
125: | 30-AUG-2012 avitiwar 12851105 - Istore Registration Page Application Error
126: ==============================================================================================
127: */
128: l_true VARCHAR2(1) := FND_API.G_TRUE;
129: g_ItemType Varchar2(10) := 'IBEALERT';
130: g_processName Varchar2(30) := 'PROCESSMAP';
131:
132:

Line 489: l_is_it_quote VARCHAR2(1) := fnd_api.g_false;

485: from aso_quote_headers_all
486: where quote_header_id = c_quote_header_id;
487:
488: rec_get_cart_type c_get_cart_type%rowtype;
489: l_is_it_quote VARCHAR2(1) := fnd_api.g_false;
490: BEGIN
491:
492: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
493: IBE_UTIL.DEBUG('Identify_cart_quote: Start');

Line 498: l_is_it_quote := FND_API.G_TRUE;

494: IBE_UTIL.DEBUG('Identify_cart_quote:inout quote_header_id: '||p_quote_header_id);
495: END IF;
496: For rec_get_cart_type in c_get_cart_type(p_quote_header_id) LOOP
497: IF (rec_get_cart_type.resource_id is not null) THEN
498: l_is_it_quote := FND_API.G_TRUE;
499: END IF;
500: EXIT when c_get_cart_type%notfound;
501: END LOOP;
502: x_is_it_quote := l_is_it_quote;

Line 510: ( p_quote_recipient_id IN NUMBER := FND_API.G_MISS_NUM

506:
507: END;
508:
509: Procedure create_adhoc_entity
510: ( p_quote_recipient_id IN NUMBER := FND_API.G_MISS_NUM
511: ,p_quote_header_id IN NUMBER := FND_API.G_MISS_NUM
512: ,p_email_address IN VARCHAR2:= FND_API.G_MISS_CHAR
513: ,p_Notification_preference IN VARCHAR2:= FND_API.G_MISS_CHAR
514: ,x_adhoc_role OUT NOCOPY VARCHAR2) is

Line 511: ,p_quote_header_id IN NUMBER := FND_API.G_MISS_NUM

507: END;
508:
509: Procedure create_adhoc_entity
510: ( p_quote_recipient_id IN NUMBER := FND_API.G_MISS_NUM
511: ,p_quote_header_id IN NUMBER := FND_API.G_MISS_NUM
512: ,p_email_address IN VARCHAR2:= FND_API.G_MISS_CHAR
513: ,p_Notification_preference IN VARCHAR2:= FND_API.G_MISS_CHAR
514: ,x_adhoc_role OUT NOCOPY VARCHAR2) is
515:

Line 512: ,p_email_address IN VARCHAR2:= FND_API.G_MISS_CHAR

508:
509: Procedure create_adhoc_entity
510: ( p_quote_recipient_id IN NUMBER := FND_API.G_MISS_NUM
511: ,p_quote_header_id IN NUMBER := FND_API.G_MISS_NUM
512: ,p_email_address IN VARCHAR2:= FND_API.G_MISS_CHAR
513: ,p_Notification_preference IN VARCHAR2:= FND_API.G_MISS_CHAR
514: ,x_adhoc_role OUT NOCOPY VARCHAR2) is
515:
516: l_adhoc_user VARCHAR2(2000);

Line 513: ,p_Notification_preference IN VARCHAR2:= FND_API.G_MISS_CHAR

509: Procedure create_adhoc_entity
510: ( p_quote_recipient_id IN NUMBER := FND_API.G_MISS_NUM
511: ,p_quote_header_id IN NUMBER := FND_API.G_MISS_NUM
512: ,p_email_address IN VARCHAR2:= FND_API.G_MISS_CHAR
513: ,p_Notification_preference IN VARCHAR2:= FND_API.G_MISS_CHAR
514: ,x_adhoc_role OUT NOCOPY VARCHAR2) is
515:
516: l_adhoc_user VARCHAR2(2000);
517: l_adhoc_user_display VARCHAR2(2000);

Line 581: ,p_access_level IN VARCHAR2 :=FND_API.G_MISS_CHAR

577:
578: procedure set_item_attributes
579: ( p_item_key IN VARCHAR2
580: ,p_message_name IN VARCHAR2
581: ,p_access_level IN VARCHAR2 :=FND_API.G_MISS_CHAR
582: ,p_old_access_level IN VARCHAR2 :=FND_API.G_MISS_CHAR
583: ,p_recipient_number IN VARCHAR2 :=FND_API.G_MISS_CHAR
584: ,p_first_name IN VARCHAR2
585: ,p_last_name IN VARCHAR2

Line 582: ,p_old_access_level IN VARCHAR2 :=FND_API.G_MISS_CHAR

578: procedure set_item_attributes
579: ( p_item_key IN VARCHAR2
580: ,p_message_name IN VARCHAR2
581: ,p_access_level IN VARCHAR2 :=FND_API.G_MISS_CHAR
582: ,p_old_access_level IN VARCHAR2 :=FND_API.G_MISS_CHAR
583: ,p_recipient_number IN VARCHAR2 :=FND_API.G_MISS_CHAR
584: ,p_first_name IN VARCHAR2
585: ,p_last_name IN VARCHAR2
586: ,p_url IN VARCHAR2 :=FND_API.G_MISS_CHAR

Line 583: ,p_recipient_number IN VARCHAR2 :=FND_API.G_MISS_CHAR

579: ( p_item_key IN VARCHAR2
580: ,p_message_name IN VARCHAR2
581: ,p_access_level IN VARCHAR2 :=FND_API.G_MISS_CHAR
582: ,p_old_access_level IN VARCHAR2 :=FND_API.G_MISS_CHAR
583: ,p_recipient_number IN VARCHAR2 :=FND_API.G_MISS_CHAR
584: ,p_first_name IN VARCHAR2
585: ,p_last_name IN VARCHAR2
586: ,p_url IN VARCHAR2 :=FND_API.G_MISS_CHAR
587: ,p_minisite_id IN VARCHAR2

Line 586: ,p_url IN VARCHAR2 :=FND_API.G_MISS_CHAR

582: ,p_old_access_level IN VARCHAR2 :=FND_API.G_MISS_CHAR
583: ,p_recipient_number IN VARCHAR2 :=FND_API.G_MISS_CHAR
584: ,p_first_name IN VARCHAR2
585: ,p_last_name IN VARCHAR2
586: ,p_url IN VARCHAR2 :=FND_API.G_MISS_CHAR
587: ,p_minisite_id IN VARCHAR2
588: ,p_cart_name IN VARCHAR2
589: ,p_adhoc_role IN VARCHAR2 :=FND_API.G_MISS_CHAR
590: ,p_context_msg IN VARCHAR2 :=FND_API.G_MISS_CHAR

Line 589: ,p_adhoc_role IN VARCHAR2 :=FND_API.G_MISS_CHAR

585: ,p_last_name IN VARCHAR2
586: ,p_url IN VARCHAR2 :=FND_API.G_MISS_CHAR
587: ,p_minisite_id IN VARCHAR2
588: ,p_cart_name IN VARCHAR2
589: ,p_adhoc_role IN VARCHAR2 :=FND_API.G_MISS_CHAR
590: ,p_context_msg IN VARCHAR2 :=FND_API.G_MISS_CHAR
591: ,p_notes IN VARCHAR2 :=FND_API.G_MISS_CHAR
592: ,p_notif_context IN VARCHAR2 ) is
593:

Line 590: ,p_context_msg IN VARCHAR2 :=FND_API.G_MISS_CHAR

586: ,p_url IN VARCHAR2 :=FND_API.G_MISS_CHAR
587: ,p_minisite_id IN VARCHAR2
588: ,p_cart_name IN VARCHAR2
589: ,p_adhoc_role IN VARCHAR2 :=FND_API.G_MISS_CHAR
590: ,p_context_msg IN VARCHAR2 :=FND_API.G_MISS_CHAR
591: ,p_notes IN VARCHAR2 :=FND_API.G_MISS_CHAR
592: ,p_notif_context IN VARCHAR2 ) is
593:
594: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';

Line 591: ,p_notes IN VARCHAR2 :=FND_API.G_MISS_CHAR

587: ,p_minisite_id IN VARCHAR2
588: ,p_cart_name IN VARCHAR2
589: ,p_adhoc_role IN VARCHAR2 :=FND_API.G_MISS_CHAR
590: ,p_context_msg IN VARCHAR2 :=FND_API.G_MISS_CHAR
591: ,p_notes IN VARCHAR2 :=FND_API.G_MISS_CHAR
592: ,p_notif_context IN VARCHAR2 ) is
593:
594: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
595: l_temp_retrieve_str Varchar2(2000);

Line 661: (p_first_name <> FND_API.G_MISS_CHAR)) THEN

657: IBE_UTIL.DEBUG('Set_item_attributes:Done setItemAttribute for CARTNAME');
658: END IF;
659:
660: IF((p_first_name is not null) and
661: (p_first_name <> FND_API.G_MISS_CHAR)) THEN
662: wf_engine.SetItemAttrText(
663: itemtype => g_ItemType,
664: itemkey => p_item_key,
665: aname => 'FIRSTNAME',

Line 673: (p_first_name <> FND_API.G_MISS_CHAR)) THEN

669: IBE_UTIL.DEBUG('Set_item_attributes:Done setItemAttribute for FIRSTNAME');
670: END IF;
671:
672: IF((p_last_name is not null) and
673: (p_first_name <> FND_API.G_MISS_CHAR)) THEN
674: wf_engine.SetItemAttrText(
675: itemtype => g_ItemType,
676: itemkey => p_item_key,
677: aname => 'LASTNAME',

Line 685: (p_notes <> FND_API.G_MISS_CHAR)) THEN

681: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
682: IBE_UTIL.DEBUG('Set_item_attributes:Done setItemAttribute for LASTNAME');
683: END IF;
684: IF((p_notes is not null) and
685: (p_notes <> FND_API.G_MISS_CHAR)) THEN
686: wf_engine.SetItemAttrText(
687: itemtype => g_ItemType,
688: itemkey => p_item_key,
689: aname => 'SHARECOMMENTS',

Line 833: p_sharee_number IN NUMBER := FND_API.G_MISS_NUM,

829:
830:
831: /*PROCEDURE Get_Name_details(p_party_id IN HZ_PARTIES.PARTY_ID%TYPE,
832: p_user_type IN VARCHAR2,
833: p_sharee_number IN NUMBER := FND_API.G_MISS_NUM,
834: x_contact_first_name OUT NOCOPY HZ_PARTIES.PERSON_FIRST_NAME%TYPE,
835: x_contact_last_name OUT NOCOPY HZ_PARTIES.PERSON_LAST_NAME%TYPE,
836: x_party_id OUT NOCOPY HZ_PARTIES.PARTY_ID%TYPE) IS
837:

Line 871: IF ((p_user_type = FND_API.G_MISS_CHAR)

867: ibe_util.debug('get_name_details:input sharee number: '||p_sharee_number);
868: END IF;
869:
870:
871: IF ((p_user_type = FND_API.G_MISS_CHAR)
872: OR (p_user_type = null)) THEN
873: -- User Type of the owner
874: getUserType(p_party_Id,l_UserType);
875: ELSE

Line 888: IF ((p_party_id is not null) or (p_party_id <> fnd_api.g_miss_num)) THEN

884: x_party_id := rec_party_info.party_id;
885: END LOOP;
886: ELSE
887: x_party_id := p_party_id;
888: IF ((p_party_id is not null) or (p_party_id <> fnd_api.g_miss_num)) THEN
889: FOR rec_get_recepient_name IN c_get_recepient_name(p_party_id )
890: LOOP
891: x_contact_first_name := rec_get_recepient_name.person_first_name;
892: x_contact_last_name := rec_get_recepient_name.person_last_name;

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

975:
976:
977: PROCEDURE NotifyForQuotePublish(
978: p_api_version IN NUMBER,
979: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
980: p_Msite_Id IN NUMBER,
981: p_quote_id IN VARCHAR2,
982: p_Req_Name IN Varchar2,
983: p_Send_Name IN Varchar2,

Line 1030: x_return_status := FND_API.g_ret_sts_success;

1026: Where RESOURCE_ID = c_resource_id;
1027:
1028: BEGIN
1029:
1030: x_return_status := FND_API.g_ret_sts_success;
1031:
1032:
1033: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1034: ibe_util.debug('Check if this notification is enabled.');

Line 1179: x_return_status := FND_API.g_ret_sts_error;

1175: End If;
1176: Exception
1177:
1178: When OTHERS Then
1179: x_return_status := FND_API.g_ret_sts_error;
1180: x_msg_count := 0;
1181:
1182: wf_core.context('ibe_workflow_pvt',
1183: 'NotifyRegistration',

Line 1199: L_quote_flag VARCHAR2(1) := fnd_api.g_true;

1195: ) is
1196: L_api_name CONSTANT VARCHAR2(30) := 'Generate_Approval_Msg';
1197: L_api_version CONSTANT NUMBER := 1.0;
1198:
1199: L_quote_flag VARCHAR2(1) := fnd_api.g_true;
1200: L_tax_flag VARCHAR2(1) := fnd_api.g_true;
1201: BEGIN
1202: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1203: IBE_UTIL.DEBUG(L_api_name||':START: value of document id ='||document_id);

Line 1200: L_tax_flag VARCHAR2(1) := fnd_api.g_true;

1196: L_api_name CONSTANT VARCHAR2(30) := 'Generate_Approval_Msg';
1197: L_api_version CONSTANT NUMBER := 1.0;
1198:
1199: L_quote_flag VARCHAR2(1) := fnd_api.g_true;
1200: L_tax_flag VARCHAR2(1) := fnd_api.g_true;
1201: BEGIN
1202: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1203: IBE_UTIL.DEBUG(L_api_name||':START: value of document id ='||document_id);
1204: END IF;

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

1278: */
1279:
1280: PROCEDURE NotifyRegistration (
1281: p_api_version IN NUMBER,
1282: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1283: p_first_name IN VARCHAR2,
1284: p_last_name IN VARCHAR2,
1285: p_login_name IN VARCHAR2,
1286: p_password IN VARCHAR2,

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

1316:
1317: PROCEDURE NotifyRegistration (
1318:
1319: p_api_version IN NUMBER,
1320: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1321: p_Msite_Id IN NUMBER,
1322: p_first_name IN VARCHAR2,
1323: p_last_name IN VARCHAR2,
1324: p_login_name IN VARCHAR2,

Line 1615: x_return_status := FND_API.g_ret_sts_error;

1611: End If;
1612: End If;
1613: Exception
1614: When OTHERS Then
1615: x_return_status := FND_API.g_ret_sts_error;
1616: x_msg_count := 0;
1617: wf_core.context('ibe_workflow_pvt',
1618: 'NotifyRegistration',
1619: p_login_name

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

1623:
1624: --Bug 2111316
1625: PROCEDURE NotifyForgetLogin(
1626: p_api_version IN NUMBER,
1627: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1628: p_Msite_Id IN NUMBER,
1629: p_first_name IN VARCHAR2,
1630: p_last_name IN VARCHAR2,
1631: p_login_name IN VARCHAR2,

Line 1662: x_return_status := FND_API.g_ret_sts_success;

1658: AND user_name = c_login_name;
1659:
1660: BEGIN
1661:
1662: x_return_status := FND_API.g_ret_sts_success;
1663:
1664:
1665: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1666: ibe_util.debug('Check if this notification is enabled.');

Line 1799: x_return_status := FND_API.g_ret_sts_error;

1795:
1796: EXCEPTION
1797:
1798: WHEN OTHERS THEN
1799: x_return_status := FND_API.g_ret_sts_error;
1800: x_msg_count := 0;
1801: wf_core.context('ibe_workflow_pvt', 'NotifyForgetLogin', p_login_name);
1802: raise;
1803:

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

1809: */
1810:
1811: PROCEDURE NotifyOrderStatus(
1812: p_api_version IN NUMBER,
1813: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1814: p_quote_id IN NUMBER,
1815: p_status IN VARCHAR2,
1816: p_errmsg_count IN NUMBER,
1817: p_errmsg_data IN VARCHAR2,

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

1839: END NotifyOrderStatus;
1840:
1841: PROCEDURE NotifyOrderStatus(
1842: p_api_version IN NUMBER,
1843: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1844: p_msite_id IN NUMBER,
1845: p_quote_id IN NUMBER,
1846: p_status IN VARCHAR2,
1847: p_errmsg_count IN NUMBER,

Line 1909: x_return_status := FND_API.g_ret_sts_success;

1905: SELECT itev.card_number FROM IBY_EXTN_INSTR_DETAILS_V itev
1906: WHERE itev.order_id = trim(to_char(l_order_id)) and instrument_type = 'CREDITCARD';
1907:
1908: BEGIN
1909: x_return_status := FND_API.g_ret_sts_success;
1910: -- Check for WorkFlow Feature Availablity.
1911: /*for rec_minisite_name in c_minisite_name(p_msite_id) loop
1912: l_msite_name := 'Msite_name'||rec_minisite_name.msite_name;
1913: exit when c_minisite_name%notfound;

Line 1988: fnd_msg_pub.Get(l_this,FND_API.G_FALSE,l_temp_str,l_next);

1984: l_this := 1;
1985: l_errmsg_data := '';
1986: WHILE ( l_this <= l_errmsg_count ) LOOP
1987: l_temp_str := null;
1988: fnd_msg_pub.Get(l_this,FND_API.G_FALSE,l_temp_str,l_next);
1989: l_errmsg_data := l_errmsg_data || TAB || TAB ||l_temp_str || NEWLINE;
1990: l_this := l_this + 1;
1991: END LOOP;
1992: END IF;

Line 2088: p_user_type => FND_API.G_MISS_CHAR,

2084: END IF;
2085:
2086: get_name_details(
2087: p_party_id => l_partyId,
2088: p_user_type => FND_API.G_MISS_CHAR,
2089: x_contact_first_name => l_first_name,
2090: x_contact_last_name => l_last_name,
2091: x_party_id => lx_party_id);
2092:

Line 2335: p_user_type => FND_API.G_MISS_CHAR,

2331:
2332: If l_msgEnabled = 'Y' Then
2333: get_name_details(
2334: p_party_id => p_sharee_partyid,
2335: p_user_type => FND_API.G_MISS_CHAR,
2336: x_contact_first_name => l_first_name,
2337: x_contact_last_name => l_last_name,
2338: x_party_id => l_partyid);
2339:

Line 2471: x_return_status := FND_API.g_ret_sts_error;

2467: End if;
2468: End If;
2469: Exception
2470: When OTHERS Then
2471: x_return_status := FND_API.g_ret_sts_error;
2472: x_msg_count := 0;
2473:
2474: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2475: IBE_UTIL.DEBUG('NotifyOrderStatus:Exception block: '||SQLCODE||': '||SQLERRM);

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

2496: *********************************************************/
2497:
2498: PROCEDURE NotifyReturnOrderStatus(
2499: p_api_version IN NUMBER,
2500: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2501: p_party_id IN NUMBER,
2502: p_order_header_id IN NUMBER,
2503: p_errmsg_count IN NUMBER,
2504: p_errmsg_data IN VARCHAR2,

Line 2533: x_return_status := FND_API.g_ret_sts_success;

2529:
2530:
2531:
2532: BEGIN
2533: x_return_status := FND_API.g_ret_sts_success;
2534:
2535:
2536: l_event_type := 'RETURNORDER';
2537:

Line 2547: l_usertype := FND_API.G_MISS_CHAR;

2543:
2544:
2545: l_notifName := 'IBE_RETURNORDERCONF';
2546: -- initialize the user type variable.
2547: l_usertype := FND_API.G_MISS_CHAR;
2548: GetUserType(l_party_id,l_usertype);
2549: l_user_name := 'HZ_PARTY:'||l_party_id;
2550:
2551: -- Call the Get_Name_details to get the party_id of the email recepient.

Line 2703: x_return_status := FND_API.g_ret_sts_error;

2699:
2700:
2701: Exception
2702: When OTHERS Then
2703: x_return_status := FND_API.g_ret_sts_error;
2704: x_msg_count := 0;
2705:
2706: wf_core.context('ibe_workflow_pvt',
2707: 'NotifyReturnOrderStatus',

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

2717: Dependinng on the user type two seperate cursors are used to retrieve contact details of B2C or B2B users*/
2718:
2719: Procedure get_contact_details_for_order(
2720: p_api_version IN NUMBER,
2721: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2722: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
2723: p_order_id IN NUMBER,
2724: x_contact_party_id OUT NOCOPY NUMBER,
2725: x_contact_first_name OUT NOCOPY VARCHAR2,

Line 2722: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

2718:
2719: Procedure get_contact_details_for_order(
2720: p_api_version IN NUMBER,
2721: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2722: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
2723: p_order_id IN NUMBER,
2724: x_contact_party_id OUT NOCOPY NUMBER,
2725: x_contact_first_name OUT NOCOPY VARCHAR2,
2726: x_contact_mid_name OUT NOCOPY VARCHAR2,

Line 2802: IF NOT FND_API.Compatible_API_Call(L_API_VERSION,

2798: -- Standard Start of API savepoint
2799: SAVEPOINT get_contact_details_for_order;
2800: ----DBMS_OUTPUT.PUT('Standard Start of API savepoint');
2801: -- Standard call to check for call compatibility.
2802: IF NOT FND_API.Compatible_API_Call(L_API_VERSION,
2803: p_api_version,
2804: L_API_NAME ,
2805: G_PKG_NAME )
2806: THEN

Line 2807: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2803: p_api_version,
2804: L_API_NAME ,
2805: G_PKG_NAME )
2806: THEN
2807: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2808: END IF;
2809:
2810: -- Initialize message list if p_init_msg_list is set to TRUE.
2811: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 2811: IF FND_API.To_Boolean(p_init_msg_list) THEN

2807: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2808: END IF;
2809:
2810: -- Initialize message list if p_init_msg_list is set to TRUE.
2811: IF FND_API.To_Boolean(p_init_msg_list) THEN
2812: FND_Msg_Pub.initialize;
2813: END IF;
2814:
2815: -- Initialize API return status to success

Line 2816: x_return_status := FND_API.G_RET_STS_SUCCESS;

2812: FND_Msg_Pub.initialize;
2813: END IF;
2814:
2815: -- Initialize API return status to success
2816: x_return_status := FND_API.G_RET_STS_SUCCESS;
2817: --Start of API Body
2818: ----DBMS_OUTPUT.PUT('Start of API Body');
2819: ----DBMS_OUTPUT.PUT('Order id is: '||p_order_id);
2820: FOR rec_b2c_contact in c_b2c_contact(p_order_id) LOOP

Line 2872: IF FND_API.To_Boolean(p_commit) THEN

2868: IBE_UTIL.Debug('x_contact_last_name: '||x_contact_last_name);
2869: END IF;
2870:
2871: -- Standard check of p_commit.
2872: IF FND_API.To_Boolean(p_commit) THEN
2873: COMMIT WORK;
2874: END IF;
2875:
2876: -- Standard call to get message count and if count is 1, get message info.

Line 2877: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

2873: COMMIT WORK;
2874: END IF;
2875:
2876: -- Standard call to get message count and if count is 1, get message info.
2877: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2878: p_count => x_msg_count ,
2879: p_data => x_msg_data);
2880: EXCEPTION
2881: WHEN FND_API.G_EXC_ERROR THEN

Line 2881: WHEN FND_API.G_EXC_ERROR THEN

2877: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2878: p_count => x_msg_count ,
2879: p_data => x_msg_data);
2880: EXCEPTION
2881: WHEN FND_API.G_EXC_ERROR THEN
2882: ROLLBACK TO get_contact_details_for_order;
2883: x_return_status := FND_API.G_RET_STS_ERROR;
2884: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2885: p_count => x_msg_count ,

Line 2883: x_return_status := FND_API.G_RET_STS_ERROR;

2879: p_data => x_msg_data);
2880: EXCEPTION
2881: WHEN FND_API.G_EXC_ERROR THEN
2882: ROLLBACK TO get_contact_details_for_order;
2883: x_return_status := FND_API.G_RET_STS_ERROR;
2884: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2885: p_count => x_msg_count ,
2886: p_data => x_msg_data);
2887: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2884: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

2880: EXCEPTION
2881: WHEN FND_API.G_EXC_ERROR THEN
2882: ROLLBACK TO get_contact_details_for_order;
2883: x_return_status := FND_API.G_RET_STS_ERROR;
2884: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2885: p_count => x_msg_count ,
2886: p_data => x_msg_data);
2887: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2888: ROLLBACK TO get_contact_details_for_order;

Line 2887: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2883: x_return_status := FND_API.G_RET_STS_ERROR;
2884: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2885: p_count => x_msg_count ,
2886: p_data => x_msg_data);
2887: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2888: ROLLBACK TO get_contact_details_for_order;
2889: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2890: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2891: p_count => x_msg_count ,

Line 2889: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2885: p_count => x_msg_count ,
2886: p_data => x_msg_data);
2887: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2888: ROLLBACK TO get_contact_details_for_order;
2889: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2890: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2891: p_count => x_msg_count ,
2892: p_data => x_msg_data);
2893: WHEN OTHERS THEN

Line 2890: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

2886: p_data => x_msg_data);
2887: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2888: ROLLBACK TO get_contact_details_for_order;
2889: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2890: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2891: p_count => x_msg_count ,
2892: p_data => x_msg_data);
2893: WHEN OTHERS THEN
2894: ROLLBACK TO get_contact_details_for_order;

Line 2895: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2891: p_count => x_msg_count ,
2892: p_data => x_msg_data);
2893: WHEN OTHERS THEN
2894: ROLLBACK TO get_contact_details_for_order;
2895: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2896: IF FND_Msg_Pub.Check_Msg_Level( FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
2897: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
2898: L_API_NAME);
2899: END IF;

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

2901: END;
2902:
2903: PROCEDURE Notify_cancel_order(
2904: p_api_version IN NUMBER,
2905: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2906: p_order_id IN NUMBER,
2907: x_return_status OUT NOCOPY VARCHAR2,
2908: x_msg_count OUT NOCOPY NUMBER,
2909: x_msg_data OUT NOCOPY VARCHAR2

Line 2940: x_return_status := FND_API.g_ret_sts_success;

2936:
2937: BEGIN
2938: --ibe_util.enable_debug;
2939: ----DBMS_OUTPUT.PUT('reday to call Notify_cancel_order');
2940: x_return_status := FND_API.g_ret_sts_success;
2941: -- Check for WorkFlow Feature Availablity.
2942: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2943: ibe_util.debug('Check if this notification is enabled.');
2944: END IF;

Line 2955: p_init_msg_list => FND_API.G_TRUE ,

2951: END IF;
2952: ----DBMS_OUTPUT.PUT('Getting the contact party id');
2953: ibe_workflow_pvt.get_contact_details_for_order
2954: (p_api_version => 1.0 ,
2955: p_init_msg_list => FND_API.G_TRUE ,
2956: p_commit => FND_API.G_FALSE ,
2957: p_order_id => p_order_id ,
2958: x_contact_party_id => l_contact_party_id,
2959: x_contact_first_name => l_contact_first_name,

Line 2956: p_commit => FND_API.G_FALSE ,

2952: ----DBMS_OUTPUT.PUT('Getting the contact party id');
2953: ibe_workflow_pvt.get_contact_details_for_order
2954: (p_api_version => 1.0 ,
2955: p_init_msg_list => FND_API.G_TRUE ,
2956: p_commit => FND_API.G_FALSE ,
2957: p_order_id => p_order_id ,
2958: x_contact_party_id => l_contact_party_id,
2959: x_contact_first_name => l_contact_first_name,
2960: x_contact_mid_name => l_contact_mid_name,

Line 2965: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

2961: x_contact_last_name => l_contact_last_name,
2962: x_return_status => x_return_status,
2963: x_msg_count => x_msg_count,
2964: x_msg_data => x_msg_data ) ;
2965: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2966: RAISE FND_API.G_EXC_ERROR;
2967: END IF;
2968:
2969: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 2966: RAISE FND_API.G_EXC_ERROR;

2962: x_return_status => x_return_status,
2963: x_msg_count => x_msg_count,
2964: x_msg_data => x_msg_data ) ;
2965: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2966: RAISE FND_API.G_EXC_ERROR;
2967: END IF;
2968:
2969: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2969: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2965: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2966: RAISE FND_API.G_EXC_ERROR;
2967: END IF;
2968:
2969: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2971: END IF;
2972: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2973: IBE_UTIL.DEBUG('Contact party_id in Notify_Cancel_Order obtained from get_contact_from_order: '||l_contact_party_id);

Line 2970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2966: RAISE FND_API.G_EXC_ERROR;
2967: END IF;
2968:
2969: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2971: END IF;
2972: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2973: IBE_UTIL.DEBUG('Contact party_id in Notify_Cancel_Order obtained from get_contact_from_order: '||l_contact_party_id);
2974: END IF;

Line 3109: x_return_status := FND_API.g_ret_sts_error;

3105: End If;
3106: End If;
3107: Exception
3108: When OTHERS Then
3109: x_return_status := FND_API.g_ret_sts_error;
3110: x_msg_count := 0;
3111: wf_core.context('ibe_workflow_pvt',
3112: 'NotifyOrderStatus',
3113: l_event_type,

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

3123: */
3124:
3125: PROCEDURE NotifyForContractsStatus(
3126: p_api_version IN NUMBER,
3127: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3128: p_quote_id IN NUMBER,
3129: p_contract_id IN NUMBER,
3130: p_contract_status IN NUMBER,
3131: x_return_status OUT NOCOPY VARCHAR2,

Line 3164: x_return_status := FND_API.g_ret_sts_success;

3160:
3161:
3162: BEGIN
3163:
3164: x_return_status := FND_API.g_ret_sts_success;
3165:
3166:
3167: If p_contract_status = 0 then -- Approved
3168:

Line 3435: x_return_status := FND_API.g_ret_sts_error;

3431: End If;
3432: End If;
3433: Exception
3434: When OTHERS Then
3435: x_return_status := FND_API.g_ret_sts_error;
3436: x_msg_count := 0;
3437:
3438: wf_core.context('ibe_workflow_pvt',
3439: 'NotifyForContractsStatus',

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

3451:
3452:
3453: PROCEDURE NotifyForContractsChange(
3454: p_api_version IN NUMBER,
3455: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3456: p_quote_id IN NUMBER,
3457: p_contract_id IN NUMBER,
3458: p_customer_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,
3459: p_salesrep_email_id IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 3458: p_customer_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,

3454: p_api_version IN NUMBER,
3455: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3456: p_quote_id IN NUMBER,
3457: p_contract_id IN NUMBER,
3458: p_customer_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,
3459: p_salesrep_email_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
3460: x_return_status OUT NOCOPY VARCHAR2,
3461: x_msg_count OUT NOCOPY NUMBER,
3462: x_msg_data OUT NOCOPY VARCHAR2

Line 3459: p_salesrep_email_id IN VARCHAR2 := FND_API.G_MISS_CHAR,

3455: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3456: p_quote_id IN NUMBER,
3457: p_contract_id IN NUMBER,
3458: p_customer_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,
3459: p_salesrep_email_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
3460: x_return_status OUT NOCOPY VARCHAR2,
3461: x_msg_count OUT NOCOPY NUMBER,
3462: x_msg_data OUT NOCOPY VARCHAR2
3463: ) IS

Line 3468: IF (p_salesrep_email_id = fnd_api.g_miss_char) then

3464:
3465: Begin
3466:
3467: /*For bug 2875949*/
3468: IF (p_salesrep_email_id = fnd_api.g_miss_char) then
3469: IBE_UTIL.DEBUG('salesemail id is g miss char');
3470: return;
3471: ELSE
3472: IBE_UTIL.DEBUG('salesemail id is not g miss char, ideally call from iStore');

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

3488: End NotifyForContractsChange;
3489:
3490: PROCEDURE NotifyForContractsChange(
3491: p_api_version IN NUMBER,
3492: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3493: p_msite_id IN NUMBER,
3494: p_quote_id IN NUMBER,
3495: p_contract_id IN NUMBER,
3496: p_customer_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 3496: p_customer_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,

3492: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3493: p_msite_id IN NUMBER,
3494: p_quote_id IN NUMBER,
3495: p_contract_id IN NUMBER,
3496: p_customer_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,
3497: p_salesrep_email_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
3498: x_return_status OUT NOCOPY VARCHAR2,
3499: x_msg_count OUT NOCOPY NUMBER,
3500: x_msg_data OUT NOCOPY VARCHAR2

Line 3497: p_salesrep_email_id IN VARCHAR2 := FND_API.G_MISS_CHAR,

3493: p_msite_id IN NUMBER,
3494: p_quote_id IN NUMBER,
3495: p_contract_id IN NUMBER,
3496: p_customer_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,
3497: p_salesrep_email_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
3498: x_return_status OUT NOCOPY VARCHAR2,
3499: x_msg_count OUT NOCOPY NUMBER,
3500: x_msg_data OUT NOCOPY VARCHAR2
3501: ) IS

Line 3535: x_return_status := FND_API.g_ret_sts_success;

3531: l_msgEnabled VARCHAR2(3) :='Y';
3532:
3533: BEGIN
3534:
3535: x_return_status := FND_API.g_ret_sts_success;
3536:
3537:
3538: FOR c_quote_rec In c_quote_header(p_quote_id) LOOP
3539: l_cust_adhoc_user :='HZ_PARTY:'||c_quote_rec.party_id;

Line 3861: x_return_status := FND_API.g_ret_sts_error;

3857: End If; -- if salesquote message is enabled
3858: End If; -- if salesqute is enabled
3859: Exception
3860: When OTHERS Then
3861: x_return_status := FND_API.g_ret_sts_error;
3862: x_msg_count := 0;
3863: IF(IBE_UTIL.g_debugon = l_true) THEN
3864: IBE_UTIL.DEBUG('NotifyForContractsChange:Exception: '||SQLCODE||SQLERRM);
3865: END IF;

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

3877:
3878:
3879: PROCEDURE NotifyForSalesAssistance (
3880: p_api_version IN NUMBER,
3881: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3882: p_quote_id IN NUMBER,
3883: p_customer_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,
3884: p_salesrep_email_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
3885: p_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 3883: p_customer_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,

3879: PROCEDURE NotifyForSalesAssistance (
3880: p_api_version IN NUMBER,
3881: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3882: p_quote_id IN NUMBER,
3883: p_customer_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,
3884: p_salesrep_email_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
3885: p_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
3886: p_salesrep_user_id IN NUMBER := NULL,
3887: x_return_status OUT NOCOPY VARCHAR2,

Line 3884: p_salesrep_email_id IN VARCHAR2 := FND_API.G_MISS_CHAR,

3880: p_api_version IN NUMBER,
3881: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3882: p_quote_id IN NUMBER,
3883: p_customer_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,
3884: p_salesrep_email_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
3885: p_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
3886: p_salesrep_user_id IN NUMBER := NULL,
3887: x_return_status OUT NOCOPY VARCHAR2,
3888: x_msg_count OUT NOCOPY NUMBER,

Line 3885: p_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

3881: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3882: p_quote_id IN NUMBER,
3883: p_customer_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,
3884: p_salesrep_email_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
3885: p_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
3886: p_salesrep_user_id IN NUMBER := NULL,
3887: x_return_status OUT NOCOPY VARCHAR2,
3888: x_msg_count OUT NOCOPY NUMBER,
3889: x_msg_data OUT NOCOPY VARCHAR2

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

3908: End NotifyForSalesAssistance;
3909:
3910: PROCEDURE NotifyForSalesAssistance (
3911: p_api_version IN NUMBER,
3912: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3913: p_msite_id IN NUMBER,
3914: p_quote_id IN NUMBER,
3915: p_customer_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,
3916: p_salesrep_email_id IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 3915: p_customer_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,

3911: p_api_version IN NUMBER,
3912: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3913: p_msite_id IN NUMBER,
3914: p_quote_id IN NUMBER,
3915: p_customer_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,
3916: p_salesrep_email_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
3917: p_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
3918: p_salesrep_user_id IN NUMBER := NULL,
3919: x_return_status OUT NOCOPY VARCHAR2,

Line 3916: p_salesrep_email_id IN VARCHAR2 := FND_API.G_MISS_CHAR,

3912: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3913: p_msite_id IN NUMBER,
3914: p_quote_id IN NUMBER,
3915: p_customer_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,
3916: p_salesrep_email_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
3917: p_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
3918: p_salesrep_user_id IN NUMBER := NULL,
3919: x_return_status OUT NOCOPY VARCHAR2,
3920: x_msg_count OUT NOCOPY NUMBER,

Line 3917: p_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

3913: p_msite_id IN NUMBER,
3914: p_quote_id IN NUMBER,
3915: p_customer_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,
3916: p_salesrep_email_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
3917: p_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
3918: p_salesrep_user_id IN NUMBER := NULL,
3919: x_return_status OUT NOCOPY VARCHAR2,
3920: x_msg_count OUT NOCOPY NUMBER,
3921: x_msg_data OUT NOCOPY VARCHAR2

Line 4004: x_return_status := FND_API.g_ret_sts_success;

4000: where user_id = FND_GLOBAL.USER_ID;
4001: rec_userenv_partyid c_userenv_partyid%rowtype;
4002:
4003: BEGIN
4004: x_return_status := FND_API.g_ret_sts_success;
4005:
4006: -- Check for WorkFlow Enable Profile
4007:
4008:

Line 4030: p_init_msg_list => FND_API.G_TRUE,

4026: 'calling Get_sales_assist_hdr_tokens');
4027: END IF;
4028: IBE_CART_NOTIFY_UTIL.Get_sales_assist_hdr_tokens (
4029: p_api_version => 1.0,
4030: p_init_msg_list => FND_API.G_TRUE,
4031: p_commit => FND_API.G_FALSE,
4032: x_return_status => l_return_status,
4033: x_msg_count => l_msg_count,
4034: x_msg_data => l_msg_data,

Line 4031: p_commit => FND_API.G_FALSE,

4027: END IF;
4028: IBE_CART_NOTIFY_UTIL.Get_sales_assist_hdr_tokens (
4029: p_api_version => 1.0,
4030: p_init_msg_list => FND_API.G_TRUE,
4031: p_commit => FND_API.G_FALSE,
4032: x_return_status => l_return_status,
4033: x_msg_count => l_msg_count,
4034: x_msg_data => l_msg_data,
4035: p_quote_header_id => p_quote_id,

Line 4368: IF ( (p_salesrep_email_id is NOT NULL AND p_salesrep_email_id <> FND_API.G_MISS_CHAR) OR

4364: l_notification_preference :=
4365: NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_DEFAULT_USER_EMAIL_FORMAT',null,null,671), 'MAILTEXT');
4366:
4367: --Bug 2223507 start
4368: IF ( (p_salesrep_email_id is NOT NULL AND p_salesrep_email_id <> FND_API.G_MISS_CHAR) OR
4369: (p_salesrep_user_id is NOT NULL AND p_salesrep_user_id <> FND_API.G_MISS_NUM) ) THEN
4370: --Bug 2223507 end
4371:
4372: IF (( p_salesrep_email_id is NOT NULL)

Line 4369: (p_salesrep_user_id is NOT NULL AND p_salesrep_user_id <> FND_API.G_MISS_NUM) ) THEN

4365: NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_DEFAULT_USER_EMAIL_FORMAT',null,null,671), 'MAILTEXT');
4366:
4367: --Bug 2223507 start
4368: IF ( (p_salesrep_email_id is NOT NULL AND p_salesrep_email_id <> FND_API.G_MISS_CHAR) OR
4369: (p_salesrep_user_id is NOT NULL AND p_salesrep_user_id <> FND_API.G_MISS_NUM) ) THEN
4370: --Bug 2223507 end
4371:
4372: IF (( p_salesrep_email_id is NOT NULL)
4373: AND (p_salesrep_email_id <> FND_API.G_MISS_CHAR)) THEN

Line 4373: AND (p_salesrep_email_id <> FND_API.G_MISS_CHAR)) THEN

4369: (p_salesrep_user_id is NOT NULL AND p_salesrep_user_id <> FND_API.G_MISS_NUM) ) THEN
4370: --Bug 2223507 end
4371:
4372: IF (( p_salesrep_email_id is NOT NULL)
4373: AND (p_salesrep_email_id <> FND_API.G_MISS_CHAR)) THEN
4374:
4375: l_sales_adhoc_user := 'IBEA'||to_char(sysdate,'MMDDYYHH24MISS')||
4376: 'Q'||p_quote_id ;
4377: l_sales_adhoc_user_display := 'IBEA'||

Line 4633: x_return_status := FND_API.g_ret_sts_error;

4629:
4630: EXCEPTION
4631:
4632: WHEN OTHERS THEN
4633: x_return_status := FND_API.g_ret_sts_error;
4634: x_msg_count := 0;
4635: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
4636: IBE_UTIL.DEBUG('NotifySalesAssist:Exception block: '||SQLCODE||': '||SQLERRM);
4637: END IF;

Line 4691: x_create_adhoc_flag := FND_API.G_TRUE;

4687: begin
4688:
4689: for rec_contact_point in c_contact_point loop
4690: if rec_contact_point.owner_table_name = 'IBE_SH_QUOTE_ACCESS' then
4691: x_create_adhoc_flag := FND_API.G_TRUE;
4692: end if;
4693: exit when c_contact_point%notfound;
4694: end loop;
4695:

Line 4739: l_usertype jtf_um_usertypes_b.usertype_key%type := FND_API.G_MISS_CHAR;

4735: x_partyid HZ_PARTIES.PARTY_ID%TYPE;
4736: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
4737: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
4738: l_user_name WF_USERS.NAME%TYPE;
4739: l_usertype jtf_um_usertypes_b.usertype_key%type := FND_API.G_MISS_CHAR;
4740: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE;
4741: l_quote_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;
4742: l_quote_Num ASO_QUOTE_HEADERS_ALL.QUOTE_NUMBER%TYPE;
4743: l_quote_ver ASO_QUOTE_HEADERS_ALL.QUOTE_VERSION%TYPE;

Line 4746: l_is_it_quote VARCHAR2(1) := FND_API.G_FALSE;

4742: l_quote_Num ASO_QUOTE_HEADERS_ALL.QUOTE_NUMBER%TYPE;
4743: l_quote_ver ASO_QUOTE_HEADERS_ALL.QUOTE_VERSION%TYPE;
4744: l_msite_name IBE_MSITES_VL.MSITE_NAME%TYPE;
4745: l_cart_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;
4746: l_is_it_quote VARCHAR2(1) := FND_API.G_FALSE;
4747: x_contact_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
4748: x_contact_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
4749: l_recip_name Varchar2(2000);
4750:

Line 4773: x_return_status := FND_API.g_ret_sts_success;

4769: rec_get_recip_name c_get_recip_name%rowtype;
4770:
4771:
4772: BEGIN
4773: x_return_status := FND_API.g_ret_sts_success;
4774:
4775:
4776: identify_cart_quote(p_quote_header_id => p_Quote_Header_id,
4777: x_is_it_quote => l_is_it_quote);

Line 4795: -- IF (p_quote_header_id is not null) or (p_quote_header_id <> fnd_api.g_miss_num) THEN

4791: ibe_util.debug('Notify_end_working: Notification enabled: '||l_notifEnabled);
4792: END IF;
4793:
4794: IF l_notifEnabled = 'Y' THEN
4795: -- IF (p_quote_header_id is not null) or (p_quote_header_id <> fnd_api.g_miss_num) THEN
4796: FOR c_quote_rec In c_quote_header(p_Quote_Header_id) LOOP
4797: l_user_name :='HZ_PARTY:'||c_quote_rec.party_id;
4798: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
4799: ibe_util.debug('Notify_end_working: I_user_name: '||l_user_name);

Line 4835: l_usertype := FND_API.G_MISS_CHAR;

4831: ibe_util.debug('Notify_end_working:l_msgenabled: '||l_msgEnabled);
4832: END IF;
4833:
4834: IF l_msgEnabled = 'Y' THEN
4835: l_usertype := FND_API.G_MISS_CHAR;
4836: x_contact_first_name := NULL;
4837: x_contact_last_name := NULL;
4838: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
4839: ibe_util.debug('Notify_end_working:querying recipient_name');

Line 4893: x_return_status := FND_API.g_ret_sts_error;

4889: END IF; --l_notifenabled
4890: EXCEPTION
4891:
4892: WHEN OTHERS THEN
4893: x_return_status := FND_API.g_ret_sts_error;
4894: x_msg_count := 0;
4895: wf_core.context('IBE_WORKFLOW_PVT',l_notifname,l_messagename,p_quote_header_id);
4896: RAISE;
4897:

Line 4923: p_shared_by_partyid IN NUMBER := FND_API.G_MISS_NUM,

4919: p_quote_access_rec IN IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_REC_TYPE, --of the recepient
4920: p_minisite_id IN NUMBER,
4921: p_url IN VARCHAR2,
4922: p_context_code IN VARCHAR2,
4923: p_shared_by_partyid IN NUMBER := FND_API.G_MISS_NUM,
4924: p_notes IN VARCHAR2,
4925: x_return_status OUT NOCOPY VARCHAR2,
4926: x_msg_count OUT NOCOPY NUMBER,
4927: x_msg_data OUT NOCOPY VARCHAR2

Line 4943: l_is_it_quote VARCHAR2(1) := FND_API.G_FALSE;

4939: l_user_name WF_USERS.NAME%TYPE;
4940: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE ;
4941: l_msite_name IBE_MSITES_VL.MSITE_NAME%TYPE;
4942: l_cart_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;
4943: l_is_it_quote VARCHAR2(1) := FND_API.G_FALSE;
4944:
4945: l_sharedby_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
4946: l_sharedby_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
4947: l_owner_partyid HZ_PARTIES.PARTY_ID%TYPE;

Line 4975: x_return_status := FND_API.g_ret_sts_success ;

4971: rec_get_context_msg C_CONTEXT_CODE%ROWTYPE;*/
4972:
4973:
4974: BEGIN
4975: x_return_status := FND_API.g_ret_sts_success ;
4976:
4977: l_notification_preference := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_DEFAULT_USER_EMAIL_FORMAT',null,null,671), 'MAILTEXT');
4978:
4979:

Line 5026: l_usertype := FND_API.G_MISS_CHAR;

5022: IBE_UTIL.DEBUG('Notify_finish_sharing:Owner cart name: '||l_cart_name);
5023: END IF;
5024: END LOOP;
5025:
5026: l_usertype := FND_API.G_MISS_CHAR;
5027: l_sharedby_first_name := NULL;
5028: l_sharedby_last_name := NULL;
5029: Get_Name_details(p_party_id => p_shared_by_partyid,
5030: p_user_type => l_UserType,

Line 5052: IF (l_create_adhoc_flag = FND_API.G_TRUE) THEN

5048: p_contact_point_id => p_quote_access_rec.contact_point_id,
5049: x_create_adhoc_flag => l_create_adhoc_flag);
5050:
5051:
5052: IF (l_create_adhoc_flag = FND_API.G_TRUE) THEN
5053: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5054: IBE_UTIL.DEBUG('Notify_finish_sharing:l_create_adhoc_flag: '||l_create_adhoc_flag);
5055: END IF;
5056:

Line 5136: x_return_status := FND_API.g_ret_sts_error;

5132: END IF; --l_notif enabled
5133: EXCEPTION
5134:
5135: WHEN OTHERS THEN
5136: x_return_status := FND_API.g_ret_sts_error;
5137: x_msg_count := 0;
5138: wf_core.context('IBE_WORKFLOW_PVT',l_notifName,l_notifName);
5139: RAISE;
5140:

Line 5158: p_shared_by_party_id IN NUMBER := FND_API.G_MISS_NUM,

5154: p_init_msg_list IN VARCHAR2,
5155: p_quote_access_rec IN IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_REC_TYPE, --of the recepient
5156: p_minisite_id IN NUMBER,
5157: p_url IN VARCHAR2,
5158: p_shared_by_party_id IN NUMBER := FND_API.G_MISS_NUM,
5159: p_notes IN VARCHAR2,
5160: x_return_status OUT NOCOPY VARCHAR2,
5161: x_msg_count OUT NOCOPY NUMBER,
5162: x_msg_data OUT NOCOPY VARCHAR2

Line 5178: l_is_it_quote VARCHAR2(1) := FND_API.G_FALSE;

5174: l_user_name WF_USERS.NAME%TYPE;
5175: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE ;
5176: l_msite_name IBE_MSITES_VL.MSITE_NAME%TYPE;
5177: l_cart_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;
5178: l_is_it_quote VARCHAR2(1) := FND_API.G_FALSE;
5179:
5180: l_sharedby_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
5181: l_sharedby_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
5182: l_owner_partyid HZ_PARTIES.PARTY_ID%TYPE;

Line 5202: x_return_status := FND_API.g_ret_sts_success ;

5198: l_temp_update_str VARCHAR2(1000);
5199:
5200:
5201: BEGIN
5202: x_return_status := FND_API.g_ret_sts_success ;
5203:
5204: l_notification_preference := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_DEFAULT_USER_EMAIL_FORMAT',null,null,671), 'MAILTEXT');
5205:
5206: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 5215: OR (p_quote_access_rec.party_id = FND_API.G_MISS_NUM)) THEN

5211: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5212: IBE_UTIL.DEBUG('Notify_shared_cart:Determining party_type');
5213: END IF;
5214: IF ((p_quote_access_rec.party_id is null )
5215: OR (p_quote_access_rec.party_id = FND_API.G_MISS_NUM)) THEN
5216:
5217: l_usertype := 'IBE_INDIVIDUAL';
5218:
5219: ELSE

Line 5293: IF (l_create_adhoc_flag = FND_API.G_TRUE) THEN

5289: IBE_UTIL.DEBUG('Notify_shared_cart:l_create_adhoc_flag: '||l_create_adhoc_flag);
5290: END IF;
5291:
5292: --if create adhoc user flag is "true" then call wf_directory API
5293: IF (l_create_adhoc_flag = FND_API.G_TRUE) THEN
5294: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5295: IBE_UTIL.DEBUG('Notify_shared_cart:l_create_adhoc_flag is true');
5296: IBE_UTIL.DEBUG('Notify_shared_cart:p_quote_access_rec.QUOTE_SHAREE_ID: '||p_quote_access_rec.QUOTE_SHAREE_ID);
5297: IBE_UTIL.DEBUG('Notify_shared_cart:p_quote_access_rec.quote_header_id: '||p_quote_access_rec.quote_header_id);

Line 5388: x_return_status := FND_API.g_ret_sts_error;

5384: END IF; -- l_notifenabled
5385: EXCEPTION
5386:
5387: WHEN OTHERS THEN
5388: x_return_status := FND_API.g_ret_sts_error;
5389: x_msg_count := 0;
5390: wf_core.context('IBE_WORKFLOW_PVT',l_notifName,l_notifName);
5391: RAISE;
5392:

Line 5412: p_shared_by_party_id IN NUMBER := FND_API.G_MISS_NUM,

5408: p_quote_access_rec IN IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_REC_TYPE, --of the recepient
5409: p_minisite_id IN NUMBER,
5410: p_url IN VARCHAR2,
5411: p_old_accesslevel IN VARCHAR2,
5412: p_shared_by_party_id IN NUMBER := FND_API.G_MISS_NUM,
5413: p_notes IN VARCHAR2,
5414: x_return_status OUT NOCOPY VARCHAR2,
5415: x_msg_count OUT NOCOPY NUMBER,
5416: x_msg_data OUT NOCOPY VARCHAR2

Line 5432: l_is_it_quote varchar2(1) := FND_API.G_FALSE;

5428: l_user_name WF_USERS.NAME%TYPE;
5429: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE ;
5430: l_msite_name IBE_MSITES_VL.MSITE_NAME%TYPE;
5431: l_cart_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;
5432: l_is_it_quote varchar2(1) := FND_API.G_FALSE;
5433:
5434: l_sharedby_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
5435: l_sharedby_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
5436: l_owner_partyid HZ_PARTIES.PARTY_ID%TYPE;

Line 5464: x_return_status := FND_API.g_ret_sts_success ;

5460:
5461: rec_get_email c_get_email%rowtype;
5462:
5463: BEGIN
5464: x_return_status := FND_API.g_ret_sts_success ;
5465:
5466: l_notification_preference := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_DEFAULT_USER_EMAIL_FORMAT',null,null,671), 'MAILTEXT');
5467: l_quote_access_rec := p_quote_access_rec;
5468:

Line 5499: l_usertype := FND_API.G_MISS_CHAR;

5495: l_orgid := c_quote_rec.org_id;
5496: l_cart_name := c_quote_rec.quote_name; -- cart name
5497: END LOOP;
5498:
5499: l_usertype := FND_API.G_MISS_CHAR;
5500: l_sharedby_first_name := NULL;
5501: l_sharedby_last_name := NULL;
5502: Get_Name_details(p_party_id => p_shared_by_party_id,
5503: p_user_type => l_UserType,

Line 5512: l_usertype := FND_API.G_MISS_CHAR;

5508: -- Now identify whether the recepient is B2B or B2C ****
5509: -- Call the Get_Name_details to get the party_id of the recepient.
5510: -- And pipe it with HZ_PARTIES to get email id of the recepient.
5511:
5512: l_usertype := FND_API.G_MISS_CHAR;
5513: x_recepient_party_id := 0;
5514: Get_Name_details(p_party_id => l_quote_access_rec.party_id,
5515: p_user_type => l_UserType,
5516: x_contact_first_name => l_recepient_first_name,

Line 5539: IF (l_create_adhoc_flag = FND_API.G_TRUE) THEN

5535:
5536: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5537: IBE_UTIL.DEBUG('Notify_access_change:l_create_adhoc_flag: '||l_create_adhoc_flag);
5538: END IF;
5539: IF (l_create_adhoc_flag = FND_API.G_TRUE) THEN
5540:
5541: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5542: IBE_UTIL.DEBUG('Notify_access_change:Opening c_get_email');
5543: END IF;

Line 5601: l_temp_update_str := FND_API.G_MISS_CHAR;

5597: END IF;
5598:
5599: -- Retrieve the message text for update message from fnd_messages
5600: fnd_message.set_name('IBE','IBE_PRMT_UPDATE_CART');
5601: l_temp_update_str := FND_API.G_MISS_CHAR;
5602: l_temp_update_str := fnd_message.get;
5603: --l_msgEnabled := 'Y';
5604: IF l_msgEnabled = 'Y' THEN
5605: l_url := p_url;

Line 5634: x_return_status := FND_API.g_ret_sts_error;

5630: END IF; --l_notifenabled
5631: EXCEPTION
5632:
5633: WHEN OTHERS THEN
5634: x_return_status := FND_API.g_ret_sts_error;
5635: x_msg_count := 0;
5636: wf_core.context('IBE_WORKFLOW_PVT',l_notifName,l_notifName);
5637: RAISE;
5638:

Line 5649: p_owner_party_id IN NUMBER := FND_API.G_MISS_NUM,

5645: p_minisite_id IN NUMBER,
5646: p_url IN VARCHAR2,
5647: p_sent_by_party_id IN NUMBER ,
5648: p_notes IN VARCHAR2,
5649: p_owner_party_id IN NUMBER := FND_API.G_MISS_NUM,
5650: x_return_status OUT NOCOPY VARCHAR2,
5651: x_msg_count OUT NOCOPY NUMBER,
5652: x_msg_data OUT NOCOPY VARCHAR2
5653: ) is

Line 5693: x_return_status := FND_API.g_ret_sts_success ;

5689:
5690: l_notif_name VARCHAR2(1000) := 'IBE_VIEWSHAREDCART';
5691: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE;
5692: BEGIN
5693: x_return_status := FND_API.g_ret_sts_success ;
5694: IBE_UTIL.DEBUG('Notify_view_shared_cart: START');
5695:
5696: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5697: ibe_util.debug('Check if this notification is enabled.');

Line 5711: IF (l_create_adhoc_flag = FND_API.G_TRUE) THEN

5707: p_contact_point_id => p_quote_access_rec.contact_point_id,
5708: x_create_adhoc_flag => l_create_adhoc_flag);
5709:
5710:
5711: IF (l_create_adhoc_flag = FND_API.G_TRUE) THEN
5712: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5713: IBE_UTIL.DEBUG('Notify_view_shared_cart:l_create_adhoc_flag: '||l_create_adhoc_flag);
5714: END IF;
5715:

Line 5751: p_user_type => FND_API.G_MISS_CHAR,

5747: IBE_UTIL.DEBUG('Notify_view_shared_cart:p_quote_access_rec.party_id '||p_quote_access_rec.party_id);
5748: END IF;
5749:
5750: Get_Name_details(p_party_id => p_sent_by_party_id,
5751: p_user_type => FND_API.G_MISS_CHAR,
5752: x_contact_first_name => l_sent_by_first_name,
5753: x_contact_last_name => l_sent_by_last_name,
5754: x_party_id => l_sent_by_party_id);
5755:

Line 5769: (p_owner_party_id <> FND_API.G_MISS_NUM)) THEN

5765:
5766: getusertype(p_quote_access_rec.party_id, l_user_type);
5767:
5768: IF ((p_owner_party_id is not null ) AND
5769: (p_owner_party_id <> FND_API.G_MISS_NUM)) THEN
5770: l_url := p_url;
5771: l_access_code :='O';
5772: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5773: IBE_UTIL.DEBUG('Notify_view_shared_cart:l_access_code '||l_access_code);

Line 5808: p_quote_access_rec.Quote_sharee_number <> FND_API.G_MISS_NUM) THEN

5804: END IF;
5805:
5806: IF l_msg_Enabled = 'Y' THEN
5807: IF (p_quote_access_rec.Quote_sharee_number is not null AND
5808: p_quote_access_rec.Quote_sharee_number <> FND_API.G_MISS_NUM) THEN
5809: l_item_key := l_event_type||'-'||to_char(sysdate,'MMDDYYHH24MISS')||'-'||p_quote_access_rec.Quote_Header_id
5810: ||p_quote_access_rec.Quote_sharee_number;
5811: ELSE
5812: l_item_key := l_event_type||'-'||to_char(sysdate,'MMDDYYHH24MISS')||'-'||p_quote_access_rec.Quote_Header_id;

Line 5932: x_return_status := FND_API.g_ret_sts_error;

5928: END IF;
5929: EXCEPTION
5930:
5931: WHEN OTHERS THEN
5932: x_return_status := FND_API.g_ret_sts_error;
5933: x_msg_count := 0;
5934: --wf_core.context('IBE_WORKFLOW_PVT',l_notifName,l_notifName);
5935: RAISE;
5936:

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

5940: ------------------------------------------------------------------------
5941:
5942: PROCEDURE NotifyForSharedCart (
5943: p_api_version IN NUMBER,
5944: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
5945: p_Quote_Header_id IN NUMBER,
5946: p_emailAddress IN VARCHAR2,
5947: p_quoteShareeNum IN NUMBER,
5948: p_privilegeType IN VARCHAR2,

Line 5950: p_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,

5946: p_emailAddress IN VARCHAR2,
5947: p_quoteShareeNum IN NUMBER,
5948: p_privilegeType IN VARCHAR2,
5949: p_url IN VARCHAR2,
5950: p_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,
5951: x_return_status OUT NOCOPY VARCHAR2,
5952: x_msg_count OUT NOCOPY NUMBER,
5953: x_msg_data OUT NOCOPY VARCHAR2
5954: ) IS

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

5975:
5976:
5977: PROCEDURE NotifyForSharedCart (
5978: p_api_version IN NUMBER,
5979: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
5980: p_Msite_id IN NUMBER,
5981: p_Quote_Header_id IN NUMBER,
5982: p_emailAddress IN VARCHAR2,
5983: p_quoteShareeNum IN NUMBER,

Line 5986: p_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,

5982: p_emailAddress IN VARCHAR2,
5983: p_quoteShareeNum IN NUMBER,
5984: p_privilegeType IN VARCHAR2,
5985: p_url IN VARCHAR2,
5986: p_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,
5987: x_return_status OUT NOCOPY VARCHAR2,
5988: x_msg_count OUT NOCOPY NUMBER,
5989: x_msg_data OUT NOCOPY VARCHAR2
5990: ) IS

Line 6020: x_return_status := FND_API.g_ret_sts_success;

6016: l_last_name_sc VARCHAR2(360);
6017: l_dummy_document_type VARCHAR2(200);
6018:
6019: BEGIN
6020: x_return_status := FND_API.g_ret_sts_success;
6021:
6022: -- Check for WorkFlow Feature Availablity.
6023: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
6024: ibe_util.debug('Check if this notification is enabled.');

Line 6222: x_return_status := FND_API.g_ret_sts_error;

6218: End If;
6219: Exception
6220:
6221: When OTHERS Then
6222: x_return_status := FND_API.g_ret_sts_error;
6223: x_msg_count := 0;
6224: wf_core.context('ibe_workflow_pvt','SHAREDCART','SHAREDCART');
6225: raise;
6226: End NotifyForSharedCart;

Line 7165: l_view_line_type_flag VARCHAR2(1) := FND_API.G_FALSE;

7161: l_amt_format Varchar2(50);
7162: l_curr_sym FND_CURRENCIES.SYMBOL%TYPE;
7163: l_temp_str VARCHAR2(2000):='';
7164: l_view_net_price_flag VARCHAR2(1);
7165: l_view_line_type_flag VARCHAR2(1) := FND_API.G_FALSE;
7166: Cursor c_ship_flag(p_line_id NUMBER) IS
7167: SELECT msi.shippable_item_flag
7168: FROM oe_order_lines_all line,
7169: OE_SYSTEM_PARAMETERS_ALL osp,

Line 7440: l_view_line_type_flag := FND_API.G_TRUE;

7436: Open c_get_source_code(l_quote_id);
7437: FETCH c_get_source_code into l_quote_source_code;
7438: Close c_get_source_code;
7439: if (l_quote_source_code = 'IStore InstallBase') then
7440: l_view_line_type_flag := FND_API.G_TRUE;
7441: end if;
7442:
7443: For g_quote_header_rec In c_quote_header(l_quote_id) Loop
7444: l_amt_format := FND_CURRENCY.GET_FORMAT_MASK(g_quote_header_rec.currency_code,18);

Line 7465: IF(p_quote_flag = fnd_api.g_true) then

7461: --Get Display Option class profile value
7462: l_displayOptionClass := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_DISPLAY_OPTION_CLASSES',null,null,671), 'Y');
7463: l_displayUnchangedItem := NVL( FND_PROFILE.VALUE_SPECIFIC('CZ_OUTPUT_IB_UNCHD_CHILD_ITEMS',null,null,671), 'Y');
7464:
7465: IF(p_quote_flag = fnd_api.g_true) then
7466: FOR g_notif_quote_line_rec IN c_get_top_quote_lines(l_quote_id) LOOP
7467: if(g_notif_quote_line_rec.config_instance_name is not null) then
7468: notif_line_tbl(l_index).Product := g_notif_quote_line_rec.description||':'||g_notif_quote_line_rec.config_instance_name;
7469: else

Line 7505: notif_line_tbl(l_index-1).LastItem := FND_API.G_TRUE;

7501: l_index := l_index+1;
7502: END IF;--Hide Option class and Unchanged Lines
7503: end loop;
7504: end if;
7505: notif_line_tbl(l_index-1).LastItem := FND_API.G_TRUE;
7506: EXIT WHEN c_get_top_quote_lines%NOTFOUND;
7507: END LOOP;
7508: l_document := buildDocument(notif_line_tbl,l_view_net_price_flag,l_view_line_type_flag,p_tax_flag);
7509: --Order details content generation

Line 7510: Elsif(p_quote_flag = fnd_api.g_false) then

7506: EXIT WHEN c_get_top_quote_lines%NOTFOUND;
7507: END LOOP;
7508: l_document := buildDocument(notif_line_tbl,l_view_net_price_flag,l_view_line_type_flag,p_tax_flag);
7509: --Order details content generation
7510: Elsif(p_quote_flag = fnd_api.g_false) then
7511: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
7512: IBE_UTIL.debug('p_quote_flag is false, entering the order area');
7513: END IF;
7514: --Begin New Order Generate Detail

Line 7566: notif_line_tbl(l_index-1).LastItem := FND_API.G_TRUE;

7562: notif_line_tbl(l_index).NetAmount := notif_line_tbl(l_index).NetAmount + g_notif_config_orderline_rec.lines_total;
7563: notif_line_tbl(l_index).TaxAmount := notif_line_tbl(l_index).NetAmount + g_notif_config_orderline_rec.lines_total;
7564: END LOOP;
7565: end if;
7566: notif_line_tbl(l_index-1).LastItem := FND_API.G_TRUE;
7567: END LOOP;
7568: --End New Order Generate Detail
7569: l_document := buildDocument(notif_line_tbl,l_view_net_price_flag,l_view_line_type_flag,p_tax_flag);
7570: END IF; --for l_quote_flag

Line 7901: IF (l_view_net_price_flag = 'Y' and p_tax_flag = fnd_api.g_true) THEN

7897: l_document := l_document ||NEWLINE;
7898: END IF;
7899: END IF;
7900: END LOOP;
7901: IF (l_view_net_price_flag = 'Y' and p_tax_flag = fnd_api.g_true) THEN
7902: fnd_message.set_name('IBE','IBE_PRMT_ORD_TAX');
7903: l_temp_str := null;
7904: l_temp_str := fnd_message.get;
7905: IF (to_char(ord_detail_tbl(i).taxes_total) is not null) THEN

Line 7938: L_quote_flag VARCHAR2(1) := fnd_api.g_false;

7934: ) is
7935: L_api_name CONSTANT VARCHAR2(30) := 'Generate_order_Detail_wtax';
7936: L_api_version CONSTANT NUMBER := 1.0;
7937:
7938: L_quote_flag VARCHAR2(1) := fnd_api.g_false;
7939: L_tax_flag VARCHAR2(1) := fnd_api.g_true;
7940: BEGIN
7941: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
7942: IBE_UTIL.DEBUG('Generate_order_Detail_wtax:START');

Line 7939: L_tax_flag VARCHAR2(1) := fnd_api.g_true;

7935: L_api_name CONSTANT VARCHAR2(30) := 'Generate_order_Detail_wtax';
7936: L_api_version CONSTANT NUMBER := 1.0;
7937:
7938: L_quote_flag VARCHAR2(1) := fnd_api.g_false;
7939: L_tax_flag VARCHAR2(1) := fnd_api.g_true;
7940: BEGIN
7941: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
7942: IBE_UTIL.DEBUG('Generate_order_Detail_wtax:START');
7943: END IF;

Line 7986: l_tax_flag VARCHAR2(1) := fnd_api.g_true;

7982: document_type IN OUT NOCOPY VARCHAR2
7983: ) is
7984: l_api_name CONSTANT VARCHAR2(30) := 'Generate_rtn_ord_Detail_wtax';
7985: l_api_version CONSTANT NUMBER := 1.0;
7986: l_tax_flag VARCHAR2(1) := fnd_api.g_true;
7987:
7988: BEGIN
7989:
7990: ibe_workflow_pvt.GenerateReturnDetail(

Line 8022: L_quote_flag VARCHAR2(1) := fnd_api.g_true;

8018: ) is
8019: L_api_name CONSTANT VARCHAR2(30) := 'Generate_quote_Detail_wtax';
8020: L_api_version CONSTANT NUMBER := 1.0;
8021:
8022: L_quote_flag VARCHAR2(1) := fnd_api.g_true;
8023: L_tax_flag VARCHAR2(1) := fnd_api.g_true;
8024: BEGIN
8025: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
8026: IBE_UTIL.DEBUG('Generate_quote_Detail_wtax:START');

Line 8023: L_tax_flag VARCHAR2(1) := fnd_api.g_true;

8019: L_api_name CONSTANT VARCHAR2(30) := 'Generate_quote_Detail_wtax';
8020: L_api_version CONSTANT NUMBER := 1.0;
8021:
8022: L_quote_flag VARCHAR2(1) := fnd_api.g_true;
8023: L_tax_flag VARCHAR2(1) := fnd_api.g_true;
8024: BEGIN
8025: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
8026: IBE_UTIL.DEBUG('Generate_quote_Detail_wtax:START');
8027: END IF;

Line 8058: L_quote_flag VARCHAR2(1) := fnd_api.g_false;

8054: ) is
8055: L_api_name CONSTANT VARCHAR2(30) := 'Generate_order_Detail_notax';
8056: L_api_version CONSTANT NUMBER := 1.0;
8057:
8058: L_quote_flag VARCHAR2(1) := fnd_api.g_false;
8059: L_tax_flag VARCHAR2(1) := fnd_api.g_false;
8060: BEGIN
8061: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
8062: IBE_UTIL.DEBUG('Generate_order_Detail_notax:START');

Line 8059: L_tax_flag VARCHAR2(1) := fnd_api.g_false;

8055: L_api_name CONSTANT VARCHAR2(30) := 'Generate_order_Detail_notax';
8056: L_api_version CONSTANT NUMBER := 1.0;
8057:
8058: L_quote_flag VARCHAR2(1) := fnd_api.g_false;
8059: L_tax_flag VARCHAR2(1) := fnd_api.g_false;
8060: BEGIN
8061: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
8062: IBE_UTIL.DEBUG('Generate_order_Detail_notax:START');
8063: END IF;

Line 8107: l_tax_flag VARCHAR2(1) := fnd_api.g_false;

8103: document_type IN OUT NOCOPY VARCHAR2
8104: ) is
8105: l_api_name CONSTANT VARCHAR2(30) := 'Generate_rtn_ord_Detail_notax';
8106: l_api_version CONSTANT NUMBER := 1.0;
8107: l_tax_flag VARCHAR2(1) := fnd_api.g_false;
8108:
8109: BEGIN
8110:
8111: ibe_workflow_pvt.GenerateReturnDetail(

Line 8143: L_quote_flag VARCHAR2(1) := fnd_api.g_true;

8139: ) is
8140: L_api_name CONSTANT VARCHAR2(30) := 'Generate_quote_Detail_notax';
8141: L_api_version CONSTANT NUMBER := 1.0;
8142:
8143: L_quote_flag VARCHAR2(1) := fnd_api.g_true;
8144: L_tax_flag VARCHAR2(1) := fnd_api.g_false;
8145: BEGIN
8146: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
8147: IBE_UTIL.DEBUG('Generate_order_Detail_notax:START');

Line 8144: L_tax_flag VARCHAR2(1) := fnd_api.g_false;

8140: L_api_name CONSTANT VARCHAR2(30) := 'Generate_quote_Detail_notax';
8141: L_api_version CONSTANT NUMBER := 1.0;
8142:
8143: L_quote_flag VARCHAR2(1) := fnd_api.g_true;
8144: L_tax_flag VARCHAR2(1) := fnd_api.g_false;
8145: BEGIN
8146: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
8147: IBE_UTIL.DEBUG('Generate_order_Detail_notax:START');
8148: END IF;

Line 10265: if(view_line_type_flag = fnd_api.g_true) then

10261: l_curr_sym := g_curr_sym;
10262: l_amt_format := g_amt_format;
10263: for counter in 1..notif_line_tbl.count loop
10264: l_space_len := 56;
10265: if(view_line_type_flag = fnd_api.g_true) then
10266: if(Notif_Line_Tbl(counter).Action is not null AND Notif_Line_Tbl(counter).Action <> FND_API.G_MISS_CHAR) then
10267: ldocument := ldocument || rpad(Notif_Line_Tbl(counter).Action,9,' ')||' ';
10268: else
10269: ldocument := ldocument || lpad(' ',9)||' ';

Line 10266: if(Notif_Line_Tbl(counter).Action is not null AND Notif_Line_Tbl(counter).Action <> FND_API.G_MISS_CHAR) then

10262: l_amt_format := g_amt_format;
10263: for counter in 1..notif_line_tbl.count loop
10264: l_space_len := 56;
10265: if(view_line_type_flag = fnd_api.g_true) then
10266: if(Notif_Line_Tbl(counter).Action is not null AND Notif_Line_Tbl(counter).Action <> FND_API.G_MISS_CHAR) then
10267: ldocument := ldocument || rpad(Notif_Line_Tbl(counter).Action,9,' ')||' ';
10268: else
10269: ldocument := ldocument || lpad(' ',9)||' ';
10270: end if;

Line 10281: if(view_line_type_flag <> fnd_api.g_true) then

10277: p_string_left => l_string_left);
10278: ldocument := ldocument || rpad(l_string_out,28)||' ';
10279: ldocument := ldocument || lpad(trim(Notif_Line_Tbl(counter).UOM),8)||' ';
10280: ldocument := ldocument || lpad(trim(Notif_Line_Tbl(counter).Quantity),7)||' ';
10281: if(view_line_type_flag <> fnd_api.g_true) then
10282: ldocument := ldocument || lpad(trim(Notif_Line_Tbl(counter).Shippable),9)||' ';
10283: end if;
10284: if(view_net_price_flag = 'Y') then
10285: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(Notif_Line_Tbl(counter).NetAmount));

Line 10291: if(view_line_type_flag = fnd_api.g_true) then

10287: end if;
10288: ldocument := ldocument ||NEWLINE;
10289: l_string_in := l_string_left;
10290: if(length(l_string_in) > 0) THEN
10291: if(view_line_type_flag = fnd_api.g_true) then
10292: ldocument := ldocument || rpad(' ',9)||' ';
10293: end if;
10294: parseString
10295: (p_string_in => l_string_in,

Line 10300: if(view_line_type_flag = fnd_api.g_true) then

10296: p_string_len => 28,
10297: p_string_out => l_string_out,
10298: p_string_left => l_string_left);
10299: ldocument := ldocument || rpad(trim(l_string_out),28)||' ';
10300: if(view_line_type_flag = fnd_api.g_true) then
10301: l_space_len := l_space_len - 39;
10302: else
10303: l_space_len := l_space_len - 29;
10304: end if;

Line 10323: IF(tax_flag = fnd_api.g_true) then

10319: parseString(l_string_in,28,l_string_out,l_string_left);
10320: ldocument := ldocument || rpad(trim(l_string_out),28) ||NEWLINE;
10321: l_string_in := l_string_left;
10322: END LOOP;
10323: IF(tax_flag = fnd_api.g_true) then
10324: IF view_net_price_flag = 'Y' THEN
10325: fnd_message.set_name('IBE','IBE_PRMT_ORD_TAX');
10326: l_temp_str := null;
10327: l_temp_str := fnd_message.get;

Line 10333: IF (FND_API.To_Boolean(Notif_Line_Tbl(counter).LastItem) and counter <> Notif_Line_Tbl.count) THEN

10329: ldocument := ldocument ||lpad(l_temp_str||': '||l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),72,' ')||NEWLINE;
10330: END IF;
10331: END IF;
10332:
10333: IF (FND_API.To_Boolean(Notif_Line_Tbl(counter).LastItem) and counter <> Notif_Line_Tbl.count) THEN
10334: ldocument := ldocument || '------------------------------------------------------------------------'||NEWLINE;
10335: END IF;
10336: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
10337: IBE_UTIL.DEBUG('Going to print ldocument in buildDocument'||ldocument);