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 119: l_true VARCHAR2(1) := FND_API.G_TRUE;

115: | 06/Jun/06 aannamal 5260544 - Fix to have negative amounts within angular brackets
116: | 19/Sep/06 aannamal 5480501 - Made changes to display correct line amount in Order confirmation Notification
117: ==============================================================================================
118: */
119: l_true VARCHAR2(1) := FND_API.G_TRUE;
120: g_ItemType Varchar2(10) := 'IBEALERT';
121: g_processName Varchar2(30) := 'PROCESSMAP';
122:
123:

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

475: from aso_quote_headers_all
476: where quote_header_id = c_quote_header_id;
477:
478: rec_get_cart_type c_get_cart_type%rowtype;
479: l_is_it_quote VARCHAR2(1) := fnd_api.g_false;
480: BEGIN
481:
482: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
483: IBE_UTIL.DEBUG('Identify_cart_quote: Start');

Line 488: l_is_it_quote := FND_API.G_TRUE;

484: IBE_UTIL.DEBUG('Identify_cart_quote:inout quote_header_id: '||p_quote_header_id);
485: END IF;
486: For rec_get_cart_type in c_get_cart_type(p_quote_header_id) LOOP
487: IF (rec_get_cart_type.resource_id is not null) THEN
488: l_is_it_quote := FND_API.G_TRUE;
489: END IF;
490: EXIT when c_get_cart_type%notfound;
491: END LOOP;
492: x_is_it_quote := l_is_it_quote;

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

496:
497: END;
498:
499: Procedure create_adhoc_entity
500: ( p_quote_recipient_id IN NUMBER := FND_API.G_MISS_NUM
501: ,p_quote_header_id IN NUMBER := FND_API.G_MISS_NUM
502: ,p_email_address IN VARCHAR2:= FND_API.G_MISS_CHAR
503: ,p_Notification_preference IN VARCHAR2:= FND_API.G_MISS_CHAR
504: ,x_adhoc_role OUT NOCOPY VARCHAR2) is

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

497: END;
498:
499: Procedure create_adhoc_entity
500: ( p_quote_recipient_id IN NUMBER := FND_API.G_MISS_NUM
501: ,p_quote_header_id IN NUMBER := FND_API.G_MISS_NUM
502: ,p_email_address IN VARCHAR2:= FND_API.G_MISS_CHAR
503: ,p_Notification_preference IN VARCHAR2:= FND_API.G_MISS_CHAR
504: ,x_adhoc_role OUT NOCOPY VARCHAR2) is
505:

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

498:
499: Procedure create_adhoc_entity
500: ( p_quote_recipient_id IN NUMBER := FND_API.G_MISS_NUM
501: ,p_quote_header_id IN NUMBER := FND_API.G_MISS_NUM
502: ,p_email_address IN VARCHAR2:= FND_API.G_MISS_CHAR
503: ,p_Notification_preference IN VARCHAR2:= FND_API.G_MISS_CHAR
504: ,x_adhoc_role OUT NOCOPY VARCHAR2) is
505:
506: l_adhoc_user VARCHAR2(2000);

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

499: Procedure create_adhoc_entity
500: ( p_quote_recipient_id IN NUMBER := FND_API.G_MISS_NUM
501: ,p_quote_header_id IN NUMBER := FND_API.G_MISS_NUM
502: ,p_email_address IN VARCHAR2:= FND_API.G_MISS_CHAR
503: ,p_Notification_preference IN VARCHAR2:= FND_API.G_MISS_CHAR
504: ,x_adhoc_role OUT NOCOPY VARCHAR2) is
505:
506: l_adhoc_user VARCHAR2(2000);
507: l_adhoc_user_display VARCHAR2(2000);

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

567:
568: procedure set_item_attributes
569: ( p_item_key IN VARCHAR2
570: ,p_message_name IN VARCHAR2
571: ,p_access_level IN VARCHAR2 :=FND_API.G_MISS_CHAR
572: ,p_old_access_level IN VARCHAR2 :=FND_API.G_MISS_CHAR
573: ,p_recipient_number IN VARCHAR2 :=FND_API.G_MISS_CHAR
574: ,p_first_name IN VARCHAR2
575: ,p_last_name IN VARCHAR2

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

568: procedure set_item_attributes
569: ( p_item_key IN VARCHAR2
570: ,p_message_name IN VARCHAR2
571: ,p_access_level IN VARCHAR2 :=FND_API.G_MISS_CHAR
572: ,p_old_access_level IN VARCHAR2 :=FND_API.G_MISS_CHAR
573: ,p_recipient_number IN VARCHAR2 :=FND_API.G_MISS_CHAR
574: ,p_first_name IN VARCHAR2
575: ,p_last_name IN VARCHAR2
576: ,p_url IN VARCHAR2 :=FND_API.G_MISS_CHAR

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

569: ( p_item_key IN VARCHAR2
570: ,p_message_name IN VARCHAR2
571: ,p_access_level IN VARCHAR2 :=FND_API.G_MISS_CHAR
572: ,p_old_access_level IN VARCHAR2 :=FND_API.G_MISS_CHAR
573: ,p_recipient_number IN VARCHAR2 :=FND_API.G_MISS_CHAR
574: ,p_first_name IN VARCHAR2
575: ,p_last_name IN VARCHAR2
576: ,p_url IN VARCHAR2 :=FND_API.G_MISS_CHAR
577: ,p_minisite_id IN VARCHAR2

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

572: ,p_old_access_level IN VARCHAR2 :=FND_API.G_MISS_CHAR
573: ,p_recipient_number IN VARCHAR2 :=FND_API.G_MISS_CHAR
574: ,p_first_name IN VARCHAR2
575: ,p_last_name IN VARCHAR2
576: ,p_url IN VARCHAR2 :=FND_API.G_MISS_CHAR
577: ,p_minisite_id IN VARCHAR2
578: ,p_cart_name IN VARCHAR2
579: ,p_adhoc_role IN VARCHAR2 :=FND_API.G_MISS_CHAR
580: ,p_context_msg IN VARCHAR2 :=FND_API.G_MISS_CHAR

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

575: ,p_last_name IN VARCHAR2
576: ,p_url IN VARCHAR2 :=FND_API.G_MISS_CHAR
577: ,p_minisite_id IN VARCHAR2
578: ,p_cart_name IN VARCHAR2
579: ,p_adhoc_role IN VARCHAR2 :=FND_API.G_MISS_CHAR
580: ,p_context_msg IN VARCHAR2 :=FND_API.G_MISS_CHAR
581: ,p_notes IN VARCHAR2 :=FND_API.G_MISS_CHAR
582: ,p_notif_context IN VARCHAR2 ) is
583:

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

576: ,p_url IN VARCHAR2 :=FND_API.G_MISS_CHAR
577: ,p_minisite_id IN VARCHAR2
578: ,p_cart_name IN VARCHAR2
579: ,p_adhoc_role IN VARCHAR2 :=FND_API.G_MISS_CHAR
580: ,p_context_msg IN VARCHAR2 :=FND_API.G_MISS_CHAR
581: ,p_notes IN VARCHAR2 :=FND_API.G_MISS_CHAR
582: ,p_notif_context IN VARCHAR2 ) is
583:
584: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';

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

577: ,p_minisite_id IN VARCHAR2
578: ,p_cart_name IN VARCHAR2
579: ,p_adhoc_role IN VARCHAR2 :=FND_API.G_MISS_CHAR
580: ,p_context_msg IN VARCHAR2 :=FND_API.G_MISS_CHAR
581: ,p_notes IN VARCHAR2 :=FND_API.G_MISS_CHAR
582: ,p_notif_context IN VARCHAR2 ) is
583:
584: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
585: l_temp_retrieve_str Varchar2(2000);

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

647: IBE_UTIL.DEBUG('Set_item_attributes:Done setItemAttribute for CARTNAME');
648: END IF;
649:
650: IF((p_first_name is not null) and
651: (p_first_name <> FND_API.G_MISS_CHAR)) THEN
652: wf_engine.SetItemAttrText(
653: itemtype => g_ItemType,
654: itemkey => p_item_key,
655: aname => 'FIRSTNAME',

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

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

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

671: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
672: IBE_UTIL.DEBUG('Set_item_attributes:Done setItemAttribute for LASTNAME');
673: END IF;
674: IF((p_notes is not null) and
675: (p_notes <> FND_API.G_MISS_CHAR)) THEN
676: wf_engine.SetItemAttrText(
677: itemtype => g_ItemType,
678: itemkey => p_item_key,
679: aname => 'SHARECOMMENTS',

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

819:
820:
821: /*PROCEDURE Get_Name_details(p_party_id IN HZ_PARTIES.PARTY_ID%TYPE,
822: p_user_type IN VARCHAR2,
823: p_sharee_number IN NUMBER := FND_API.G_MISS_NUM,
824: x_contact_first_name OUT NOCOPY HZ_PARTIES.PERSON_FIRST_NAME%TYPE,
825: x_contact_last_name OUT NOCOPY HZ_PARTIES.PERSON_LAST_NAME%TYPE,
826: x_party_id OUT NOCOPY HZ_PARTIES.PARTY_ID%TYPE) IS
827:

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

857: ibe_util.debug('get_name_details:input sharee number: '||p_sharee_number);
858: END IF;
859:
860:
861: IF ((p_user_type = FND_API.G_MISS_CHAR)
862: OR (p_user_type = null)) THEN
863: -- User Type of the owner
864: getUserType(p_party_Id,l_UserType);
865: ELSE

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

874: x_party_id := rec_party_info.party_id;
875: END LOOP;
876: ELSE
877: x_party_id := p_party_id;
878: IF ((p_party_id is not null) or (p_party_id <> fnd_api.g_miss_num)) THEN
879: FOR rec_get_recepient_name IN c_get_recepient_name(p_party_id )
880: LOOP
881: x_contact_first_name := rec_get_recepient_name.person_first_name;
882: x_contact_last_name := rec_get_recepient_name.person_last_name;

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

965:
966:
967: PROCEDURE NotifyForQuotePublish(
968: p_api_version IN NUMBER,
969: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
970: p_Msite_Id IN NUMBER,
971: p_quote_id IN VARCHAR2,
972: p_Req_Name IN Varchar2,
973: p_Send_Name IN Varchar2,

Line 1020: x_return_status := FND_API.g_ret_sts_success;

1016: Where RESOURCE_ID = c_resource_id;
1017:
1018: BEGIN
1019:
1020: x_return_status := FND_API.g_ret_sts_success;
1021:
1022:
1023: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1024: ibe_util.debug('Check if this notification is enabled.');

Line 1169: x_return_status := FND_API.g_ret_sts_error;

1165: End If;
1166: Exception
1167:
1168: When OTHERS Then
1169: x_return_status := FND_API.g_ret_sts_error;
1170: x_msg_count := 0;
1171:
1172: wf_core.context('ibe_workflow_pvt',
1173: 'NotifyRegistration',

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

1185: ) is
1186: L_api_name CONSTANT VARCHAR2(30) := 'Generate_Approval_Msg';
1187: L_api_version CONSTANT NUMBER := 1.0;
1188:
1189: L_quote_flag VARCHAR2(1) := fnd_api.g_true;
1190: L_tax_flag VARCHAR2(1) := fnd_api.g_true;
1191: BEGIN
1192: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1193: IBE_UTIL.DEBUG(L_api_name||':START: value of document id ='||document_id);

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

1186: L_api_name CONSTANT VARCHAR2(30) := 'Generate_Approval_Msg';
1187: L_api_version CONSTANT NUMBER := 1.0;
1188:
1189: L_quote_flag VARCHAR2(1) := fnd_api.g_true;
1190: L_tax_flag VARCHAR2(1) := fnd_api.g_true;
1191: BEGIN
1192: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1193: IBE_UTIL.DEBUG(L_api_name||':START: value of document id ='||document_id);
1194: END IF;

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

1268: */
1269:
1270: PROCEDURE NotifyRegistration (
1271: p_api_version IN NUMBER,
1272: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1273: p_first_name IN VARCHAR2,
1274: p_last_name IN VARCHAR2,
1275: p_login_name IN VARCHAR2,
1276: p_password IN VARCHAR2,

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

1306:
1307: PROCEDURE NotifyRegistration (
1308:
1309: p_api_version IN NUMBER,
1310: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1311: p_Msite_Id IN NUMBER,
1312: p_first_name IN VARCHAR2,
1313: p_last_name IN VARCHAR2,
1314: p_login_name IN VARCHAR2,

Line 1605: x_return_status := FND_API.g_ret_sts_error;

1601: End If;
1602: End If;
1603: Exception
1604: When OTHERS Then
1605: x_return_status := FND_API.g_ret_sts_error;
1606: x_msg_count := 0;
1607: wf_core.context('ibe_workflow_pvt',
1608: 'NotifyRegistration',
1609: p_login_name

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

1613:
1614: --Bug 2111316
1615: PROCEDURE NotifyForgetLogin(
1616: p_api_version IN NUMBER,
1617: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1618: p_Msite_Id IN NUMBER,
1619: p_first_name IN VARCHAR2,
1620: p_last_name IN VARCHAR2,
1621: p_login_name IN VARCHAR2,

Line 1652: x_return_status := FND_API.g_ret_sts_success;

1648: AND user_name = c_login_name;
1649:
1650: BEGIN
1651:
1652: x_return_status := FND_API.g_ret_sts_success;
1653:
1654:
1655: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1656: ibe_util.debug('Check if this notification is enabled.');

Line 1789: x_return_status := FND_API.g_ret_sts_error;

1785:
1786: EXCEPTION
1787:
1788: WHEN OTHERS THEN
1789: x_return_status := FND_API.g_ret_sts_error;
1790: x_msg_count := 0;
1791: wf_core.context('ibe_workflow_pvt', 'NotifyForgetLogin', p_login_name);
1792: raise;
1793:

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

1799: */
1800:
1801: PROCEDURE NotifyOrderStatus(
1802: p_api_version IN NUMBER,
1803: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1804: p_quote_id IN NUMBER,
1805: p_status IN VARCHAR2,
1806: p_errmsg_count IN NUMBER,
1807: p_errmsg_data IN VARCHAR2,

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

1829: END NotifyOrderStatus;
1830:
1831: PROCEDURE NotifyOrderStatus(
1832: p_api_version IN NUMBER,
1833: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1834: p_msite_id IN NUMBER,
1835: p_quote_id IN NUMBER,
1836: p_status IN VARCHAR2,
1837: p_errmsg_count IN NUMBER,

Line 1893: x_return_status := FND_API.g_ret_sts_success;

1889: WHERE msite_id = p_msite;
1890: rec_minisite_name c_minisite_name%rowtype;*/
1891:
1892: BEGIN
1893: x_return_status := FND_API.g_ret_sts_success;
1894: -- Check for WorkFlow Feature Availablity.
1895: /*for rec_minisite_name in c_minisite_name(p_msite_id) loop
1896: l_msite_name := 'Msite_name'||rec_minisite_name.msite_name;
1897: exit when c_minisite_name%notfound;

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

1940: l_this := 1;
1941: l_errmsg_data := '';
1942: WHILE ( l_this <= l_errmsg_count ) LOOP
1943: l_temp_str := null;
1944: fnd_msg_pub.Get(l_this,FND_API.G_FALSE,l_temp_str,l_next);
1945: l_errmsg_data := l_errmsg_data || TAB || TAB ||l_temp_str || NEWLINE;
1946: l_this := l_this + 1;
1947: END LOOP;
1948: END IF;

Line 2044: p_user_type => FND_API.G_MISS_CHAR,

2040: END IF;
2041:
2042: get_name_details(
2043: p_party_id => l_partyId,
2044: p_user_type => FND_API.G_MISS_CHAR,
2045: x_contact_first_name => l_first_name,
2046: x_contact_last_name => l_last_name,
2047: x_party_id => lx_party_id);
2048:

Line 2262: p_user_type => FND_API.G_MISS_CHAR,

2258:
2259: If l_msgEnabled = 'Y' Then
2260: get_name_details(
2261: p_party_id => p_sharee_partyid,
2262: p_user_type => FND_API.G_MISS_CHAR,
2263: x_contact_first_name => l_first_name,
2264: x_contact_last_name => l_last_name,
2265: x_party_id => l_partyid);
2266:

Line 2398: x_return_status := FND_API.g_ret_sts_error;

2394: End if;
2395: End If;
2396: Exception
2397: When OTHERS Then
2398: x_return_status := FND_API.g_ret_sts_error;
2399: x_msg_count := 0;
2400:
2401: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2402: IBE_UTIL.DEBUG('NotifyOrderStatus:Exception block: '||SQLCODE||': '||SQLERRM);

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

2423: *********************************************************/
2424:
2425: PROCEDURE NotifyReturnOrderStatus(
2426: p_api_version IN NUMBER,
2427: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2428: p_party_id IN NUMBER,
2429: p_order_header_id IN NUMBER,
2430: p_errmsg_count IN NUMBER,
2431: p_errmsg_data IN VARCHAR2,

Line 2460: x_return_status := FND_API.g_ret_sts_success;

2456:
2457:
2458:
2459: BEGIN
2460: x_return_status := FND_API.g_ret_sts_success;
2461:
2462:
2463: l_event_type := 'RETURNORDER';
2464:

Line 2474: l_usertype := FND_API.G_MISS_CHAR;

2470:
2471:
2472: l_notifName := 'IBE_RETURNORDERCONF';
2473: -- initialize the user type variable.
2474: l_usertype := FND_API.G_MISS_CHAR;
2475: GetUserType(l_party_id,l_usertype);
2476: l_user_name := 'HZ_PARTY:'||l_party_id;
2477:
2478: -- Call the Get_Name_details to get the party_id of the email recepient.

Line 2613: x_return_status := FND_API.g_ret_sts_error;

2609:
2610:
2611: Exception
2612: When OTHERS Then
2613: x_return_status := FND_API.g_ret_sts_error;
2614: x_msg_count := 0;
2615:
2616: wf_core.context('ibe_workflow_pvt',
2617: 'NotifyReturnOrderStatus',

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

2627: Dependinng on the user type two seperate cursors are used to retrieve contact details of B2C or B2B users*/
2628:
2629: Procedure get_contact_details_for_order(
2630: p_api_version IN NUMBER,
2631: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2632: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
2633: p_order_id IN NUMBER,
2634: x_contact_party_id OUT NOCOPY NUMBER,
2635: x_contact_first_name OUT NOCOPY VARCHAR2,

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

2628:
2629: Procedure get_contact_details_for_order(
2630: p_api_version IN NUMBER,
2631: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2632: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
2633: p_order_id IN NUMBER,
2634: x_contact_party_id OUT NOCOPY NUMBER,
2635: x_contact_first_name OUT NOCOPY VARCHAR2,
2636: x_contact_mid_name OUT NOCOPY VARCHAR2,

Line 2712: IF NOT FND_API.Compatible_API_Call(L_API_VERSION,

2708: -- Standard Start of API savepoint
2709: SAVEPOINT get_contact_details_for_order;
2710: ----DBMS_OUTPUT.PUT('Standard Start of API savepoint');
2711: -- Standard call to check for call compatibility.
2712: IF NOT FND_API.Compatible_API_Call(L_API_VERSION,
2713: p_api_version,
2714: L_API_NAME ,
2715: G_PKG_NAME )
2716: THEN

Line 2717: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2713: p_api_version,
2714: L_API_NAME ,
2715: G_PKG_NAME )
2716: THEN
2717: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2718: END IF;
2719:
2720: -- Initialize message list if p_init_msg_list is set to TRUE.
2721: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 2721: IF FND_API.To_Boolean(p_init_msg_list) THEN

2717: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2718: END IF;
2719:
2720: -- Initialize message list if p_init_msg_list is set to TRUE.
2721: IF FND_API.To_Boolean(p_init_msg_list) THEN
2722: FND_Msg_Pub.initialize;
2723: END IF;
2724:
2725: -- Initialize API return status to success

Line 2726: x_return_status := FND_API.G_RET_STS_SUCCESS;

2722: FND_Msg_Pub.initialize;
2723: END IF;
2724:
2725: -- Initialize API return status to success
2726: x_return_status := FND_API.G_RET_STS_SUCCESS;
2727: --Start of API Body
2728: ----DBMS_OUTPUT.PUT('Start of API Body');
2729: ----DBMS_OUTPUT.PUT('Order id is: '||p_order_id);
2730: FOR rec_b2c_contact in c_b2c_contact(p_order_id) LOOP

Line 2782: IF FND_API.To_Boolean(p_commit) THEN

2778: IBE_UTIL.Debug('x_contact_last_name: '||x_contact_last_name);
2779: END IF;
2780:
2781: -- Standard check of p_commit.
2782: IF FND_API.To_Boolean(p_commit) THEN
2783: COMMIT WORK;
2784: END IF;
2785:
2786: -- Standard call to get message count and if count is 1, get message info.

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

2783: COMMIT WORK;
2784: END IF;
2785:
2786: -- Standard call to get message count and if count is 1, get message info.
2787: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2788: p_count => x_msg_count ,
2789: p_data => x_msg_data);
2790: EXCEPTION
2791: WHEN FND_API.G_EXC_ERROR THEN

Line 2791: WHEN FND_API.G_EXC_ERROR THEN

2787: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2788: p_count => x_msg_count ,
2789: p_data => x_msg_data);
2790: EXCEPTION
2791: WHEN FND_API.G_EXC_ERROR THEN
2792: ROLLBACK TO get_contact_details_for_order;
2793: x_return_status := FND_API.G_RET_STS_ERROR;
2794: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2795: p_count => x_msg_count ,

Line 2793: x_return_status := FND_API.G_RET_STS_ERROR;

2789: p_data => x_msg_data);
2790: EXCEPTION
2791: WHEN FND_API.G_EXC_ERROR THEN
2792: ROLLBACK TO get_contact_details_for_order;
2793: x_return_status := FND_API.G_RET_STS_ERROR;
2794: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2795: p_count => x_msg_count ,
2796: p_data => x_msg_data);
2797: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

2790: EXCEPTION
2791: WHEN FND_API.G_EXC_ERROR THEN
2792: ROLLBACK TO get_contact_details_for_order;
2793: x_return_status := FND_API.G_RET_STS_ERROR;
2794: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2795: p_count => x_msg_count ,
2796: p_data => x_msg_data);
2797: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2798: ROLLBACK TO get_contact_details_for_order;

Line 2797: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2793: x_return_status := FND_API.G_RET_STS_ERROR;
2794: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2795: p_count => x_msg_count ,
2796: p_data => x_msg_data);
2797: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2798: ROLLBACK TO get_contact_details_for_order;
2799: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2800: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2801: p_count => x_msg_count ,

Line 2799: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2795: p_count => x_msg_count ,
2796: p_data => x_msg_data);
2797: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2798: ROLLBACK TO get_contact_details_for_order;
2799: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2800: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2801: p_count => x_msg_count ,
2802: p_data => x_msg_data);
2803: WHEN OTHERS THEN

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

2796: p_data => x_msg_data);
2797: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2798: ROLLBACK TO get_contact_details_for_order;
2799: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2800: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2801: p_count => x_msg_count ,
2802: p_data => x_msg_data);
2803: WHEN OTHERS THEN
2804: ROLLBACK TO get_contact_details_for_order;

Line 2805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2801: p_count => x_msg_count ,
2802: p_data => x_msg_data);
2803: WHEN OTHERS THEN
2804: ROLLBACK TO get_contact_details_for_order;
2805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2806: IF FND_Msg_Pub.Check_Msg_Level( FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
2807: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
2808: L_API_NAME);
2809: END IF;

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

2811: END;
2812:
2813: PROCEDURE Notify_cancel_order(
2814: p_api_version IN NUMBER,
2815: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2816: p_order_id IN NUMBER,
2817: x_return_status OUT NOCOPY VARCHAR2,
2818: x_msg_count OUT NOCOPY NUMBER,
2819: x_msg_data OUT NOCOPY VARCHAR2

Line 2850: x_return_status := FND_API.g_ret_sts_success;

2846:
2847: BEGIN
2848: --ibe_util.enable_debug;
2849: ----DBMS_OUTPUT.PUT('reday to call Notify_cancel_order');
2850: x_return_status := FND_API.g_ret_sts_success;
2851: -- Check for WorkFlow Feature Availablity.
2852: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2853: ibe_util.debug('Check if this notification is enabled.');
2854: END IF;

Line 2865: p_init_msg_list => FND_API.G_TRUE ,

2861: END IF;
2862: ----DBMS_OUTPUT.PUT('Getting the contact party id');
2863: ibe_workflow_pvt.get_contact_details_for_order
2864: (p_api_version => 1.0 ,
2865: p_init_msg_list => FND_API.G_TRUE ,
2866: p_commit => FND_API.G_FALSE ,
2867: p_order_id => p_order_id ,
2868: x_contact_party_id => l_contact_party_id,
2869: x_contact_first_name => l_contact_first_name,

Line 2866: p_commit => FND_API.G_FALSE ,

2862: ----DBMS_OUTPUT.PUT('Getting the contact party id');
2863: ibe_workflow_pvt.get_contact_details_for_order
2864: (p_api_version => 1.0 ,
2865: p_init_msg_list => FND_API.G_TRUE ,
2866: p_commit => FND_API.G_FALSE ,
2867: p_order_id => p_order_id ,
2868: x_contact_party_id => l_contact_party_id,
2869: x_contact_first_name => l_contact_first_name,
2870: x_contact_mid_name => l_contact_mid_name,

Line 2875: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

2871: x_contact_last_name => l_contact_last_name,
2872: x_return_status => x_return_status,
2873: x_msg_count => x_msg_count,
2874: x_msg_data => x_msg_data ) ;
2875: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2876: RAISE FND_API.G_EXC_ERROR;
2877: END IF;
2878:
2879: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 2876: RAISE FND_API.G_EXC_ERROR;

2872: x_return_status => x_return_status,
2873: x_msg_count => x_msg_count,
2874: x_msg_data => x_msg_data ) ;
2875: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2876: RAISE FND_API.G_EXC_ERROR;
2877: END IF;
2878:
2879: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2880: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2879: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2875: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2876: RAISE FND_API.G_EXC_ERROR;
2877: END IF;
2878:
2879: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2880: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2881: END IF;
2882: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2883: IBE_UTIL.DEBUG('Contact party_id in Notify_Cancel_Order obtained from get_contact_from_order: '||l_contact_party_id);

Line 2880: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2876: RAISE FND_API.G_EXC_ERROR;
2877: END IF;
2878:
2879: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2880: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2881: END IF;
2882: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2883: IBE_UTIL.DEBUG('Contact party_id in Notify_Cancel_Order obtained from get_contact_from_order: '||l_contact_party_id);
2884: END IF;

Line 3014: x_return_status := FND_API.g_ret_sts_error;

3010: End If;
3011: End If;
3012: Exception
3013: When OTHERS Then
3014: x_return_status := FND_API.g_ret_sts_error;
3015: x_msg_count := 0;
3016: wf_core.context('ibe_workflow_pvt',
3017: 'NotifyOrderStatus',
3018: l_event_type,

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

3028: */
3029:
3030: PROCEDURE NotifyForContractsStatus(
3031: p_api_version IN NUMBER,
3032: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3033: p_quote_id IN NUMBER,
3034: p_contract_id IN NUMBER,
3035: p_contract_status IN NUMBER,
3036: x_return_status OUT NOCOPY VARCHAR2,

Line 3069: x_return_status := FND_API.g_ret_sts_success;

3065:
3066:
3067: BEGIN
3068:
3069: x_return_status := FND_API.g_ret_sts_success;
3070:
3071:
3072: If p_contract_status = 0 then -- Approved
3073:

Line 3340: x_return_status := FND_API.g_ret_sts_error;

3336: End If;
3337: End If;
3338: Exception
3339: When OTHERS Then
3340: x_return_status := FND_API.g_ret_sts_error;
3341: x_msg_count := 0;
3342:
3343: wf_core.context('ibe_workflow_pvt',
3344: 'NotifyForContractsStatus',

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

3356:
3357:
3358: PROCEDURE NotifyForContractsChange(
3359: p_api_version IN NUMBER,
3360: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3361: p_quote_id IN NUMBER,
3362: p_contract_id IN NUMBER,
3363: p_customer_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,
3364: p_salesrep_email_id IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

3359: p_api_version IN NUMBER,
3360: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3361: p_quote_id IN NUMBER,
3362: p_contract_id IN NUMBER,
3363: p_customer_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,
3364: p_salesrep_email_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
3365: x_return_status OUT NOCOPY VARCHAR2,
3366: x_msg_count OUT NOCOPY NUMBER,
3367: x_msg_data OUT NOCOPY VARCHAR2

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

3360: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3361: p_quote_id IN NUMBER,
3362: p_contract_id IN NUMBER,
3363: p_customer_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,
3364: p_salesrep_email_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
3365: x_return_status OUT NOCOPY VARCHAR2,
3366: x_msg_count OUT NOCOPY NUMBER,
3367: x_msg_data OUT NOCOPY VARCHAR2
3368: ) IS

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

3369:
3370: Begin
3371:
3372: /*For bug 2875949*/
3373: IF (p_salesrep_email_id = fnd_api.g_miss_char) then
3374: IBE_UTIL.DEBUG('salesemail id is g miss char');
3375: return;
3376: ELSE
3377: IBE_UTIL.DEBUG('salesemail id is not g miss char, ideally call from iStore');

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

3393: End NotifyForContractsChange;
3394:
3395: PROCEDURE NotifyForContractsChange(
3396: p_api_version IN NUMBER,
3397: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3398: p_msite_id IN NUMBER,
3399: p_quote_id IN NUMBER,
3400: p_contract_id IN NUMBER,
3401: p_customer_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

3397: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3398: p_msite_id IN NUMBER,
3399: p_quote_id IN NUMBER,
3400: p_contract_id IN NUMBER,
3401: p_customer_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,
3402: p_salesrep_email_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
3403: x_return_status OUT NOCOPY VARCHAR2,
3404: x_msg_count OUT NOCOPY NUMBER,
3405: x_msg_data OUT NOCOPY VARCHAR2

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

3398: p_msite_id IN NUMBER,
3399: p_quote_id IN NUMBER,
3400: p_contract_id IN NUMBER,
3401: p_customer_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,
3402: p_salesrep_email_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
3403: x_return_status OUT NOCOPY VARCHAR2,
3404: x_msg_count OUT NOCOPY NUMBER,
3405: x_msg_data OUT NOCOPY VARCHAR2
3406: ) IS

Line 3440: x_return_status := FND_API.g_ret_sts_success;

3436: l_msgEnabled VARCHAR2(3) :='Y';
3437:
3438: BEGIN
3439:
3440: x_return_status := FND_API.g_ret_sts_success;
3441:
3442:
3443: FOR c_quote_rec In c_quote_header(p_quote_id) LOOP
3444: l_cust_adhoc_user :='HZ_PARTY:'||c_quote_rec.party_id;

Line 3766: x_return_status := FND_API.g_ret_sts_error;

3762: End If; -- if salesquote message is enabled
3763: End If; -- if salesqute is enabled
3764: Exception
3765: When OTHERS Then
3766: x_return_status := FND_API.g_ret_sts_error;
3767: x_msg_count := 0;
3768: IF(IBE_UTIL.g_debugon = l_true) THEN
3769: IBE_UTIL.DEBUG('NotifyForContractsChange:Exception: '||SQLCODE||SQLERRM);
3770: END IF;

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

3782:
3783:
3784: PROCEDURE NotifyForSalesAssistance (
3785: p_api_version IN NUMBER,
3786: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3787: p_quote_id IN NUMBER,
3788: p_customer_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,
3789: p_salesrep_email_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
3790: p_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

3784: PROCEDURE NotifyForSalesAssistance (
3785: p_api_version IN NUMBER,
3786: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3787: p_quote_id IN NUMBER,
3788: p_customer_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,
3789: p_salesrep_email_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
3790: p_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
3791: p_salesrep_user_id IN NUMBER := NULL,
3792: x_return_status OUT NOCOPY VARCHAR2,

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

3785: p_api_version IN NUMBER,
3786: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3787: p_quote_id IN NUMBER,
3788: p_customer_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,
3789: p_salesrep_email_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
3790: p_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
3791: p_salesrep_user_id IN NUMBER := NULL,
3792: x_return_status OUT NOCOPY VARCHAR2,
3793: x_msg_count OUT NOCOPY NUMBER,

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

3786: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3787: p_quote_id IN NUMBER,
3788: p_customer_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,
3789: p_salesrep_email_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
3790: p_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
3791: p_salesrep_user_id IN NUMBER := NULL,
3792: x_return_status OUT NOCOPY VARCHAR2,
3793: x_msg_count OUT NOCOPY NUMBER,
3794: x_msg_data OUT NOCOPY VARCHAR2

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

3813: End NotifyForSalesAssistance;
3814:
3815: PROCEDURE NotifyForSalesAssistance (
3816: p_api_version IN NUMBER,
3817: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3818: p_msite_id IN NUMBER,
3819: p_quote_id IN NUMBER,
3820: p_customer_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,
3821: p_salesrep_email_id IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

3816: p_api_version IN NUMBER,
3817: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3818: p_msite_id IN NUMBER,
3819: p_quote_id IN NUMBER,
3820: p_customer_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,
3821: p_salesrep_email_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
3822: p_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
3823: p_salesrep_user_id IN NUMBER := NULL,
3824: x_return_status OUT NOCOPY VARCHAR2,

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

3817: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3818: p_msite_id IN NUMBER,
3819: p_quote_id IN NUMBER,
3820: p_customer_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,
3821: p_salesrep_email_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
3822: p_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
3823: p_salesrep_user_id IN NUMBER := NULL,
3824: x_return_status OUT NOCOPY VARCHAR2,
3825: x_msg_count OUT NOCOPY NUMBER,

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

3818: p_msite_id IN NUMBER,
3819: p_quote_id IN NUMBER,
3820: p_customer_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,
3821: p_salesrep_email_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
3822: p_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
3823: p_salesrep_user_id IN NUMBER := NULL,
3824: x_return_status OUT NOCOPY VARCHAR2,
3825: x_msg_count OUT NOCOPY NUMBER,
3826: x_msg_data OUT NOCOPY VARCHAR2

Line 3909: x_return_status := FND_API.g_ret_sts_success;

3905: where user_id = FND_GLOBAL.USER_ID;
3906: rec_userenv_partyid c_userenv_partyid%rowtype;
3907:
3908: BEGIN
3909: x_return_status := FND_API.g_ret_sts_success;
3910:
3911: -- Check for WorkFlow Enable Profile
3912:
3913:

Line 3935: p_init_msg_list => FND_API.G_TRUE,

3931: 'calling Get_sales_assist_hdr_tokens');
3932: END IF;
3933: IBE_CART_NOTIFY_UTIL.Get_sales_assist_hdr_tokens (
3934: p_api_version => 1.0,
3935: p_init_msg_list => FND_API.G_TRUE,
3936: p_commit => FND_API.G_FALSE,
3937: x_return_status => l_return_status,
3938: x_msg_count => l_msg_count,
3939: x_msg_data => l_msg_data,

Line 3936: p_commit => FND_API.G_FALSE,

3932: END IF;
3933: IBE_CART_NOTIFY_UTIL.Get_sales_assist_hdr_tokens (
3934: p_api_version => 1.0,
3935: p_init_msg_list => FND_API.G_TRUE,
3936: p_commit => FND_API.G_FALSE,
3937: x_return_status => l_return_status,
3938: x_msg_count => l_msg_count,
3939: x_msg_data => l_msg_data,
3940: p_quote_header_id => p_quote_id,

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

4269: l_notification_preference :=
4270: NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_DEFAULT_USER_EMAIL_FORMAT',null,null,671), 'MAILTEXT');
4271:
4272: --Bug 2223507 start
4273: IF ( (p_salesrep_email_id is NOT NULL AND p_salesrep_email_id <> FND_API.G_MISS_CHAR) OR
4274: (p_salesrep_user_id is NOT NULL AND p_salesrep_user_id <> FND_API.G_MISS_NUM) ) THEN
4275: --Bug 2223507 end
4276:
4277: IF (( p_salesrep_email_id is NOT NULL)

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

4270: NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_DEFAULT_USER_EMAIL_FORMAT',null,null,671), 'MAILTEXT');
4271:
4272: --Bug 2223507 start
4273: IF ( (p_salesrep_email_id is NOT NULL AND p_salesrep_email_id <> FND_API.G_MISS_CHAR) OR
4274: (p_salesrep_user_id is NOT NULL AND p_salesrep_user_id <> FND_API.G_MISS_NUM) ) THEN
4275: --Bug 2223507 end
4276:
4277: IF (( p_salesrep_email_id is NOT NULL)
4278: AND (p_salesrep_email_id <> FND_API.G_MISS_CHAR)) THEN

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

4274: (p_salesrep_user_id is NOT NULL AND p_salesrep_user_id <> FND_API.G_MISS_NUM) ) THEN
4275: --Bug 2223507 end
4276:
4277: IF (( p_salesrep_email_id is NOT NULL)
4278: AND (p_salesrep_email_id <> FND_API.G_MISS_CHAR)) THEN
4279:
4280: l_sales_adhoc_user := 'IBEA'||to_char(sysdate,'MMDDYYHH24MISS')||
4281: 'Q'||p_quote_id ;
4282: l_sales_adhoc_user_display := 'IBEA'||

Line 4538: x_return_status := FND_API.g_ret_sts_error;

4534:
4535: EXCEPTION
4536:
4537: WHEN OTHERS THEN
4538: x_return_status := FND_API.g_ret_sts_error;
4539: x_msg_count := 0;
4540: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
4541: IBE_UTIL.DEBUG('NotifySalesAssist:Exception block: '||SQLCODE||': '||SQLERRM);
4542: END IF;

Line 4596: x_create_adhoc_flag := FND_API.G_TRUE;

4592: begin
4593:
4594: for rec_contact_point in c_contact_point loop
4595: if rec_contact_point.owner_table_name = 'IBE_SH_QUOTE_ACCESS' then
4596: x_create_adhoc_flag := FND_API.G_TRUE;
4597: end if;
4598: exit when c_contact_point%notfound;
4599: end loop;
4600:

Line 4644: l_usertype Varchar2(30) := FND_API.G_MISS_CHAR;

4640: x_partyid HZ_PARTIES.PARTY_ID%TYPE;
4641: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
4642: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
4643: l_user_name WF_USERS.NAME%TYPE;
4644: l_usertype Varchar2(30) := FND_API.G_MISS_CHAR;
4645: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE;
4646: l_quote_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;
4647: l_quote_Num ASO_QUOTE_HEADERS_ALL.QUOTE_NUMBER%TYPE;
4648: l_quote_ver ASO_QUOTE_HEADERS_ALL.QUOTE_VERSION%TYPE;

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

4647: l_quote_Num ASO_QUOTE_HEADERS_ALL.QUOTE_NUMBER%TYPE;
4648: l_quote_ver ASO_QUOTE_HEADERS_ALL.QUOTE_VERSION%TYPE;
4649: l_msite_name IBE_MSITES_VL.MSITE_NAME%TYPE;
4650: l_cart_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;
4651: l_is_it_quote VARCHAR2(1) := FND_API.G_FALSE;
4652: x_contact_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
4653: x_contact_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
4654: l_recip_name Varchar2(2000);
4655:

Line 4678: x_return_status := FND_API.g_ret_sts_success;

4674: rec_get_recip_name c_get_recip_name%rowtype;
4675:
4676:
4677: BEGIN
4678: x_return_status := FND_API.g_ret_sts_success;
4679:
4680:
4681: identify_cart_quote(p_quote_header_id => p_Quote_Header_id,
4682: x_is_it_quote => l_is_it_quote);

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

4696: ibe_util.debug('Notify_end_working: Notification enabled: '||l_notifEnabled);
4697: END IF;
4698:
4699: IF l_notifEnabled = 'Y' THEN
4700: -- IF (p_quote_header_id is not null) or (p_quote_header_id <> fnd_api.g_miss_num) THEN
4701: FOR c_quote_rec In c_quote_header(p_Quote_Header_id) LOOP
4702: l_user_name :='HZ_PARTY:'||c_quote_rec.party_id;
4703: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
4704: ibe_util.debug('Notify_end_working: I_user_name: '||l_user_name);

Line 4740: l_usertype := FND_API.G_MISS_CHAR;

4736: ibe_util.debug('Notify_end_working:l_msgenabled: '||l_msgEnabled);
4737: END IF;
4738:
4739: IF l_msgEnabled = 'Y' THEN
4740: l_usertype := FND_API.G_MISS_CHAR;
4741: x_contact_first_name := NULL;
4742: x_contact_last_name := NULL;
4743: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
4744: ibe_util.debug('Notify_end_working:querying recipient_name');

Line 4798: x_return_status := FND_API.g_ret_sts_error;

4794: END IF; --l_notifenabled
4795: EXCEPTION
4796:
4797: WHEN OTHERS THEN
4798: x_return_status := FND_API.g_ret_sts_error;
4799: x_msg_count := 0;
4800: wf_core.context('IBE_WORKFLOW_PVT',l_notifname,l_messagename,p_quote_header_id);
4801: RAISE;
4802:

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

4824: p_quote_access_rec IN IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_REC_TYPE, --of the recepient
4825: p_minisite_id IN NUMBER,
4826: p_url IN VARCHAR2,
4827: p_context_code IN VARCHAR2,
4828: p_shared_by_partyid IN NUMBER := FND_API.G_MISS_NUM,
4829: p_notes IN VARCHAR2,
4830: x_return_status OUT NOCOPY VARCHAR2,
4831: x_msg_count OUT NOCOPY NUMBER,
4832: x_msg_data OUT NOCOPY VARCHAR2

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

4844: l_user_name WF_USERS.NAME%TYPE;
4845: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE ;
4846: l_msite_name IBE_MSITES_VL.MSITE_NAME%TYPE;
4847: l_cart_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;
4848: l_is_it_quote VARCHAR2(1) := FND_API.G_FALSE;
4849:
4850: l_sharedby_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
4851: l_sharedby_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
4852: l_owner_partyid HZ_PARTIES.PARTY_ID%TYPE;

Line 4880: x_return_status := FND_API.g_ret_sts_success ;

4876: rec_get_context_msg C_CONTEXT_CODE%ROWTYPE;*/
4877:
4878:
4879: BEGIN
4880: x_return_status := FND_API.g_ret_sts_success ;
4881:
4882: l_notification_preference := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_DEFAULT_USER_EMAIL_FORMAT',null,null,671), 'MAILTEXT');
4883:
4884:

Line 4931: l_usertype := FND_API.G_MISS_CHAR;

4927: IBE_UTIL.DEBUG('Notify_finish_sharing:Owner cart name: '||l_cart_name);
4928: END IF;
4929: END LOOP;
4930:
4931: l_usertype := FND_API.G_MISS_CHAR;
4932: l_sharedby_first_name := NULL;
4933: l_sharedby_last_name := NULL;
4934: Get_Name_details(p_party_id => p_shared_by_partyid,
4935: p_user_type => l_UserType,

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

4953: p_contact_point_id => p_quote_access_rec.contact_point_id,
4954: x_create_adhoc_flag => l_create_adhoc_flag);
4955:
4956:
4957: IF (l_create_adhoc_flag = FND_API.G_TRUE) THEN
4958: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
4959: IBE_UTIL.DEBUG('Notify_finish_sharing:l_create_adhoc_flag: '||l_create_adhoc_flag);
4960: END IF;
4961:

Line 5041: x_return_status := FND_API.g_ret_sts_error;

5037: END IF; --l_notif enabled
5038: EXCEPTION
5039:
5040: WHEN OTHERS THEN
5041: x_return_status := FND_API.g_ret_sts_error;
5042: x_msg_count := 0;
5043: wf_core.context('IBE_WORKFLOW_PVT',l_notifName,l_notifName);
5044: RAISE;
5045:

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

5059: p_init_msg_list IN VARCHAR2,
5060: p_quote_access_rec IN IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_REC_TYPE, --of the recepient
5061: p_minisite_id IN NUMBER,
5062: p_url IN VARCHAR2,
5063: p_shared_by_party_id IN NUMBER := FND_API.G_MISS_NUM,
5064: p_notes IN VARCHAR2,
5065: x_return_status OUT NOCOPY VARCHAR2,
5066: x_msg_count OUT NOCOPY NUMBER,
5067: x_msg_data OUT NOCOPY VARCHAR2

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

5079: l_user_name WF_USERS.NAME%TYPE;
5080: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE ;
5081: l_msite_name IBE_MSITES_VL.MSITE_NAME%TYPE;
5082: l_cart_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;
5083: l_is_it_quote VARCHAR2(1) := FND_API.G_FALSE;
5084:
5085: l_sharedby_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
5086: l_sharedby_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
5087: l_owner_partyid HZ_PARTIES.PARTY_ID%TYPE;

Line 5107: x_return_status := FND_API.g_ret_sts_success ;

5103: l_temp_update_str VARCHAR2(1000);
5104:
5105:
5106: BEGIN
5107: x_return_status := FND_API.g_ret_sts_success ;
5108:
5109: l_notification_preference := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_DEFAULT_USER_EMAIL_FORMAT',null,null,671), 'MAILTEXT');
5110:
5111: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

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

5116: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5117: IBE_UTIL.DEBUG('Notify_shared_cart:Determining party_type');
5118: END IF;
5119: IF ((p_quote_access_rec.party_id is null )
5120: OR (p_quote_access_rec.party_id = FND_API.G_MISS_NUM)) THEN
5121:
5122: l_usertype := 'IBE_INDIVIDUAL';
5123:
5124: ELSE

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

5194: IBE_UTIL.DEBUG('Notify_shared_cart:l_create_adhoc_flag: '||l_create_adhoc_flag);
5195: END IF;
5196:
5197: --if create adhoc user flag is "true" then call wf_directory API
5198: IF (l_create_adhoc_flag = FND_API.G_TRUE) THEN
5199: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5200: IBE_UTIL.DEBUG('Notify_shared_cart:l_create_adhoc_flag is true');
5201: IBE_UTIL.DEBUG('Notify_shared_cart:p_quote_access_rec.QUOTE_SHAREE_ID: '||p_quote_access_rec.QUOTE_SHAREE_ID);
5202: IBE_UTIL.DEBUG('Notify_shared_cart:p_quote_access_rec.quote_header_id: '||p_quote_access_rec.quote_header_id);

Line 5293: x_return_status := FND_API.g_ret_sts_error;

5289: END IF; -- l_notifenabled
5290: EXCEPTION
5291:
5292: WHEN OTHERS THEN
5293: x_return_status := FND_API.g_ret_sts_error;
5294: x_msg_count := 0;
5295: wf_core.context('IBE_WORKFLOW_PVT',l_notifName,l_notifName);
5296: RAISE;
5297:

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

5313: p_quote_access_rec IN IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_REC_TYPE, --of the recepient
5314: p_minisite_id IN NUMBER,
5315: p_url IN VARCHAR2,
5316: p_old_accesslevel IN VARCHAR2,
5317: p_shared_by_party_id IN NUMBER := FND_API.G_MISS_NUM,
5318: p_notes IN VARCHAR2,
5319: x_return_status OUT NOCOPY VARCHAR2,
5320: x_msg_count OUT NOCOPY NUMBER,
5321: x_msg_data OUT NOCOPY VARCHAR2

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

5333: l_user_name WF_USERS.NAME%TYPE;
5334: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE ;
5335: l_msite_name IBE_MSITES_VL.MSITE_NAME%TYPE;
5336: l_cart_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;
5337: l_is_it_quote varchar2(1) := FND_API.G_FALSE;
5338:
5339: l_sharedby_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
5340: l_sharedby_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
5341: l_owner_partyid HZ_PARTIES.PARTY_ID%TYPE;

Line 5369: x_return_status := FND_API.g_ret_sts_success ;

5365:
5366: rec_get_email c_get_email%rowtype;
5367:
5368: BEGIN
5369: x_return_status := FND_API.g_ret_sts_success ;
5370:
5371: l_notification_preference := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_DEFAULT_USER_EMAIL_FORMAT',null,null,671), 'MAILTEXT');
5372: l_quote_access_rec := p_quote_access_rec;
5373:

Line 5404: l_usertype := FND_API.G_MISS_CHAR;

5400: l_orgid := c_quote_rec.org_id;
5401: l_cart_name := c_quote_rec.quote_name; -- cart name
5402: END LOOP;
5403:
5404: l_usertype := FND_API.G_MISS_CHAR;
5405: l_sharedby_first_name := NULL;
5406: l_sharedby_last_name := NULL;
5407: Get_Name_details(p_party_id => p_shared_by_party_id,
5408: p_user_type => l_UserType,

Line 5417: l_usertype := FND_API.G_MISS_CHAR;

5413: -- Now identify whether the recepient is B2B or B2C ****
5414: -- Call the Get_Name_details to get the party_id of the recepient.
5415: -- And pipe it with HZ_PARTIES to get email id of the recepient.
5416:
5417: l_usertype := FND_API.G_MISS_CHAR;
5418: x_recepient_party_id := 0;
5419: Get_Name_details(p_party_id => l_quote_access_rec.party_id,
5420: p_user_type => l_UserType,
5421: x_contact_first_name => l_recepient_first_name,

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

5440:
5441: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5442: IBE_UTIL.DEBUG('Notify_access_change:l_create_adhoc_flag: '||l_create_adhoc_flag);
5443: END IF;
5444: IF (l_create_adhoc_flag = FND_API.G_TRUE) THEN
5445:
5446: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5447: IBE_UTIL.DEBUG('Notify_access_change:Opening c_get_email');
5448: END IF;

Line 5506: l_temp_update_str := FND_API.G_MISS_CHAR;

5502: END IF;
5503:
5504: -- Retrieve the message text for update message from fnd_messages
5505: fnd_message.set_name('IBE','IBE_PRMT_UPDATE_CART');
5506: l_temp_update_str := FND_API.G_MISS_CHAR;
5507: l_temp_update_str := fnd_message.get;
5508: --l_msgEnabled := 'Y';
5509: IF l_msgEnabled = 'Y' THEN
5510: l_url := p_url;

Line 5539: x_return_status := FND_API.g_ret_sts_error;

5535: END IF; --l_notifenabled
5536: EXCEPTION
5537:
5538: WHEN OTHERS THEN
5539: x_return_status := FND_API.g_ret_sts_error;
5540: x_msg_count := 0;
5541: wf_core.context('IBE_WORKFLOW_PVT',l_notifName,l_notifName);
5542: RAISE;
5543:

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

5550: p_minisite_id IN NUMBER,
5551: p_url IN VARCHAR2,
5552: p_sent_by_party_id IN NUMBER ,
5553: p_notes IN VARCHAR2,
5554: p_owner_party_id IN NUMBER := FND_API.G_MISS_NUM,
5555: x_return_status OUT NOCOPY VARCHAR2,
5556: x_msg_count OUT NOCOPY NUMBER,
5557: x_msg_data OUT NOCOPY VARCHAR2
5558: ) is

Line 5598: x_return_status := FND_API.g_ret_sts_success ;

5594:
5595: l_notif_name VARCHAR2(1000) := 'IBE_VIEWSHAREDCART';
5596: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE;
5597: BEGIN
5598: x_return_status := FND_API.g_ret_sts_success ;
5599: IBE_UTIL.DEBUG('Notify_view_shared_cart: START');
5600:
5601: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5602: ibe_util.debug('Check if this notification is enabled.');

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

5612: p_contact_point_id => p_quote_access_rec.contact_point_id,
5613: x_create_adhoc_flag => l_create_adhoc_flag);
5614:
5615:
5616: IF (l_create_adhoc_flag = FND_API.G_TRUE) THEN
5617: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5618: IBE_UTIL.DEBUG('Notify_view_shared_cart:l_create_adhoc_flag: '||l_create_adhoc_flag);
5619: END IF;
5620:

Line 5656: p_user_type => FND_API.G_MISS_CHAR,

5652: IBE_UTIL.DEBUG('Notify_view_shared_cart:p_quote_access_rec.party_id '||p_quote_access_rec.party_id);
5653: END IF;
5654:
5655: Get_Name_details(p_party_id => p_sent_by_party_id,
5656: p_user_type => FND_API.G_MISS_CHAR,
5657: x_contact_first_name => l_sent_by_first_name,
5658: x_contact_last_name => l_sent_by_last_name,
5659: x_party_id => l_sent_by_party_id);
5660:

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

5670:
5671: getusertype(p_quote_access_rec.party_id, l_user_type);
5672:
5673: IF ((p_owner_party_id is not null ) AND
5674: (p_owner_party_id <> FND_API.G_MISS_NUM)) THEN
5675: l_url := p_url;
5676: l_access_code :='O';
5677: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5678: IBE_UTIL.DEBUG('Notify_view_shared_cart:l_access_code '||l_access_code);

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

5709: END IF;
5710:
5711: IF l_msg_Enabled = 'Y' THEN
5712: IF (p_quote_access_rec.Quote_sharee_number is not null AND
5713: p_quote_access_rec.Quote_sharee_number <> FND_API.G_MISS_NUM) THEN
5714: l_item_key := l_event_type||'-'||to_char(sysdate,'MMDDYYHH24MISS')||'-'||p_quote_access_rec.Quote_Header_id
5715: ||p_quote_access_rec.Quote_sharee_number;
5716: ELSE
5717: l_item_key := l_event_type||'-'||to_char(sysdate,'MMDDYYHH24MISS')||'-'||p_quote_access_rec.Quote_Header_id;

Line 5837: x_return_status := FND_API.g_ret_sts_error;

5833: END IF;
5834: EXCEPTION
5835:
5836: WHEN OTHERS THEN
5837: x_return_status := FND_API.g_ret_sts_error;
5838: x_msg_count := 0;
5839: --wf_core.context('IBE_WORKFLOW_PVT',l_notifName,l_notifName);
5840: RAISE;
5841:

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

5845: ------------------------------------------------------------------------
5846:
5847: PROCEDURE NotifyForSharedCart (
5848: p_api_version IN NUMBER,
5849: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
5850: p_Quote_Header_id IN NUMBER,
5851: p_emailAddress IN VARCHAR2,
5852: p_quoteShareeNum IN NUMBER,
5853: p_privilegeType IN VARCHAR2,

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

5851: p_emailAddress IN VARCHAR2,
5852: p_quoteShareeNum IN NUMBER,
5853: p_privilegeType IN VARCHAR2,
5854: p_url IN VARCHAR2,
5855: p_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,
5856: x_return_status OUT NOCOPY VARCHAR2,
5857: x_msg_count OUT NOCOPY NUMBER,
5858: x_msg_data OUT NOCOPY VARCHAR2
5859: ) IS

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

5880:
5881:
5882: PROCEDURE NotifyForSharedCart (
5883: p_api_version IN NUMBER,
5884: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
5885: p_Msite_id IN NUMBER,
5886: p_Quote_Header_id IN NUMBER,
5887: p_emailAddress IN VARCHAR2,
5888: p_quoteShareeNum IN NUMBER,

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

5887: p_emailAddress IN VARCHAR2,
5888: p_quoteShareeNum IN NUMBER,
5889: p_privilegeType IN VARCHAR2,
5890: p_url IN VARCHAR2,
5891: p_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,
5892: x_return_status OUT NOCOPY VARCHAR2,
5893: x_msg_count OUT NOCOPY NUMBER,
5894: x_msg_data OUT NOCOPY VARCHAR2
5895: ) IS

Line 5925: x_return_status := FND_API.g_ret_sts_success;

5921: l_last_name_sc VARCHAR2(360);
5922: l_dummy_document_type VARCHAR2(200);
5923:
5924: BEGIN
5925: x_return_status := FND_API.g_ret_sts_success;
5926:
5927: -- Check for WorkFlow Feature Availablity.
5928: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5929: ibe_util.debug('Check if this notification is enabled.');

Line 6127: x_return_status := FND_API.g_ret_sts_error;

6123: End If;
6124: Exception
6125:
6126: When OTHERS Then
6127: x_return_status := FND_API.g_ret_sts_error;
6128: x_msg_count := 0;
6129: wf_core.context('ibe_workflow_pvt','SHAREDCART','SHAREDCART');
6130: raise;
6131: End NotifyForSharedCart;

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

7066: l_amt_format Varchar2(50);
7067: l_curr_sym FND_CURRENCIES.SYMBOL%TYPE;
7068: l_temp_str VARCHAR2(2000):='';
7069: l_view_net_price_flag VARCHAR2(1);
7070: l_view_line_type_flag VARCHAR2(1) := FND_API.G_FALSE;
7071: Cursor c_ship_flag(p_line_id NUMBER) IS
7072: SELECT msi.shippable_item_flag
7073: FROM oe_order_lines_all line,
7074: OE_SYSTEM_PARAMETERS_ALL osp,

Line 7345: l_view_line_type_flag := FND_API.G_TRUE;

7341: Open c_get_source_code(l_quote_id);
7342: FETCH c_get_source_code into l_quote_source_code;
7343: Close c_get_source_code;
7344: if (l_quote_source_code = 'IStore InstallBase') then
7345: l_view_line_type_flag := FND_API.G_TRUE;
7346: end if;
7347:
7348: For g_quote_header_rec In c_quote_header(l_quote_id) Loop
7349: l_amt_format := FND_CURRENCY.GET_FORMAT_MASK(g_quote_header_rec.currency_code,18);

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

7366: --Get Display Option class profile value
7367: l_displayOptionClass := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_DISPLAY_OPTION_CLASSES',null,null,671), 'Y');
7368: l_displayUnchangedItem := NVL( FND_PROFILE.VALUE_SPECIFIC('CZ_OUTPUT_IB_UNCHD_CHILD_ITEMS',null,null,671), 'Y');
7369:
7370: IF(p_quote_flag = fnd_api.g_true) then
7371: FOR g_notif_quote_line_rec IN c_get_top_quote_lines(l_quote_id) LOOP
7372: if(g_notif_quote_line_rec.config_instance_name is not null) then
7373: notif_line_tbl(l_index).Product := g_notif_quote_line_rec.description||':'||g_notif_quote_line_rec.config_instance_name;
7374: else

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

7406: l_index := l_index+1;
7407: END IF;--Hide Option class and Unchanged Lines
7408: end loop;
7409: end if;
7410: notif_line_tbl(l_index-1).LastItem := FND_API.G_TRUE;
7411: EXIT WHEN c_get_top_quote_lines%NOTFOUND;
7412: END LOOP;
7413: l_document := buildDocument(notif_line_tbl,l_view_net_price_flag,l_view_line_type_flag,p_tax_flag);
7414: --Order details content generation

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

7411: EXIT WHEN c_get_top_quote_lines%NOTFOUND;
7412: END LOOP;
7413: l_document := buildDocument(notif_line_tbl,l_view_net_price_flag,l_view_line_type_flag,p_tax_flag);
7414: --Order details content generation
7415: Elsif(p_quote_flag = fnd_api.g_false) then
7416: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
7417: IBE_UTIL.debug('p_quote_flag is false, entering the order area');
7418: END IF;
7419: --Begin New Order Generate Detail

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

7467: notif_line_tbl(l_index).NetAmount := notif_line_tbl(l_index).NetAmount + g_notif_config_orderline_rec.lines_total;
7468: notif_line_tbl(l_index).TaxAmount := notif_line_tbl(l_index).NetAmount + g_notif_config_orderline_rec.lines_total;
7469: END LOOP;
7470: end if;
7471: notif_line_tbl(l_index-1).LastItem := FND_API.G_TRUE;
7472: END LOOP;
7473: --End New Order Generate Detail
7474: l_document := buildDocument(notif_line_tbl,l_view_net_price_flag,l_view_line_type_flag,p_tax_flag);
7475: END IF; --for l_quote_flag

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

7802: l_document := l_document ||NEWLINE;
7803: END IF;
7804: END IF;
7805: END LOOP;
7806: IF (l_view_net_price_flag = 'Y' and p_tax_flag = fnd_api.g_true) THEN
7807: fnd_message.set_name('IBE','IBE_PRMT_ORD_TAX');
7808: l_temp_str := null;
7809: l_temp_str := fnd_message.get;
7810: IF (to_char(ord_detail_tbl(i).taxes_total) is not null) THEN

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

7839: ) is
7840: L_api_name CONSTANT VARCHAR2(30) := 'Generate_order_Detail_wtax';
7841: L_api_version CONSTANT NUMBER := 1.0;
7842:
7843: L_quote_flag VARCHAR2(1) := fnd_api.g_false;
7844: L_tax_flag VARCHAR2(1) := fnd_api.g_true;
7845: BEGIN
7846: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
7847: IBE_UTIL.DEBUG('Generate_order_Detail_wtax:START');

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

7840: L_api_name CONSTANT VARCHAR2(30) := 'Generate_order_Detail_wtax';
7841: L_api_version CONSTANT NUMBER := 1.0;
7842:
7843: L_quote_flag VARCHAR2(1) := fnd_api.g_false;
7844: L_tax_flag VARCHAR2(1) := fnd_api.g_true;
7845: BEGIN
7846: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
7847: IBE_UTIL.DEBUG('Generate_order_Detail_wtax:START');
7848: END IF;

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

7887: document_type IN OUT NOCOPY VARCHAR2
7888: ) is
7889: l_api_name CONSTANT VARCHAR2(30) := 'Generate_rtn_ord_Detail_wtax';
7890: l_api_version CONSTANT NUMBER := 1.0;
7891: l_tax_flag VARCHAR2(1) := fnd_api.g_true;
7892:
7893: BEGIN
7894:
7895: ibe_workflow_pvt.GenerateReturnDetail(

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

7923: ) is
7924: L_api_name CONSTANT VARCHAR2(30) := 'Generate_quote_Detail_wtax';
7925: L_api_version CONSTANT NUMBER := 1.0;
7926:
7927: L_quote_flag VARCHAR2(1) := fnd_api.g_true;
7928: L_tax_flag VARCHAR2(1) := fnd_api.g_true;
7929: BEGIN
7930: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
7931: IBE_UTIL.DEBUG('Generate_quote_Detail_wtax:START');

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

7924: L_api_name CONSTANT VARCHAR2(30) := 'Generate_quote_Detail_wtax';
7925: L_api_version CONSTANT NUMBER := 1.0;
7926:
7927: L_quote_flag VARCHAR2(1) := fnd_api.g_true;
7928: L_tax_flag VARCHAR2(1) := fnd_api.g_true;
7929: BEGIN
7930: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
7931: IBE_UTIL.DEBUG('Generate_quote_Detail_wtax:START');
7932: END IF;

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

7959: ) is
7960: L_api_name CONSTANT VARCHAR2(30) := 'Generate_order_Detail_notax';
7961: L_api_version CONSTANT NUMBER := 1.0;
7962:
7963: L_quote_flag VARCHAR2(1) := fnd_api.g_false;
7964: L_tax_flag VARCHAR2(1) := fnd_api.g_false;
7965: BEGIN
7966: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
7967: IBE_UTIL.DEBUG('Generate_order_Detail_notax:START');

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

7960: L_api_name CONSTANT VARCHAR2(30) := 'Generate_order_Detail_notax';
7961: L_api_version CONSTANT NUMBER := 1.0;
7962:
7963: L_quote_flag VARCHAR2(1) := fnd_api.g_false;
7964: L_tax_flag VARCHAR2(1) := fnd_api.g_false;
7965: BEGIN
7966: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
7967: IBE_UTIL.DEBUG('Generate_order_Detail_notax:START');
7968: END IF;

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

8008: document_type IN OUT NOCOPY VARCHAR2
8009: ) is
8010: l_api_name CONSTANT VARCHAR2(30) := 'Generate_rtn_ord_Detail_notax';
8011: l_api_version CONSTANT NUMBER := 1.0;
8012: l_tax_flag VARCHAR2(1) := fnd_api.g_false;
8013:
8014: BEGIN
8015:
8016: ibe_workflow_pvt.GenerateReturnDetail(

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

8044: ) is
8045: L_api_name CONSTANT VARCHAR2(30) := 'Generate_quote_Detail_notax';
8046: L_api_version CONSTANT NUMBER := 1.0;
8047:
8048: L_quote_flag VARCHAR2(1) := fnd_api.g_true;
8049: L_tax_flag VARCHAR2(1) := fnd_api.g_false;
8050: BEGIN
8051: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
8052: IBE_UTIL.DEBUG('Generate_order_Detail_notax:START');

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

8045: L_api_name CONSTANT VARCHAR2(30) := 'Generate_quote_Detail_notax';
8046: L_api_version CONSTANT NUMBER := 1.0;
8047:
8048: L_quote_flag VARCHAR2(1) := fnd_api.g_true;
8049: L_tax_flag VARCHAR2(1) := fnd_api.g_false;
8050: BEGIN
8051: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
8052: IBE_UTIL.DEBUG('Generate_order_Detail_notax:START');
8053: END IF;

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

10166: l_curr_sym := g_curr_sym;
10167: l_amt_format := g_amt_format;
10168: for counter in 1..notif_line_tbl.count loop
10169: l_space_len := 56;
10170: if(view_line_type_flag = fnd_api.g_true) then
10171: if(Notif_Line_Tbl(counter).Action is not null AND Notif_Line_Tbl(counter).Action <> FND_API.G_MISS_CHAR) then
10172: ldocument := ldocument || rpad(Notif_Line_Tbl(counter).Action,9,' ')||' ';
10173: else
10174: ldocument := ldocument || lpad(' ',9)||' ';

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

10167: l_amt_format := g_amt_format;
10168: for counter in 1..notif_line_tbl.count loop
10169: l_space_len := 56;
10170: if(view_line_type_flag = fnd_api.g_true) then
10171: if(Notif_Line_Tbl(counter).Action is not null AND Notif_Line_Tbl(counter).Action <> FND_API.G_MISS_CHAR) then
10172: ldocument := ldocument || rpad(Notif_Line_Tbl(counter).Action,9,' ')||' ';
10173: else
10174: ldocument := ldocument || lpad(' ',9)||' ';
10175: end if;

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

10182: p_string_left => l_string_left);
10183: ldocument := ldocument || rpad(l_string_out,28)||' ';
10184: ldocument := ldocument || lpad(trim(Notif_Line_Tbl(counter).UOM),8)||' ';
10185: ldocument := ldocument || lpad(trim(Notif_Line_Tbl(counter).Quantity),7)||' ';
10186: if(view_line_type_flag <> fnd_api.g_true) then
10187: ldocument := ldocument || lpad(trim(Notif_Line_Tbl(counter).Shippable),9)||' ';
10188: end if;
10189: if(view_net_price_flag = 'Y') then
10190: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(Notif_Line_Tbl(counter).NetAmount));

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

10192: end if;
10193: ldocument := ldocument ||NEWLINE;
10194: l_string_in := l_string_left;
10195: if(length(l_string_in) > 0) THEN
10196: if(view_line_type_flag = fnd_api.g_true) then
10197: ldocument := ldocument || rpad(' ',9)||' ';
10198: end if;
10199: parseString
10200: (p_string_in => l_string_in,

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

10201: p_string_len => 28,
10202: p_string_out => l_string_out,
10203: p_string_left => l_string_left);
10204: ldocument := ldocument || rpad(trim(l_string_out),28)||' ';
10205: if(view_line_type_flag = fnd_api.g_true) then
10206: l_space_len := l_space_len - 39;
10207: else
10208: l_space_len := l_space_len - 29;
10209: end if;

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

10224: parseString(l_string_in,28,l_string_out,l_string_left);
10225: ldocument := ldocument || rpad(trim(l_string_out),28) ||NEWLINE;
10226: l_string_in := l_string_left;
10227: END LOOP;
10228: IF(tax_flag = fnd_api.g_true) then
10229: IF view_net_price_flag = 'Y' THEN
10230: fnd_message.set_name('IBE','IBE_PRMT_ORD_TAX');
10231: l_temp_str := null;
10232: l_temp_str := fnd_message.get;

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

10234: ldocument := ldocument ||lpad(l_temp_str||': '||l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),72,' ')||NEWLINE;
10235: END IF;
10236: END IF;
10237:
10238: IF (FND_API.To_Boolean(Notif_Line_Tbl(counter).LastItem) and counter <> Notif_Line_Tbl.count) THEN
10239: ldocument := ldocument || '------------------------------------------------------------------------'||NEWLINE;
10240: END IF;
10241: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
10242: IBE_UTIL.DEBUG('Going to print ldocument in buildDocument'||ldocument);