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.AS_SC_DENORM_TRG dependencies on FND_MSG_PUB

Line 172: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

168: l_owner_person_name jtf_rs_resource_extns.source_name%TYPE;
169: l_owner_first_name jtf_rs_resource_extns.source_first_name%TYPE;
170: l_owner_last_name jtf_rs_resource_extns.source_last_name%TYPE;
171: l_owner_group_name jtf_rs_groups_tl.group_name%TYPE;
172: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
173: Begin
174: IF l_debug THEN
175: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Leads_Trigger_Handler Start');
176: END IF;

Line 175: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Leads_Trigger_Handler Start');

171: l_owner_group_name jtf_rs_groups_tl.group_name%TYPE;
172: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
173: Begin
174: IF l_debug THEN
175: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Leads_Trigger_Handler Start');
176: END IF;
177:
178: If p_trigger_mode = 'ON-UPDATE' then
179: IF l_debug THEN

Line 180: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Update opportunity');

176: END IF;
177:
178: If p_trigger_mode = 'ON-UPDATE' then
179: IF l_debug THEN
180: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Update opportunity');
181: END IF;
182: Begin
183: Select party_name, party_type, category_code
184: Into l_customer_name, l_party_type, l_customer_category_code

Line 419: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR, 'Error in Leads Trg:' || sqlerrm);

415: End If;
416: Exception
417: When FND_API.G_EXC_UNEXPECTED_ERROR then
418: IF l_debug THEN
419: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR, 'Error in Leads Trg:' || sqlerrm);
420: END IF;
421:
422: FND_MSG_PUB.Add_Exc_Msg('AS_SC_DENORM_TRG', 'Leads_Trigger_Handler');
423: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 422: FND_MSG_PUB.Add_Exc_Msg('AS_SC_DENORM_TRG', 'Leads_Trigger_Handler');

418: IF l_debug THEN
419: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR, 'Error in Leads Trg:' || sqlerrm);
420: END IF;
421:
422: FND_MSG_PUB.Add_Exc_Msg('AS_SC_DENORM_TRG', 'Leads_Trigger_Handler');
423: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
424: When Others then
425: IF l_debug THEN
426: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,

Line 426: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,

422: FND_MSG_PUB.Add_Exc_Msg('AS_SC_DENORM_TRG', 'Leads_Trigger_Handler');
423: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
424: When Others then
425: IF l_debug THEN
426: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
427: 'Error in Leads Trg:' || sqlerrm);
428: END IF;
429: FND_MSG_PUB.Add_Exc_Msg('AS_SC_DENORM_TRG', 'Leads_Trigger_Handler');
430: End Leads_Trigger_Handler;

Line 429: FND_MSG_PUB.Add_Exc_Msg('AS_SC_DENORM_TRG', 'Leads_Trigger_Handler');

425: IF l_debug THEN
426: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
427: 'Error in Leads Trg:' || sqlerrm);
428: END IF;
429: FND_MSG_PUB.Add_Exc_Msg('AS_SC_DENORM_TRG', 'Leads_Trigger_Handler');
430: End Leads_Trigger_Handler;
431:
432: Procedure Lead_Lines_Trigger_Handler(
433: p_new_last_update_date IN as_lead_lines_all.last_update_date%type ,

Line 482: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

478: l_win_probability NUMBER;
479: l_uom_description as_sales_credits_denorm.uom_description%type;
480: l_item_description as_sales_credits_denorm.item_description%type;
481: l_new_frcst_date as_lead_lines_all.forecast_date%type;
482: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
483:
484: Begin
485: IF l_debug THEN
486: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Lead_Lines_Trigger_Handler Start');

Line 486: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Lead_Lines_Trigger_Handler Start');

482: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
483:
484: Begin
485: IF l_debug THEN
486: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Lead_Lines_Trigger_Handler Start');
487: END IF;
488:
489: If p_trigger_mode = 'ON-UPDATE' then
490: Begin

Line 618: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,

614:
615: Exception
616: When FND_API.G_EXC_UNEXPECTED_ERROR then
617: IF l_debug THEN
618: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
619: 'Error in Lead Lines Trg:' || sqlerrm);
620: END IF;
621:
622: FND_MSG_PUB.Add_Exc_Msg('AS_SC_DENORM_TRG', 'Lead_Lines_Trigger_Handler');

Line 622: FND_MSG_PUB.Add_Exc_Msg('AS_SC_DENORM_TRG', 'Lead_Lines_Trigger_Handler');

618: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
619: 'Error in Lead Lines Trg:' || sqlerrm);
620: END IF;
621:
622: FND_MSG_PUB.Add_Exc_Msg('AS_SC_DENORM_TRG', 'Lead_Lines_Trigger_Handler');
623: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
624: When Others then
625: IF l_debug THEN
626: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,

Line 626: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,

622: FND_MSG_PUB.Add_Exc_Msg('AS_SC_DENORM_TRG', 'Lead_Lines_Trigger_Handler');
623: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
624: When Others then
625: IF l_debug THEN
626: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
627: 'Error in Lead Lines Trg:' || sqlerrm);
628: END IF;
629:
630: FND_MSG_PUB.Add_Exc_Msg('AS_SC_DENORM_TRG', 'Lead_Lines_Trigger_Handler');

Line 630: FND_MSG_PUB.Add_Exc_Msg('AS_SC_DENORM_TRG', 'Lead_Lines_Trigger_Handler');

626: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
627: 'Error in Lead Lines Trg:' || sqlerrm);
628: END IF;
629:
630: FND_MSG_PUB.Add_Exc_Msg('AS_SC_DENORM_TRG', 'Lead_Lines_Trigger_Handler');
631: End Lead_Lines_Trigger_Handler;
632:
633: Procedure Sales_Credit_Trg_Handler(
634: p_new_sales_credit_id IN NUMBER,

Line 726: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

722: l_revenue_flag aso_i_sales_credit_types_v.quota_flag%Type;
723: l_parent_project as_leads_all.parent_project%Type;
724: l_partner_cust_name hz_parties.party_name%Type;
725: l_business_group_name hr_all_organization_units_tl.name%Type;
726: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
727:
728: Begin
729: IF l_debug THEN
730: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Sales_Credit_Trg_Handler Start');

Line 730: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Sales_Credit_Trg_Handler Start');

726: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
727:
728: Begin
729: IF l_debug THEN
730: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Sales_Credit_Trg_Handler Start');
731: END IF;
732:
733: If (p_Trigger_Mode = 'ON-DELETE') then
734: Begin

Line 1407: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,

1403: End if;
1404: Exception
1405: When Others then
1406: IF l_debug THEN
1407: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
1408: 'Error in Sales Credits Trigger:' || sqlerrm);
1409: END IF;
1410:
1411: FND_MSG_PUB.Add_Exc_Msg('AS_SC_DENORM_TRG', 'Sales_Credit_Trg_Handler');

Line 1411: FND_MSG_PUB.Add_Exc_Msg('AS_SC_DENORM_TRG', 'Sales_Credit_Trg_Handler');

1407: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
1408: 'Error in Sales Credits Trigger:' || sqlerrm);
1409: END IF;
1410:
1411: FND_MSG_PUB.Add_Exc_Msg('AS_SC_DENORM_TRG', 'Sales_Credit_Trg_Handler');
1412: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1413: End;
1414:
1415: Exception

Line 1418: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,

1414:
1415: Exception
1416: When FND_API.G_EXC_UNEXPECTED_ERROR then
1417: IF l_debug THEN
1418: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
1419: 'Error in Sales Credits Trigger:' || sqlerrm);
1420: END IF;
1421:
1422: FND_MSG_PUB.Add_Exc_Msg('AS_SC_DENORM_TRG', 'Sales_Credit_Trg_Handler');

Line 1422: FND_MSG_PUB.Add_Exc_Msg('AS_SC_DENORM_TRG', 'Sales_Credit_Trg_Handler');

1418: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
1419: 'Error in Sales Credits Trigger:' || sqlerrm);
1420: END IF;
1421:
1422: FND_MSG_PUB.Add_Exc_Msg('AS_SC_DENORM_TRG', 'Sales_Credit_Trg_Handler');
1423: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1424: When Others then
1425: IF l_debug THEN
1426: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,

Line 1426: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,

1422: FND_MSG_PUB.Add_Exc_Msg('AS_SC_DENORM_TRG', 'Sales_Credit_Trg_Handler');
1423: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1424: When Others then
1425: IF l_debug THEN
1426: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
1427: 'Error in Sales Credits Trigger:' || sqlerrm);
1428: END IF;
1429:
1430: FND_MSG_PUB.Add_Exc_Msg('AS_SC_DENORM_TRG', 'Sales_Credit_Trg_Handler');

Line 1430: FND_MSG_PUB.Add_Exc_Msg('AS_SC_DENORM_TRG', 'Sales_Credit_Trg_Handler');

1426: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
1427: 'Error in Sales Credits Trigger:' || sqlerrm);
1428: END IF;
1429:
1430: FND_MSG_PUB.Add_Exc_Msg('AS_SC_DENORM_TRG', 'Sales_Credit_Trg_Handler');
1431: End Sales_Credit_Trg_Handler;
1432:
1433: End AS_SC_DENORM_TRG;