APPS.AS_SALES_CREDITS_LOG_PKG dependencies on FND_MSG_PUB

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

18: p_new_opp_best_frcst_amount NUMBER,
19: p_endday_log_flag VARCHAR2,
20: p_TRIGGER_MODE VARCHAR2)
21: IS
22: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
23:
24: BEGIN
25: -- dbms_output.put_line('In AS_SALES_CREDITS_LOG_PKG Before Insert Statement');
26:

Line 28: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

24: BEGIN
25: -- dbms_output.put_line('In AS_SALES_CREDITS_LOG_PKG Before Insert Statement');
26:
27: IF l_debug THEN
28: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
29: 'asxtsclb: In AS_SALES_CREDITS_LOG_PKG Before Insert Statement');
30: END IF;
31: Insert into AS_SALES_CREDITS_LOG (
32: log_id,

Line 76: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

72: -- dbms_output.put_line('In AS_SALES_CREDITS_LOG_PKG After Insert Statement Seems some error');
73: -- dbms_output.put_line('Error Number:'||SQLCODE);
74: -- dbms_output.put_line('Error Message:'|| SUBSTR(SQLERRM, 1, 200));
75: IF l_debug THEN
76: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
77: 'asxtsclb: In AS_SALES_CREDITS_LOG_PKG After Insert Statement Seems some error');
78: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
79: 'asxtsclb: Error Number: '||SQLCODE||' and Error Message: ' || SUBSTR(SQLERRM, 1, 200));
80: END IF;

Line 78: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

74: -- dbms_output.put_line('Error Message:'|| SUBSTR(SQLERRM, 1, 200));
75: IF l_debug THEN
76: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
77: 'asxtsclb: In AS_SALES_CREDITS_LOG_PKG After Insert Statement Seems some error');
78: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
79: 'asxtsclb: Error Number: '||SQLCODE||' and Error Message: ' || SUBSTR(SQLERRM, 1, 200));
80: END IF;
81: END Insert_Row;
82:

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

99: p_new_opp_best_frcst_amount NUMBER,
100: p_endday_log_flag VARCHAR2,
101: p_TRIGGER_MODE VARCHAR2)
102: IS
103: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
104:
105: BEGIN
106: -- dbms_output.put_line('In AS_SALES_CREDITS_LOG_PKG before Update_Row');
107: IF l_debug THEN

Line 108: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

104:
105: BEGIN
106: -- dbms_output.put_line('In AS_SALES_CREDITS_LOG_PKG before Update_Row');
107: IF l_debug THEN
108: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
109: 'asxtsclb: In AS_SALES_CREDITS_LOG_PKG before Update_Row');
110: END IF;
111:
112: Update AS_SALES_CREDITS_LOG

Line 138: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

134: -- dbms_output.put_line('Error Number:'||SQLCODE);
135: -- dbms_output.put_line('Error Message:'|| SUBSTR(SQLERRM, 1, 200));
136:
137: IF l_debug THEN
138: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
139: 'asxtsclb: In AS_SALES_CREDITS_LOG_PKG after Update statement : Data No found seems');
140: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
141: 'asxtsclb: Error Number: '||SQLCODE||' and Error Message: ' || SUBSTR(SQLERRM, 1, 200));
142: END IF;

Line 140: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

136:
137: IF l_debug THEN
138: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
139: 'asxtsclb: In AS_SALES_CREDITS_LOG_PKG after Update statement : Data No found seems');
140: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
141: 'asxtsclb: Error Number: '||SQLCODE||' and Error Message: ' || SUBSTR(SQLERRM, 1, 200));
142: END IF;
143: RAISE NO_DATA_FOUND;
144: End If;

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

153: p_old_creation_date DATE,
154: p_old_created_by NUMBER,
155: p_endday_log_flag VARCHAR2)
156: IS
157: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
158:
159: BEGIN
160: /*
161: Update AS_SALES_CREDITS_LOG

Line 195: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

191: -- dbms_output.put_line('In AS_SALES_CREDITS_LOG_PKG After Delete Statement Seems some error');
192: -- dbms_output.put_line('Error Number:'||SQLCODE);
193: -- dbms_output.put_line('Error Message:'|| SUBSTR(SQLERRM, 1, 200));
194: IF l_debug THEN
195: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
196: 'asxtsclb: In AS_SALES_CREDITS_LOG_PKG After Delete Statement Seems some error');
197: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
198: 'asxtsclb: Error Number: '||SQLCODE||' and Error Message: ' || SUBSTR(SQLERRM, 1, 200));
199: END IF;

Line 197: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

193: -- dbms_output.put_line('Error Message:'|| SUBSTR(SQLERRM, 1, 200));
194: IF l_debug THEN
195: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
196: 'asxtsclb: In AS_SALES_CREDITS_LOG_PKG After Delete Statement Seems some error');
197: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
198: 'asxtsclb: Error Number: '||SQLCODE||' and Error Message: ' || SUBSTR(SQLERRM, 1, 200));
199: END IF;
200:
201: END Delete_Row;