DBA Data[Home] [Help]

APPS.ASN_SALES_PVT dependencies on FND_LOG

Line 18: G_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;

14: X_Msg_Data OUT NOCOPY VARCHAR2
15: )
16: IS
17: G_PROC_NAME VARCHAR2(200) := 'asn.plsql.ASN_SALES_PVT.Lead_Process_After_Create';
18: G_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;
19: G_STMT_LEVEL NUMBER := FND_LOG.LEVEL_STATEMENT;
20: G_DEBUG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
21:
22: BEGIN

Line 19: G_STMT_LEVEL NUMBER := FND_LOG.LEVEL_STATEMENT;

15: )
16: IS
17: G_PROC_NAME VARCHAR2(200) := 'asn.plsql.ASN_SALES_PVT.Lead_Process_After_Create';
18: G_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;
19: G_STMT_LEVEL NUMBER := FND_LOG.LEVEL_STATEMENT;
20: G_DEBUG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
21:
22: BEGIN
23: IF (G_PROC_LEVEL >= G_DEBUG_LEVEL)

Line 20: G_DEBUG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

16: IS
17: G_PROC_NAME VARCHAR2(200) := 'asn.plsql.ASN_SALES_PVT.Lead_Process_After_Create';
18: G_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;
19: G_STMT_LEVEL NUMBER := FND_LOG.LEVEL_STATEMENT;
20: G_DEBUG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
21:
22: BEGIN
23: IF (G_PROC_LEVEL >= G_DEBUG_LEVEL)
24: THEN

Line 25: FND_LOG.String(G_PROC_LEVEL,

21:
22: BEGIN
23: IF (G_PROC_LEVEL >= G_DEBUG_LEVEL)
24: THEN
25: FND_LOG.String(G_PROC_LEVEL,
26: G_PROC_NAME,
27: 'begin');
28: END IF;
29:

Line 32: FND_LOG.String(G_STMT_LEVEL,

28: END IF;
29:
30: IF (G_STMT_LEVEL >= G_DEBUG_LEVEL)
31: THEN
32: FND_LOG.String(G_STMT_LEVEL,
33: G_PROC_NAME,
34: 'Calling AS_SALES_LEADS_PUB.Lead_Process_After_Create...');
35: END IF;
36:

Line 55: FND_LOG.String(G_STMT_LEVEL,

51: , X_Msg_Data => x_msg_data);
52:
53: IF (G_STMT_LEVEL >= G_DEBUG_LEVEL)
54: THEN
55: FND_LOG.String(G_STMT_LEVEL,
56: G_PROC_NAME,
57: 'Returning from AS_SALES_LEADS_PUB.Lead_Process_After_Create' ||
58: ', To remove duplicate access records. ');
59: END IF;

Line 64: FND_LOG.String(G_STMT_LEVEL,

60:
61:
62: IF (G_STMT_LEVEL >= G_DEBUG_LEVEL)
63: THEN
64: FND_LOG.String(G_STMT_LEVEL,
65: G_PROC_NAME,
66: 'After Create: Delete duplicate access records on auto conversion.');
67: END IF;
68:

Line 72: FND_LOG.String(G_PROC_LEVEL,

68:
69:
70: IF (G_PROC_LEVEL >= G_DEBUG_LEVEL)
71: THEN
72: FND_LOG.String(G_PROC_LEVEL,
73: G_PROC_NAME,
74: 'end');
75: END IF;
76:

Line 93: G_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;

89: X_Msg_Data OUT NOCOPY VARCHAR2
90: )
91: IS
92: G_PROC_NAME VARCHAR2(200) := 'asn.plsql.ASN_SALES_PVT.Lead_Process_After_Update';
93: G_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;
94: G_STMT_LEVEL NUMBER := FND_LOG.LEVEL_STATEMENT;
95: G_DEBUG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
96:
97: BEGIN

Line 94: G_STMT_LEVEL NUMBER := FND_LOG.LEVEL_STATEMENT;

90: )
91: IS
92: G_PROC_NAME VARCHAR2(200) := 'asn.plsql.ASN_SALES_PVT.Lead_Process_After_Update';
93: G_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;
94: G_STMT_LEVEL NUMBER := FND_LOG.LEVEL_STATEMENT;
95: G_DEBUG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
96:
97: BEGIN
98: IF (G_PROC_LEVEL >= G_DEBUG_LEVEL)

Line 95: G_DEBUG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

91: IS
92: G_PROC_NAME VARCHAR2(200) := 'asn.plsql.ASN_SALES_PVT.Lead_Process_After_Update';
93: G_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;
94: G_STMT_LEVEL NUMBER := FND_LOG.LEVEL_STATEMENT;
95: G_DEBUG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
96:
97: BEGIN
98: IF (G_PROC_LEVEL >= G_DEBUG_LEVEL)
99: THEN

Line 100: FND_LOG.String(G_PROC_LEVEL,

96:
97: BEGIN
98: IF (G_PROC_LEVEL >= G_DEBUG_LEVEL)
99: THEN
100: FND_LOG.String(G_PROC_LEVEL,
101: G_PROC_NAME,
102: 'begin');
103: END IF;
104:

Line 107: FND_LOG.String(G_STMT_LEVEL,

103: END IF;
104:
105: IF (G_STMT_LEVEL >= G_DEBUG_LEVEL)
106: THEN
107: FND_LOG.String(G_STMT_LEVEL,
108: G_PROC_NAME,
109: 'Calling AS_SALES_LEADS_PUB.Lead_Process_After_Update...');
110: END IF;
111:

Line 130: FND_LOG.String(G_STMT_LEVEL,

126: , X_Msg_Data => x_msg_data);
127:
128: IF (G_STMT_LEVEL >= G_DEBUG_LEVEL)
129: THEN
130: FND_LOG.String(G_STMT_LEVEL,
131: G_PROC_NAME,
132: 'Returning from AS_SALES_LEADS_PUB.Lead_Process_After_Update' ||
133: ', To remove duplicate access records. ');
134: END IF;

Line 138: FND_LOG.String(G_STMT_LEVEL,

134: END IF;
135:
136: IF (G_STMT_LEVEL >= G_DEBUG_LEVEL)
137: THEN
138: FND_LOG.String(G_STMT_LEVEL,
139: G_PROC_NAME,
140: 'After Update: Delete duplicate access records on auto conversion. ');
141: END IF;
142:

Line 145: FND_LOG.String(G_PROC_LEVEL,

141: END IF;
142:
143: IF (G_PROC_LEVEL >= G_DEBUG_LEVEL)
144: THEN
145: FND_LOG.String(G_PROC_LEVEL,
146: G_PROC_NAME,
147: 'end');
148: END IF;
149:

Line 163: G_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;

159: X_Msg_Data OUT NOCOPY VARCHAR2
160: )
161: IS
162: G_PROC_NAME VARCHAR2(200) := 'asn.plsql.ASN_SALES_PVT.Opp_Terr_Assignment';
163: G_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;
164: G_STMT_LEVEL NUMBER := FND_LOG.LEVEL_STATEMENT;
165: G_DEBUG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
166:
167: BEGIN

Line 164: G_STMT_LEVEL NUMBER := FND_LOG.LEVEL_STATEMENT;

160: )
161: IS
162: G_PROC_NAME VARCHAR2(200) := 'asn.plsql.ASN_SALES_PVT.Opp_Terr_Assignment';
163: G_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;
164: G_STMT_LEVEL NUMBER := FND_LOG.LEVEL_STATEMENT;
165: G_DEBUG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
166:
167: BEGIN
168: IF (G_PROC_LEVEL >= G_DEBUG_LEVEL)

Line 165: G_DEBUG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

161: IS
162: G_PROC_NAME VARCHAR2(200) := 'asn.plsql.ASN_SALES_PVT.Opp_Terr_Assignment';
163: G_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;
164: G_STMT_LEVEL NUMBER := FND_LOG.LEVEL_STATEMENT;
165: G_DEBUG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
166:
167: BEGIN
168: IF (G_PROC_LEVEL >= G_DEBUG_LEVEL)
169: THEN

Line 170: FND_LOG.String(G_PROC_LEVEL,

166:
167: BEGIN
168: IF (G_PROC_LEVEL >= G_DEBUG_LEVEL)
169: THEN
170: FND_LOG.String(G_PROC_LEVEL,
171: G_PROC_NAME,
172: 'begin');
173: END IF;
174:

Line 177: FND_LOG.String(G_STMT_LEVEL,

173: END IF;
174:
175: IF (G_STMT_LEVEL >= G_DEBUG_LEVEL)
176: THEN
177: FND_LOG.String(G_STMT_LEVEL,
178: G_PROC_NAME,
179: 'Calling AS_OPP_TERRASSIGNMENT_PVT.Opp_Terr_Assignment...');
180: END IF;
181:

Line 195: FND_LOG.String(G_STMT_LEVEL,

191:
192:
193: IF (G_STMT_LEVEL >= G_DEBUG_LEVEL)
194: THEN
195: FND_LOG.String(G_STMT_LEVEL,
196: G_PROC_NAME,
197: 'Returning from AS_OPP_TERRASSIGNMENT_PVT.Opp_Terr_Assignment. '||
198: 'To remove duplicate access records.');
199: END IF;

Line 204: FND_LOG.String(G_PROC_LEVEL,

200:
201:
202: IF (G_PROC_LEVEL >= G_DEBUG_LEVEL)
203: THEN
204: FND_LOG.String(G_PROC_LEVEL,
205: G_PROC_NAME,
206: 'end');
207: END IF;
208: