603: close c_get_party_id;
604: END IF;
605:
606: -- Get the First Name and Last Name for the derived party id.
607: -- Call ibe_workflow_pvt.get_name_details.
608: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
609: IBE_Util.Debug('Before calling get_name_details, partyId = '||l_party_id);
610: END IF;
611:
609: IBE_Util.Debug('Before calling get_name_details, partyId = '||l_party_id);
610: END IF;
611:
612: IF (l_party_id is not null) THEN
613: IBE_WORKFLOW_PVT.get_name_details(
614: p_party_id => l_party_id,
615: p_user_type => FND_API.G_MISS_CHAR,
616: x_contact_first_name => l_person_first_name,
617: x_contact_last_name => l_person_last_name,
918:
919: IF p_reason_code <> FND_API.G_MISS_CHAR
920: AND p_reason_code IS NOT NULL THEN
921: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
922: IBE_Util.Debug('IBE_Workflow_Pvt.NotifyForSalesAssistance() starts');
923: END IF;
924:
925: IBE_Workflow_Pvt.NotifyForSalesAssistance(
926: p_api_version => p_api_version_number
921: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
922: IBE_Util.Debug('IBE_Workflow_Pvt.NotifyForSalesAssistance() starts');
923: END IF;
924:
925: IBE_Workflow_Pvt.NotifyForSalesAssistance(
926: p_api_version => p_api_version_number
927: ,p_init_msg_list => FND_API.G_TRUE
928: ,p_quote_id => l_qte_header_rec.quote_header_id
929: ,p_customer_comments => p_customer_comments
933: ,x_msg_count => x_msg_count
934: ,x_msg_data => x_msg_data);
935:
936: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
937: IBE_Util.Debug('IBE_Workflow_Pvt.NotifyForSalesAssistance() finishes');
938: END IF;
939: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
940: RAISE FND_API.G_EXC_ERROR;
941: END IF;
966: END IF;
967: IF(l_current_state NOT IN (2,3,4,5)) THEN
968:
969: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
970: IBE_Util.Debug('IBE_Workflow_Pvt.NotifyOrderStatus() starts');
971: END IF;
972: /*This part is a fix for sending notifications to sharee*/
973: IF (p_sharee_party_id = fnd_api.g_miss_num OR p_sharee_party_id IS NULL) THEN
974: IBE_Workflow_Pvt.NotifyOrderStatus(
970: IBE_Util.Debug('IBE_Workflow_Pvt.NotifyOrderStatus() starts');
971: END IF;
972: /*This part is a fix for sending notifications to sharee*/
973: IF (p_sharee_party_id = fnd_api.g_miss_num OR p_sharee_party_id IS NULL) THEN
974: IBE_Workflow_Pvt.NotifyOrderStatus(
975: p_api_version => p_api_version_number
976: ,p_init_msg_list => FND_API.G_TRUE
977: ,p_quote_id => l_qte_header_rec.quote_header_id
978: ,p_status => l_return_status
983: ,x_msg_data => x_msg_data);
984:
985: ELSE
986: /*Sharee is present*/
987: IBE_Workflow_Pvt.NotifyOrderStatus(
988: p_api_version => p_api_version_number
989: ,p_init_msg_list => FND_API.G_TRUE
990: ,p_quote_id => l_qte_header_rec.quote_header_id
991: ,p_status => l_return_status
999: END IF;
1000:
1001: /* Book Order Error - Enter Order Success should notify user */
1002: IF (l_return_status = 'E' and x_return_status = 'S') THEN
1003: IBE_Workflow_Pvt.NotifyOrderStatus(
1004: p_api_version => p_api_version_number
1005: ,p_init_msg_list => FND_API.G_TRUE
1006: ,p_quote_id => l_qte_header_rec.quote_header_id
1007: ,p_status => 'S'
1014:
1015:
1016: END IF;--for l_current_state(HA)
1017: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1018: IBE_Util.Debug('IBE_Workflow_Pvt.NotifyOrderStatus() finishes');
1019: END IF;
1020: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1021: RAISE FND_API.G_EXC_ERROR;
1022: END IF;