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