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