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_LEADS_LINES_LOG_PKG dependencies on AS_LEADS_LINES_LOG_PKG

Line 1: PACKAGE BODY AS_LEADS_LINES_LOG_PKG as

1: PACKAGE BODY AS_LEADS_LINES_LOG_PKG as
2: /* $Header: asxtlnlb.pls 120.2 2005/09/02 04:05:26 appldev ship $ */
3: PROCEDURE Insert_Row( p_lead_id NUMBER,
4: p_lead_line_id NUMBER,
5: p_last_update_date DATE,

Line 31: 'asxtlnlb: In AS_LEADS_LINES_LOG_PKG Before Insert Statement');

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,
35: lead_id,

Line 81: -- dbms_output.put_line('In AS_LEADS_LINES_LOG_PKG After Insert Statement Seems some error');

77: decode( p_endday_log_flag,FND_API.G_MISS_CHAR, NULL, p_endday_log_flag));
78:
79: EXCEPTION
80: WHEN OTHERS THEN
81: -- dbms_output.put_line('In AS_LEADS_LINES_LOG_PKG After Insert Statement Seems some error');
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

Line 87: 'asxtlnlb: In AS_LEADS_LINES_LOG_PKG After Insert Statement Seems some error');

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;
91: END Insert_Row;

Line 119: -- dbms_output.put_line('In AS_LEADS_LINES_LOG_PKG before Update_Row');

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,
122: 'asxtlnlb: In AS_LEADS_LINES_LOG_PKG before Update_Row');
123: END IF;

Line 122: 'asxtlnlb: In AS_LEADS_LINES_LOG_PKG before Update_Row');

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),
126: last_update_date = decode( new_last_update_date,FND_API.G_MISS_DATE, TO_DATE(NULL), new_last_update_date),

Line 148: -- dbms_output.put_line('In AS_LEADS_LINES_LOG_PKG after Update statement : Data No found seems');

144: from AS_LEAD_LINES_LOG
145: where lead_line_id = old_lead_line_id);
146:
147: If (SQL%NOTFOUND) then
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,

Line 153: 'asxtlnlb: 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;
157: RAISE NO_DATA_FOUND;

Line 178: -- dbms_output.put_line('In AS_LEADS_LINES_LOG_PKG before Delete_Row');

174: Update AS_LEAD_LINES_LOG
175: set object_version_number = nvl(object_version_number,0) + 1, log_mode = 'D'
176: where lead_line_id = old_lead_line_id and last_update_date = old_last_update_date;
177: */
178: -- dbms_output.put_line('In AS_LEADS_LINES_LOG_PKG before Delete_Row');
179: -- dbms_output.put_line('Lead Id:'|| p_old_lead_id);
180: -- dbms_output.put_line('Lead line Id:'|| p_old_lead_line_id);
181: -- dbms_output.put_line('p_old_last_update_date:'|| p_old_last_update_date);
182: -- dbms_output.put_line('p_old_last_updated_by:'|| p_old_last_updated_by);

Line 212: -- dbms_output.put_line('In AS_LEADS_LINES_LOG_PKG After Delete Statement Seems some error');

208: decode( p_endday_log_flag,FND_API.G_MISS_CHAR, NULL, p_endday_log_flag));
209:
210: EXCEPTION
211: WHEN OTHERS THEN
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,

Line 217: 'asxtlnlb: 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;
221:

Line 224: END AS_LEADS_LINES_LOG_PKG;

220: END IF;
221:
222: END Delete_Row;
223:
224: END AS_LEADS_LINES_LOG_PKG;