DBA Data[Home] [Help]

APPS.AS_SC_DENORM_TRG dependencies on AS_UTILITY_PVT

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 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 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 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 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 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 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');