DBA Data[Home] [Help]

APPS.AS_SALES_CREDITS_LOG_PKG dependencies on AS_SALES_CREDITS_LOG_PKG

Line 1: PACKAGE BODY AS_SALES_CREDITS_LOG_PKG as

1: PACKAGE BODY AS_SALES_CREDITS_LOG_PKG as
2: /* $Header: asxtsclb.pls 120.2 2005/09/02 04:05:34 appldev ship $ */
3: PROCEDURE Insert_Row(p_new_lead_id NUMBER,
4: p_new_lead_line_id NUMBER,
5: p_new_sales_credit_id NUMBER,

Line 25: -- dbms_output.put_line('In AS_SALES_CREDITS_LOG_PKG Before Insert Statement');

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

Line 29: 'asxtsclb: In AS_SALES_CREDITS_LOG_PKG Before Insert Statement');

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

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

68: decode( p_new_opp_best_frcst_amount,FND_API.G_MISS_NUM, NULL, p_new_opp_best_frcst_amount),
69: decode( p_endday_log_flag,FND_API.G_MISS_CHAR, NULL, p_endday_log_flag));
70: EXCEPTION
71: WHEN OTHERS THEN
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,

Line 77: 'asxtsclb: 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;
81: END Insert_Row;

Line 106: -- dbms_output.put_line('In AS_SALES_CREDITS_LOG_PKG before Update_Row');

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

Line 109: 'asxtsclb: In AS_SALES_CREDITS_LOG_PKG before Update_Row');

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
113: SET object_version_number = nvl(object_version_number,0) + 1, lead_id = decode( p_new_lead_id, FND_API.G_MISS_NUM, NULL, p_new_lead_id),

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

129: from AS_SALES_CREDITS_LOG
130: where SALES_CREDIT_ID = p_old_sales_credit_id);
131:
132: If (SQL%NOTFOUND) then
133: -- dbms_output.put_line('In AS_SALES_CREDITS_LOG_PKG after Update statement : Data No found seems');
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

Line 139: 'asxtsclb: In AS_SALES_CREDITS_LOG_PKG after Update statement : Data No found seems');

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;
143: RAISE NO_DATA_FOUND;

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

187: decode( p_endday_log_flag,FND_API.G_MISS_CHAR, NULL, p_endday_log_flag));
188:
189: EXCEPTION
190: WHEN OTHERS THEN
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,

Line 196: 'asxtsclb: 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;
200:

Line 202: END AS_SALES_CREDITS_LOG_PKG;

198: 'asxtsclb: Error Number: '||SQLCODE||' and Error Message: ' || SUBSTR(SQLERRM, 1, 200));
199: END IF;
200:
201: END Delete_Row;
202: END AS_SALES_CREDITS_LOG_PKG;