APPS.AS_LEADS_LINES_LOG_PKG dependencies on FND_MSG_PUB

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

21: p_rolling_forecast_flag VARCHAR2,
22: p_endday_log_flag VARCHAR2,
23: p_TRIGGER_MODE VARCHAR2)
24: IS
25: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
26:
27: BEGIN
28:
29: IF l_debug THEN

Line 30: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

26:
27: BEGIN
28:
29: IF l_debug THEN
30: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
31: 'asxtlnlb: In AS_LEADS_LINES_LOG_PKG Before Insert Statement');
32: END IF;
33: Insert into AS_LEAD_LINES_LOG (
34: log_id,

Line 86: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

82: -- dbms_output.put_line('Error Number:'||SQLCODE);
83: -- dbms_output.put_line('Error Message:'|| SUBSTR(SQLERRM, 1, 200));
84:
85: IF l_debug THEN
86: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
87: 'asxtlnlb: In AS_LEADS_LINES_LOG_PKG After Insert Statement Seems some error');
88: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
89: 'asxtlnlb: Error Number: '||SQLCODE||' and Error Message: ' || SUBSTR(SQLERRM, 1, 200));
90: END IF;

Line 88: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

84:
85: IF l_debug THEN
86: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
87: 'asxtlnlb: In AS_LEADS_LINES_LOG_PKG After Insert Statement Seems some error');
88: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
89: 'asxtlnlb: Error Number: '||SQLCODE||' and Error Message: ' || SUBSTR(SQLERRM, 1, 200));
90: END IF;
91: END Insert_Row;
92: PROCEDURE Update_Row(

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

113: p_endday_log_flag VARCHAR2,
114: p_TRIGGER_MODE VARCHAR2)
115: IS
116:
117: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
118: BEGIN
119: -- dbms_output.put_line('In AS_LEADS_LINES_LOG_PKG before Update_Row');
120: IF l_debug THEN
121: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 121: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

117: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
118: BEGIN
119: -- dbms_output.put_line('In AS_LEADS_LINES_LOG_PKG before Update_Row');
120: IF l_debug THEN
121: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
122: 'asxtlnlb: In AS_LEADS_LINES_LOG_PKG before Update_Row');
123: END IF;
124: Update AS_LEAD_LINES_LOG
125: SET object_version_number = nvl(object_version_number,0) + 1, lead_id = decode( p_lead_id, FND_API.G_MISS_NUM, NULL, p_lead_id),

Line 152: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

148: -- dbms_output.put_line('In AS_LEADS_LINES_LOG_PKG after Update statement : Data No found seems');
149: -- dbms_output.put_line('Error Number:'||SQLCODE);
150: -- dbms_output.put_line('Error Message:'|| SUBSTR(SQLERRM, 1, 200));
151: IF l_debug THEN
152: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
153: 'asxtlnlb: In AS_LEADS_LINES_LOG_PKG after Update statement : Data No found seems');
154: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
155: 'asxtlnlb: Error Number: '||SQLCODE||' and Error Message: ' || SUBSTR(SQLERRM, 1, 200));
156: END IF;

Line 154: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

150: -- dbms_output.put_line('Error Message:'|| SUBSTR(SQLERRM, 1, 200));
151: IF l_debug THEN
152: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
153: 'asxtlnlb: In AS_LEADS_LINES_LOG_PKG after Update statement : Data No found seems');
154: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
155: 'asxtlnlb: Error Number: '||SQLCODE||' and Error Message: ' || SUBSTR(SQLERRM, 1, 200));
156: END IF;
157: RAISE NO_DATA_FOUND;
158: End If;

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

166: p_old_creation_date DATE,
167: p_old_created_by NUMBER,
168: p_endday_log_flag VARCHAR2)
169: IS
170: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
171:
172: BEGIN
173: /*
174: Update AS_LEAD_LINES_LOG

Line 216: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

212: -- dbms_output.put_line('In AS_LEADS_LINES_LOG_PKG After Delete Statement Seems some error');
213: -- dbms_output.put_line('Error Number:'||SQLCODE);
214: -- dbms_output.put_line('Error Message:'|| SUBSTR(SQLERRM, 1, 200));
215: IF l_debug THEN
216: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
217: 'asxtlnlb: In AS_LEADS_LINES_LOG_PKG After Delete Statement Seems some error');
218: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
219: 'asxtlnlb: Error Number: '||SQLCODE||' and Error Message: ' || SUBSTR(SQLERRM, 1, 200));
220: END IF;

Line 218: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

214: -- dbms_output.put_line('Error Message:'|| SUBSTR(SQLERRM, 1, 200));
215: IF l_debug THEN
216: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
217: 'asxtlnlb: In AS_LEADS_LINES_LOG_PKG After Delete Statement Seems some error');
218: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
219: 'asxtlnlb: Error Number: '||SQLCODE||' and Error Message: ' || SUBSTR(SQLERRM, 1, 200));
220: END IF;
221:
222: END Delete_Row;