DBA Data[Home] [Help]

APPS.AS_SALES_CREDITS_LOG_PKG dependencies on AS_UTILITY_PVT

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