eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ASO_DEAL_PUB dependencies on ASO_DEAL_PUB

Line 1: PACKAGE BODY ASO_DEAL_PUB as

1: PACKAGE BODY ASO_DEAL_PUB as
2: /* $Header: asoidmib.pls 120.9 2008/07/11 10:08:01 rassharm noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'ASO_DEAL_PUB';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'asoidmib.pls';

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'ASO_DEAL_PUB';

1: PACKAGE BODY ASO_DEAL_PUB as
2: /* $Header: asoidmib.pls 120.9 2008/07/11 10:08:01 rassharm noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'ASO_DEAL_PUB';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'asoidmib.pls';
6:
7:
8: -- Start of Comments

Line 9: -- Package name : ASO_DEAL_PUB

5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'asoidmib.pls';
6:
7:
8: -- Start of Comments
9: -- Package name : ASO_DEAL_PUB
10: -- Purpose : API methods for implementing Deal Management Integration
11: -- End of Comments
12:
13:

Line 203: aso_debug_pub.add('ASO_DEAL_PUB: Start of Update_Quote_From_Deal API ', 1, 'Y');

199: end if;
200:
201: --pp_debug('In update deal'|| aso_debug_pub.g_debug_flag);
202: IF aso_debug_pub.g_debug_flag = 'Y' then
203: aso_debug_pub.add('ASO_DEAL_PUB: ****** Start of Update_Quote_From_Deal API ******', 1, 'Y');
204: END IF;
205:
206: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
207: 1.0,

Line 240: aso_debug_pub.add('ASO_DEAL_PUB: Access Level'||l_access_level, 1, 'Y');

236: --pp_debug('in first if'||p_event);
237: l_access_level := ASO_SECURITY_INT.Get_Quote_Access(p_resource_id,l_quote_number);
238:
239: IF aso_debug_pub.g_debug_flag = 'Y' then
240: aso_debug_pub.add('ASO_DEAL_PUB: Access Level'||l_access_level, 1, 'Y');
241: END IF;
242: --pp_debug('Access level:' || l_access_level);
243: IF ((l_access_level <> 'UPDATE') or (l_max_version_flag <> 'Y') or (l_price_request_id is not null)) THEN
244: x_return_status := fnd_api.g_ret_sts_error;

Line 281: aso_debug_pub.add('ASO_DEAL_PUB:Status - '||p_event, 1, 'Y');

277: END IF; -- P_event in ('SUBMITTED', 'CANCELED', 'ACCEPTED')
278:
279: IF p_event = 'SUBMITTED' THEN
280: IF aso_debug_pub.g_debug_flag = 'Y' then
281: aso_debug_pub.add('ASO_DEAL_PUB:Status - '||p_event, 1, 'Y');
282: END IF;
283: open C_qte_status_id('PRICE APPROVAL PENDING');
284: fetch C_qte_status_id into ln_quote_Status_id;
285: close C_qte_status_id;

Line 336: aso_debug_pub.add('ASO_DEAL_PUB:Status ln_count=0', 1, 'Y');

332:
333: if ln_count=0 then
334:
335: IF aso_debug_pub.g_debug_flag = 'Y' then
336: aso_debug_pub.add('ASO_DEAL_PUB:Status ln_count=0', 1, 'Y');
337: END IF;
338:
339: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
340: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 348: aso_debug_pub.add('ASO_DEAL_PUB:Status ln_count>0'||ld_quote_Status_id, 1, 'Y');

344: END IF;
345: end if;
346: else -- if valid transition to price approval pending
347: IF aso_debug_pub.g_debug_flag = 'Y' then
348: aso_debug_pub.add('ASO_DEAL_PUB:Status ln_count>0'||ld_quote_Status_id, 1, 'Y');
349: END IF;
350: update aso_quote_headers_All
351: set quote_status_id=ld_quote_Status_id
352: where quote_header_id=p_quote_header_id;

Line 361: aso_debug_pub.add('ASO_DEAL_PUB:Status ln_count>0'||ld_quote_Status_id||'new stat'||ln_quote_Status_id, 1, 'Y');

357: fetch C_qte_status_id into ln_quote_Status_id;
358: close C_qte_status_id;
359:
360: IF aso_debug_pub.g_debug_flag = 'Y' then
361: aso_debug_pub.add('ASO_DEAL_PUB:Status ln_count>0'||ld_quote_Status_id||'new stat'||ln_quote_Status_id, 1, 'Y');
362: END IF;
363:
364: ASO_VALIDATE_PVT.Validate_Status_Transition(
365: p_init_msg_list => FND_API.G_FALSE,

Line 751: aso_debug_pub.add('ASO_DEAL_PUB before aso_quote_pub.update_quote - '||p_event, 1, 'Y');

747: END IF;
748:
749: IF P_event in ('ACCEPTED') then
750: IF aso_debug_pub.g_debug_flag = 'Y' then
751: aso_debug_pub.add('ASO_DEAL_PUB before aso_quote_pub.update_quote - '||p_event, 1, 'Y');
752: aso_debug_pub.add('ASO_DEAL_PUB:l_qte_header_rec.quote_status_id - '||l_qte_header_rec.quote_status_id, 1, 'Y');
753: aso_debug_pub.ADD ('Before calling update quote: Setting the single org context to org_id: '|| l_qte_header_rec.org_id,1,'N');
754: END IF;
755:

Line 752: aso_debug_pub.add('ASO_DEAL_PUB:l_qte_header_rec.quote_status_id - '||l_qte_header_rec.quote_status_id, 1, 'Y');

748:
749: IF P_event in ('ACCEPTED') then
750: IF aso_debug_pub.g_debug_flag = 'Y' then
751: aso_debug_pub.add('ASO_DEAL_PUB before aso_quote_pub.update_quote - '||p_event, 1, 'Y');
752: aso_debug_pub.add('ASO_DEAL_PUB:l_qte_header_rec.quote_status_id - '||l_qte_header_rec.quote_status_id, 1, 'Y');
753: aso_debug_pub.ADD ('Before calling update quote: Setting the single org context to org_id: '|| l_qte_header_rec.org_id,1,'N');
754: END IF;
755:
756: -- Setting MOAC

Line 807: aso_debug_pub.add('ASO_DEAL_PUB: after Update_Quote', 1, 'Y');

803: );
804:
805: --pp_debug('after calling aso_quote_pub');
806: IF aso_debug_pub.g_debug_flag = 'Y' THEN
807: aso_debug_pub.add('ASO_DEAL_PUB: after Update_Quote', 1, 'Y');
808: END IF;
809:
810: if x_return_status = FND_API.G_RET_STS_SUCCESS then
811: Update aso_quote_lines_all

Line 929: aso_debug_pub.add('ASO_DEAL_PUB: Start of Get_Deal_Access API ', 1, 'Y');

925: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
926:
927: -- API body
928: IF aso_debug_pub.g_debug_flag = 'Y' THEN
929: aso_debug_pub.add('ASO_DEAL_PUB: ****** Start of Get_Deal_Access API ******', 1, 'Y');
930: END IF;
931:
932: IF aso_debug_pub.g_debug_flag = 'Y' THEN
933: aso_debug_pub.add('ASO_DEAL_PUB: Get_Deal_Access: P_RESOURCE_ID: ' || P_RESOURCE_ID, 1, 'Y');

Line 933: aso_debug_pub.add('ASO_DEAL_PUB: Get_Deal_Access: P_RESOURCE_ID: ' || P_RESOURCE_ID, 1, 'Y');

929: aso_debug_pub.add('ASO_DEAL_PUB: ****** Start of Get_Deal_Access API ******', 1, 'Y');
930: END IF;
931:
932: IF aso_debug_pub.g_debug_flag = 'Y' THEN
933: aso_debug_pub.add('ASO_DEAL_PUB: Get_Deal_Access: P_RESOURCE_ID: ' || P_RESOURCE_ID, 1, 'Y');
934: aso_debug_pub.add('ASO_DEAL_PUB: Get_Deal_Access: P_QUOTE_HEADER_ID: ' || P_QUOTE_HEADER_ID, 1, 'Y');
935: END IF;
936:
937: -- Getting quote header Details

Line 934: aso_debug_pub.add('ASO_DEAL_PUB: Get_Deal_Access: P_QUOTE_HEADER_ID: ' || P_QUOTE_HEADER_ID, 1, 'Y');

930: END IF;
931:
932: IF aso_debug_pub.g_debug_flag = 'Y' THEN
933: aso_debug_pub.add('ASO_DEAL_PUB: Get_Deal_Access: P_RESOURCE_ID: ' || P_RESOURCE_ID, 1, 'Y');
934: aso_debug_pub.add('ASO_DEAL_PUB: Get_Deal_Access: P_QUOTE_HEADER_ID: ' || P_QUOTE_HEADER_ID, 1, 'Y');
935: END IF;
936:
937: -- Getting quote header Details
938: SELECT nvl(max_version_flag,'N'), price_request_id, nvl(pricing_status_indicator,'C'),quote_number,quote_status_id

Line 946: aso_debug_pub.add('ASO_DEAL_PUB: Get_Deal_Access: Access level returned by ASO_SECURITY_INT: ' || l_access_level, 1, 'Y');

942:
943: -- Getting the user level access
944: l_access_level:=ASO_SECURITY_INT.Get_Quote_Access (p_resource_id,l_quote_number);
945:
946: aso_debug_pub.add('ASO_DEAL_PUB: Get_Deal_Access: Access level returned by ASO_SECURITY_INT: ' || l_access_level, 1, 'Y');
947:
948: -- User has update access to quote. In case user has access level 'READ' or 'NONE' for the quote nothing needs to be done
949: -- check additional conditions for max version, batch pricing, status
950: IF l_access_level = 'UPDATE' then

Line 978: aso_debug_pub.add('ASO_DEAL_PUB: Get_Deal_Access: End of API body', 1, 'Y');

974: end if;
975: END IF;
976: -- End of API body
977: IF aso_debug_pub.g_debug_flag = 'Y' THEN
978: aso_debug_pub.add('ASO_DEAL_PUB: Get_Deal_Access: End of API body', 1, 'Y');
979: END IF;
980: RETURN l_access_level;
981:
982: END Get_Deal_Access;

Line 1004: aso_debug_pub.add('ASO_DEAL_PUB: Start of Get_Deal_Enable_Buttons API ', 1, 'Y');

1000: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
1001:
1002: -- API body
1003: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1004: aso_debug_pub.add('ASO_DEAL_PUB: ****** Start of Get_Deal_Enable_Buttons API ******', 1, 'Y');
1005: END IF;
1006:
1007: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1008: aso_debug_pub.add('ASO_DEAL_PUB: Get_Deal_Enable_Buttons: P_RESOURCE_ID: ' || P_RESOURCE_ID, 1, 'Y');

Line 1008: aso_debug_pub.add('ASO_DEAL_PUB: Get_Deal_Enable_Buttons: P_RESOURCE_ID: ' || P_RESOURCE_ID, 1, 'Y');

1004: aso_debug_pub.add('ASO_DEAL_PUB: ****** Start of Get_Deal_Enable_Buttons API ******', 1, 'Y');
1005: END IF;
1006:
1007: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1008: aso_debug_pub.add('ASO_DEAL_PUB: Get_Deal_Enable_Buttons: P_RESOURCE_ID: ' || P_RESOURCE_ID, 1, 'Y');
1009: aso_debug_pub.add('ASO_DEAL_PUB: Get_Deal_Enable_Buttons: P_QUOTE_HEADER_ID: ' || P_QUOTE_HEADER_ID, 1, 'Y');
1010: END IF;
1011:
1012: -- Getting quote header Details

Line 1009: aso_debug_pub.add('ASO_DEAL_PUB: Get_Deal_Enable_Buttons: P_QUOTE_HEADER_ID: ' || P_QUOTE_HEADER_ID, 1, 'Y');

1005: END IF;
1006:
1007: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1008: aso_debug_pub.add('ASO_DEAL_PUB: Get_Deal_Enable_Buttons: P_RESOURCE_ID: ' || P_RESOURCE_ID, 1, 'Y');
1009: aso_debug_pub.add('ASO_DEAL_PUB: Get_Deal_Enable_Buttons: P_QUOTE_HEADER_ID: ' || P_QUOTE_HEADER_ID, 1, 'Y');
1010: END IF;
1011:
1012: -- Getting quote header Details
1013: SELECT nvl(max_version_flag,'N'), price_request_id, nvl(pricing_status_indicator,'C'),quote_number

Line 1021: aso_debug_pub.add('ASO_DEAL_PUB: Get_Deal_Enable_Buttons: Access level returned by ASO_SECURITY_INT: ' || l_access_level, 1, 'Y');

1017:
1018: -- Getting the user level access
1019: l_access_level:=ASO_SECURITY_INT.Get_Quote_Access (p_resource_id,l_quote_number);
1020:
1021: aso_debug_pub.add('ASO_DEAL_PUB: Get_Deal_Enable_Buttons: Access level returned by ASO_SECURITY_INT: ' || l_access_level, 1, 'Y');
1022:
1023: -- User has update access to quote. In case user has access level 'READ' or 'NONE' for the quote nothing needs to be done
1024: -- check additional conditions for max version, batch pricing, status
1025: IF l_access_level = 'UPDATE' then

Line 1036: aso_debug_pub.add('ASO_DEAL_PUB: Get_Deal_Enable_Buttons: l_access_level: ' || l_access_level, 1, 'Y');

1032: l_access_level:= 'READ';
1033: end if;
1034: END IF;
1035:
1036: aso_debug_pub.add('ASO_DEAL_PUB: Get_Deal_Enable_Buttons: l_access_level: ' || l_access_level, 1, 'Y');
1037:
1038: -- End of API body
1039: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1040: aso_debug_pub.add('ASO_DEAL_PUB: Get_Deal_Enable_Buttons: End of API body', 1, 'Y');

Line 1040: aso_debug_pub.add('ASO_DEAL_PUB: Get_Deal_Enable_Buttons: End of API body', 1, 'Y');

1036: aso_debug_pub.add('ASO_DEAL_PUB: Get_Deal_Enable_Buttons: l_access_level: ' || l_access_level, 1, 'Y');
1037:
1038: -- End of API body
1039: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1040: aso_debug_pub.add('ASO_DEAL_PUB: Get_Deal_Enable_Buttons: End of API body', 1, 'Y');
1041: END IF;
1042:
1043:
1044: if l_access_level = 'UPDATE' then

Line 1054: End ASO_DEAL_PUB;

1050:
1051:
1052: END Get_Deal_Enable_Buttons;
1053:
1054: End ASO_DEAL_PUB;