eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_CONTRACT_SEQ_PVT dependencies on OKC_DEBUG

Line 22: okc_debug.set_indentation('create_seq_header');

18: --
19: -- Call Simple API
20: --
21: IF (l_debug = 'Y') THEN
22: okc_debug.set_indentation('create_seq_header');
23: okc_debug.log('100: Entering create_seq_header', 2);
24: END IF;
25: okc_ksq_pvt.insert_row(
26: p_api_version,

Line 23: okc_debug.log('100: Entering create_seq_header', 2);

19: -- Call Simple API
20: --
21: IF (l_debug = 'Y') THEN
22: okc_debug.set_indentation('create_seq_header');
23: okc_debug.log('100: Entering create_seq_header', 2);
24: END IF;
25: okc_ksq_pvt.insert_row(
26: p_api_version,
27: p_init_msg_list,

Line 34: okc_debug.log('200: Exiting create_seq_header', 2);

30: x_msg_data,
31: p_ksqv_rec,
32: x_ksqv_rec);
33: IF (l_debug = 'Y') THEN
34: okc_debug.log('200: Exiting create_seq_header', 2);
35: okc_debug.reset_indentation;
36: END IF;
37: END create_seq_header;
38:

Line 35: okc_debug.reset_indentation;

31: p_ksqv_rec,
32: x_ksqv_rec);
33: IF (l_debug = 'Y') THEN
34: okc_debug.log('200: Exiting create_seq_header', 2);
35: okc_debug.reset_indentation;
36: END IF;
37: END create_seq_header;
38:
39: PROCEDURE create_seq_header(

Line 49: okc_debug.set_indentation('create_seq_header');

45: p_ksqv_tbl IN ksqv_tbl_type,
46: x_ksqv_tbl OUT NOCOPY ksqv_tbl_type) IS
47: BEGIN
48: IF (l_debug = 'Y') THEN
49: okc_debug.set_indentation('create_seq_header');
50: okc_debug.log('300: Entering create_seq_header', 2);
51: END IF;
52: okc_ksq_pvt.insert_row(
53: p_api_version,

Line 50: okc_debug.log('300: Entering create_seq_header', 2);

46: x_ksqv_tbl OUT NOCOPY ksqv_tbl_type) IS
47: BEGIN
48: IF (l_debug = 'Y') THEN
49: okc_debug.set_indentation('create_seq_header');
50: okc_debug.log('300: Entering create_seq_header', 2);
51: END IF;
52: okc_ksq_pvt.insert_row(
53: p_api_version,
54: p_init_msg_list,

Line 61: okc_debug.log('400: Exiting create_seq_header', 2);

57: x_msg_data,
58: p_ksqv_tbl,
59: x_ksqv_tbl);
60: IF (l_debug = 'Y') THEN
61: okc_debug.log('400: Exiting create_seq_header', 2);
62: okc_debug.reset_indentation;
63: END IF;
64: END create_seq_header;
65:

Line 62: okc_debug.reset_indentation;

58: p_ksqv_tbl,
59: x_ksqv_tbl);
60: IF (l_debug = 'Y') THEN
61: okc_debug.log('400: Exiting create_seq_header', 2);
62: okc_debug.reset_indentation;
63: END IF;
64: END create_seq_header;
65:
66: PROCEDURE update_seq_header(

Line 76: okc_debug.set_indentation('update_seq_header');

72: p_ksqv_rec IN ksqv_rec_type,
73: x_ksqv_rec OUT NOCOPY ksqv_rec_type) IS
74: BEGIN
75: IF (l_debug = 'Y') THEN
76: okc_debug.set_indentation('update_seq_header');
77: okc_debug.log('500: Entering update_seq_header', 2);
78: END IF;
79: okc_ksq_pvt.update_row(
80: p_api_version,

Line 77: okc_debug.log('500: Entering update_seq_header', 2);

73: x_ksqv_rec OUT NOCOPY ksqv_rec_type) IS
74: BEGIN
75: IF (l_debug = 'Y') THEN
76: okc_debug.set_indentation('update_seq_header');
77: okc_debug.log('500: Entering update_seq_header', 2);
78: END IF;
79: okc_ksq_pvt.update_row(
80: p_api_version,
81: p_init_msg_list,

Line 88: okc_debug.log('600: Exiting update_seq_header', 2);

84: x_msg_data,
85: p_ksqv_rec,
86: x_ksqv_rec);
87: IF (l_debug = 'Y') THEN
88: okc_debug.log('600: Exiting update_seq_header', 2);
89: okc_debug.reset_indentation;
90: END IF;
91: END update_seq_header;
92:

Line 89: okc_debug.reset_indentation;

85: p_ksqv_rec,
86: x_ksqv_rec);
87: IF (l_debug = 'Y') THEN
88: okc_debug.log('600: Exiting update_seq_header', 2);
89: okc_debug.reset_indentation;
90: END IF;
91: END update_seq_header;
92:
93: PROCEDURE update_seq_header(

Line 103: okc_debug.set_indentation('update_seq_header');

99: p_ksqv_tbl IN ksqv_tbl_type,
100: x_ksqv_tbl OUT NOCOPY ksqv_tbl_type) IS
101: BEGIN
102: IF (l_debug = 'Y') THEN
103: okc_debug.set_indentation('update_seq_header');
104: okc_debug.log('700: Entering update_seq_header', 2);
105: END IF;
106: okc_ksq_pvt.update_row(
107: p_api_version,

Line 104: okc_debug.log('700: Entering update_seq_header', 2);

100: x_ksqv_tbl OUT NOCOPY ksqv_tbl_type) IS
101: BEGIN
102: IF (l_debug = 'Y') THEN
103: okc_debug.set_indentation('update_seq_header');
104: okc_debug.log('700: Entering update_seq_header', 2);
105: END IF;
106: okc_ksq_pvt.update_row(
107: p_api_version,
108: p_init_msg_list,

Line 115: okc_debug.log('800: Exiting update_seq_header', 2);

111: x_msg_data,
112: p_ksqv_tbl,
113: x_ksqv_tbl);
114: IF (l_debug = 'Y') THEN
115: okc_debug.log('800: Exiting update_seq_header', 2);
116: okc_debug.reset_indentation;
117: END IF;
118: END update_seq_header;
119:

Line 116: okc_debug.reset_indentation;

112: p_ksqv_tbl,
113: x_ksqv_tbl);
114: IF (l_debug = 'Y') THEN
115: okc_debug.log('800: Exiting update_seq_header', 2);
116: okc_debug.reset_indentation;
117: END IF;
118: END update_seq_header;
119:
120: PROCEDURE delete_seq_header(

Line 129: okc_debug.set_indentation('delete_seq_header');

125: x_msg_data OUT NOCOPY VARCHAR2,
126: p_ksqv_rec IN ksqv_rec_type) IS
127: BEGIN
128: IF (l_debug = 'Y') THEN
129: okc_debug.set_indentation('delete_seq_header');
130: okc_debug.log('900: Entering delete_seq_header', 2);
131: END IF;
132: okc_ksq_pvt.delete_row(
133: p_api_version,

Line 130: okc_debug.log('900: Entering delete_seq_header', 2);

126: p_ksqv_rec IN ksqv_rec_type) IS
127: BEGIN
128: IF (l_debug = 'Y') THEN
129: okc_debug.set_indentation('delete_seq_header');
130: okc_debug.log('900: Entering delete_seq_header', 2);
131: END IF;
132: okc_ksq_pvt.delete_row(
133: p_api_version,
134: p_init_msg_list,

Line 140: okc_debug.log('1000: Exiting delete_seq_header', 2);

136: x_msg_count,
137: x_msg_data,
138: p_ksqv_rec);
139: IF (l_debug = 'Y') THEN
140: okc_debug.log('1000: Exiting delete_seq_header', 2);
141: okc_debug.reset_indentation;
142: END IF;
143: END delete_seq_header;
144:

Line 141: okc_debug.reset_indentation;

137: x_msg_data,
138: p_ksqv_rec);
139: IF (l_debug = 'Y') THEN
140: okc_debug.log('1000: Exiting delete_seq_header', 2);
141: okc_debug.reset_indentation;
142: END IF;
143: END delete_seq_header;
144:
145: PROCEDURE delete_seq_header(

Line 154: okc_debug.set_indentation('delete_seq_header');

150: x_msg_data OUT NOCOPY VARCHAR2,
151: p_ksqv_tbl IN ksqv_tbl_type) IS
152: BEGIN
153: IF (l_debug = 'Y') THEN
154: okc_debug.set_indentation('delete_seq_header');
155: okc_debug.log('1100: Entering delete_seq_header', 2);
156: END IF;
157: okc_ksq_pvt.delete_row(
158: p_api_version,

Line 155: okc_debug.log('1100: Entering delete_seq_header', 2);

151: p_ksqv_tbl IN ksqv_tbl_type) IS
152: BEGIN
153: IF (l_debug = 'Y') THEN
154: okc_debug.set_indentation('delete_seq_header');
155: okc_debug.log('1100: Entering delete_seq_header', 2);
156: END IF;
157: okc_ksq_pvt.delete_row(
158: p_api_version,
159: p_init_msg_list,

Line 165: okc_debug.log('1200: Exiting delete_seq_header', 2);

161: x_msg_count,
162: x_msg_data,
163: p_ksqv_tbl);
164: IF (l_debug = 'Y') THEN
165: okc_debug.log('1200: Exiting delete_seq_header', 2);
166: okc_debug.reset_indentation;
167: END IF;
168: END delete_seq_header;
169:

Line 166: okc_debug.reset_indentation;

162: x_msg_data,
163: p_ksqv_tbl);
164: IF (l_debug = 'Y') THEN
165: okc_debug.log('1200: Exiting delete_seq_header', 2);
166: okc_debug.reset_indentation;
167: END IF;
168: END delete_seq_header;
169:
170: PROCEDURE lock_seq_header(

Line 179: okc_debug.set_indentation('lock_seq_header');

175: x_msg_data OUT NOCOPY VARCHAR2,
176: p_ksqv_rec IN ksqv_rec_type) IS
177: BEGIN
178: IF (l_debug = 'Y') THEN
179: okc_debug.set_indentation('lock_seq_header');
180: okc_debug.log('1300: Entering lock_seq_header', 2);
181: END IF;
182: okc_ksq_pvt.lock_row(
183: p_api_version,

Line 180: okc_debug.log('1300: Entering lock_seq_header', 2);

176: p_ksqv_rec IN ksqv_rec_type) IS
177: BEGIN
178: IF (l_debug = 'Y') THEN
179: okc_debug.set_indentation('lock_seq_header');
180: okc_debug.log('1300: Entering lock_seq_header', 2);
181: END IF;
182: okc_ksq_pvt.lock_row(
183: p_api_version,
184: p_init_msg_list,

Line 190: okc_debug.log('1400: Exiting lock_seq_header', 2);

186: x_msg_count,
187: x_msg_data,
188: p_ksqv_rec);
189: IF (l_debug = 'Y') THEN
190: okc_debug.log('1400: Exiting lock_seq_header', 2);
191: okc_debug.reset_indentation;
192: END IF;
193: END lock_seq_header;
194:

Line 191: okc_debug.reset_indentation;

187: x_msg_data,
188: p_ksqv_rec);
189: IF (l_debug = 'Y') THEN
190: okc_debug.log('1400: Exiting lock_seq_header', 2);
191: okc_debug.reset_indentation;
192: END IF;
193: END lock_seq_header;
194:
195: PROCEDURE lock_seq_header(

Line 204: okc_debug.set_indentation('lock_seq_header');

200: x_msg_data OUT NOCOPY VARCHAR2,
201: p_ksqv_tbl IN ksqv_tbl_type) IS
202: BEGIN
203: IF (l_debug = 'Y') THEN
204: okc_debug.set_indentation('lock_seq_header');
205: okc_debug.log('1500: Entering lock_seq_header', 2);
206: END IF;
207: okc_ksq_pvt.lock_row(
208: p_api_version,

Line 205: okc_debug.log('1500: Entering lock_seq_header', 2);

201: p_ksqv_tbl IN ksqv_tbl_type) IS
202: BEGIN
203: IF (l_debug = 'Y') THEN
204: okc_debug.set_indentation('lock_seq_header');
205: okc_debug.log('1500: Entering lock_seq_header', 2);
206: END IF;
207: okc_ksq_pvt.lock_row(
208: p_api_version,
209: p_init_msg_list,

Line 215: okc_debug.log('1600: Exiting lock_seq_header', 2);

211: x_msg_count,
212: x_msg_data,
213: p_ksqv_tbl);
214: IF (l_debug = 'Y') THEN
215: okc_debug.log('1600: Exiting lock_seq_header', 2);
216: okc_debug.reset_indentation;
217: END IF;
218: END lock_seq_header;
219:

Line 216: okc_debug.reset_indentation;

212: x_msg_data,
213: p_ksqv_tbl);
214: IF (l_debug = 'Y') THEN
215: okc_debug.log('1600: Exiting lock_seq_header', 2);
216: okc_debug.reset_indentation;
217: END IF;
218: END lock_seq_header;
219:
220: PROCEDURE validate_seq_header(

Line 229: okc_debug.set_indentation('validate_seq_header');

225: x_msg_data OUT NOCOPY VARCHAR2,
226: p_ksqv_rec IN ksqv_rec_type) IS
227: BEGIN
228: IF (l_debug = 'Y') THEN
229: okc_debug.set_indentation('validate_seq_header');
230: okc_debug.log('1700: Entering validate_seq_header', 2);
231: END IF;
232: okc_ksq_pvt.validate_row(
233: p_api_version,

Line 230: okc_debug.log('1700: Entering validate_seq_header', 2);

226: p_ksqv_rec IN ksqv_rec_type) IS
227: BEGIN
228: IF (l_debug = 'Y') THEN
229: okc_debug.set_indentation('validate_seq_header');
230: okc_debug.log('1700: Entering validate_seq_header', 2);
231: END IF;
232: okc_ksq_pvt.validate_row(
233: p_api_version,
234: p_init_msg_list,

Line 240: okc_debug.log('1800: Exiting validate_seq_header', 2);

236: x_msg_count,
237: x_msg_data,
238: p_ksqv_rec);
239: IF (l_debug = 'Y') THEN
240: okc_debug.log('1800: Exiting validate_seq_header', 2);
241: okc_debug.reset_indentation;
242: END IF;
243: END validate_seq_header;
244:

Line 241: okc_debug.reset_indentation;

237: x_msg_data,
238: p_ksqv_rec);
239: IF (l_debug = 'Y') THEN
240: okc_debug.log('1800: Exiting validate_seq_header', 2);
241: okc_debug.reset_indentation;
242: END IF;
243: END validate_seq_header;
244:
245: PROCEDURE validate_seq_header(

Line 254: okc_debug.set_indentation('validate_seq_header');

250: x_msg_data OUT NOCOPY VARCHAR2,
251: p_ksqv_tbl IN ksqv_tbl_type) IS
252: BEGIN
253: IF (l_debug = 'Y') THEN
254: okc_debug.set_indentation('validate_seq_header');
255: okc_debug.log('1900: Entering validate_seq_header', 2);
256: END IF;
257: okc_ksq_pvt.validate_row(
258: p_api_version,

Line 255: okc_debug.log('1900: Entering validate_seq_header', 2);

251: p_ksqv_tbl IN ksqv_tbl_type) IS
252: BEGIN
253: IF (l_debug = 'Y') THEN
254: okc_debug.set_indentation('validate_seq_header');
255: okc_debug.log('1900: Entering validate_seq_header', 2);
256: END IF;
257: okc_ksq_pvt.validate_row(
258: p_api_version,
259: p_init_msg_list,

Line 265: okc_debug.log('2000: Exiting validate_seq_header', 2);

261: x_msg_count,
262: x_msg_data,
263: p_ksqv_tbl);
264: IF (l_debug = 'Y') THEN
265: okc_debug.log('2000: Exiting validate_seq_header', 2);
266: okc_debug.reset_indentation;
267: END IF;
268: END validate_seq_header;
269:

Line 266: okc_debug.reset_indentation;

262: x_msg_data,
263: p_ksqv_tbl);
264: IF (l_debug = 'Y') THEN
265: okc_debug.log('2000: Exiting validate_seq_header', 2);
266: okc_debug.reset_indentation;
267: END IF;
268: END validate_seq_header;
269:
270: PROCEDURE create_seq_lines(

Line 331: okc_debug.set_indentation('create_seq_lines');

327: --END NPALEPU
328:
329: BEGIN
330: IF (l_debug = 'Y') THEN
331: okc_debug.set_indentation('create_seq_lines');
332: okc_debug.log('2100: Entering create_seq_lines', 2);
333: END IF;
334: x_return_status := OKC_API.G_RET_STS_SUCCESS;
335: -- First check if the same prefix and suffix is already in use

Line 332: okc_debug.log('2100: Entering create_seq_lines', 2);

328:
329: BEGIN
330: IF (l_debug = 'Y') THEN
331: okc_debug.set_indentation('create_seq_lines');
332: okc_debug.log('2100: Entering create_seq_lines', 2);
333: END IF;
334: x_return_status := OKC_API.G_RET_STS_SUCCESS;
335: -- First check if the same prefix and suffix is already in use
336: Open c1(l_lsqv_rec.line_code,

Line 451: okc_debug.log('2200: Exiting create_seq_lines', 2);

447: RAISE G_EXCEPTION_HALT_VALIDATION;
448: End If;
449: End If;
450: IF (l_debug = 'Y') THEN
451: okc_debug.log('2200: Exiting create_seq_lines', 2);
452: okc_debug.reset_indentation;
453: END IF;
454: EXCEPTION
455: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 452: okc_debug.reset_indentation;

448: End If;
449: End If;
450: IF (l_debug = 'Y') THEN
451: okc_debug.log('2200: Exiting create_seq_lines', 2);
452: okc_debug.reset_indentation;
453: END IF;
454: EXCEPTION
455: WHEN G_EXCEPTION_HALT_VALIDATION THEN
456: IF (l_debug = 'Y') THEN

Line 457: okc_debug.log('2300: Exiting create_seq_lines', 2);

453: END IF;
454: EXCEPTION
455: WHEN G_EXCEPTION_HALT_VALIDATION THEN
456: IF (l_debug = 'Y') THEN
457: okc_debug.log('2300: Exiting create_seq_lines', 2);
458: okc_debug.reset_indentation;
459: END IF;
460: --npalepu added on 25-AUG-2006 for bug # 5488217
461: IF ORG_ID_CSR%ISOPEN THEN

Line 458: okc_debug.reset_indentation;

454: EXCEPTION
455: WHEN G_EXCEPTION_HALT_VALIDATION THEN
456: IF (l_debug = 'Y') THEN
457: okc_debug.log('2300: Exiting create_seq_lines', 2);
458: okc_debug.reset_indentation;
459: END IF;
460: --npalepu added on 25-AUG-2006 for bug # 5488217
461: IF ORG_ID_CSR%ISOPEN THEN
462: CLOSE ORG_ID_CSR;

Line 474: okc_debug.log('2400: Exiting create_seq_lines', 2);

470: p_token2 => g_sqlerrm_token,
471: p_token2_value => sqlerrm);
472: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
473: IF (l_debug = 'Y') THEN
474: okc_debug.log('2400: Exiting create_seq_lines', 2);
475: okc_debug.reset_indentation;
476: END IF;
477: --npalepu added on 25-AUG-2006 for bug # 5488217
478: IF ORG_ID_CSR%ISOPEN THEN

Line 475: okc_debug.reset_indentation;

471: p_token2_value => sqlerrm);
472: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
473: IF (l_debug = 'Y') THEN
474: okc_debug.log('2400: Exiting create_seq_lines', 2);
475: okc_debug.reset_indentation;
476: END IF;
477: --npalepu added on 25-AUG-2006 for bug # 5488217
478: IF ORG_ID_CSR%ISOPEN THEN
479: CLOSE ORG_ID_CSR;

Line 496: okc_debug.set_indentation('create_seq_lines');

492: i NUMBER := 0;
493: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
494: BEGIN
495: IF (l_debug = 'Y') THEN
496: okc_debug.set_indentation('create_seq_lines');
497: okc_debug.log('2500: Entering create_seq_lines', 2);
498: END IF;
499: x_return_status := OKC_API.G_RET_STS_SUCCESS;
500: IF (p_lsqv_tbl.COUNT > 0) THEN

Line 497: okc_debug.log('2500: Entering create_seq_lines', 2);

493: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
494: BEGIN
495: IF (l_debug = 'Y') THEN
496: okc_debug.set_indentation('create_seq_lines');
497: okc_debug.log('2500: Entering create_seq_lines', 2);
498: END IF;
499: x_return_status := OKC_API.G_RET_STS_SUCCESS;
500: IF (p_lsqv_tbl.COUNT > 0) THEN
501: i := p_lsqv_tbl.FIRST;

Line 524: okc_debug.log('2600: Exiting create_seq_lines', 2);

520: i := p_lsqv_tbl.NEXT(i);
521: END LOOP;
522: END IF;
523: IF (l_debug = 'Y') THEN
524: okc_debug.log('2600: Exiting create_seq_lines', 2);
525: okc_debug.reset_indentation;
526: END IF;
527: EXCEPTION
528: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 525: okc_debug.reset_indentation;

521: END LOOP;
522: END IF;
523: IF (l_debug = 'Y') THEN
524: okc_debug.log('2600: Exiting create_seq_lines', 2);
525: okc_debug.reset_indentation;
526: END IF;
527: EXCEPTION
528: WHEN G_EXCEPTION_HALT_VALIDATION THEN
529: IF (l_debug = 'Y') THEN

Line 530: okc_debug.log('2700: Exiting create_seq_lines', 2);

526: END IF;
527: EXCEPTION
528: WHEN G_EXCEPTION_HALT_VALIDATION THEN
529: IF (l_debug = 'Y') THEN
530: okc_debug.log('2700: Exiting create_seq_lines', 2);
531: okc_debug.reset_indentation;
532: END IF;
533: WHEN OTHERS THEN
534: OKC_API.set_message(p_app_name => g_app_name,

Line 531: okc_debug.reset_indentation;

527: EXCEPTION
528: WHEN G_EXCEPTION_HALT_VALIDATION THEN
529: IF (l_debug = 'Y') THEN
530: okc_debug.log('2700: Exiting create_seq_lines', 2);
531: okc_debug.reset_indentation;
532: END IF;
533: WHEN OTHERS THEN
534: OKC_API.set_message(p_app_name => g_app_name,
535: p_msg_name => g_unexpected_error,

Line 542: okc_debug.log('2800: Exiting create_seq_lines', 2);

538: p_token2 => g_sqlerrm_token,
539: p_token2_value => sqlerrm);
540: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
541: IF (l_debug = 'Y') THEN
542: okc_debug.log('2800: Exiting create_seq_lines', 2);
543: okc_debug.reset_indentation;
544: END IF;
545: END create_seq_lines;
546:

Line 543: okc_debug.reset_indentation;

539: p_token2_value => sqlerrm);
540: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
541: IF (l_debug = 'Y') THEN
542: okc_debug.log('2800: Exiting create_seq_lines', 2);
543: okc_debug.reset_indentation;
544: END IF;
545: END create_seq_lines;
546:
547: PROCEDURE update_seq_lines(

Line 557: okc_debug.set_indentation('update_seq_lines');

553: p_lsqv_rec IN lsqv_rec_type,
554: x_lsqv_rec OUT NOCOPY lsqv_rec_type) IS
555: BEGIN
556: IF (l_debug = 'Y') THEN
557: okc_debug.set_indentation('update_seq_lines');
558: okc_debug.log('2900: Entering update_seq_lines', 2);
559: END IF;
560: okc_lsq_pvt.update_row(
561: p_api_version,

Line 558: okc_debug.log('2900: Entering update_seq_lines', 2);

554: x_lsqv_rec OUT NOCOPY lsqv_rec_type) IS
555: BEGIN
556: IF (l_debug = 'Y') THEN
557: okc_debug.set_indentation('update_seq_lines');
558: okc_debug.log('2900: Entering update_seq_lines', 2);
559: END IF;
560: okc_lsq_pvt.update_row(
561: p_api_version,
562: p_init_msg_list,

Line 569: okc_debug.log('3000: Exiting update_seq_lines', 2);

565: x_msg_data,
566: p_lsqv_rec,
567: x_lsqv_rec);
568: IF (l_debug = 'Y') THEN
569: okc_debug.log('3000: Exiting update_seq_lines', 2);
570: okc_debug.reset_indentation;
571: END IF;
572: END update_seq_lines;
573:

Line 570: okc_debug.reset_indentation;

566: p_lsqv_rec,
567: x_lsqv_rec);
568: IF (l_debug = 'Y') THEN
569: okc_debug.log('3000: Exiting update_seq_lines', 2);
570: okc_debug.reset_indentation;
571: END IF;
572: END update_seq_lines;
573:
574: PROCEDURE update_seq_lines(

Line 584: okc_debug.set_indentation('update_seq_lines');

580: p_lsqv_tbl IN lsqv_tbl_type,
581: x_lsqv_tbl OUT NOCOPY lsqv_tbl_type) IS
582: BEGIN
583: IF (l_debug = 'Y') THEN
584: okc_debug.set_indentation('update_seq_lines');
585: okc_debug.log('3100: Entering update_seq_lines', 2);
586: END IF;
587: okc_lsq_pvt.update_row(
588: p_api_version,

Line 585: okc_debug.log('3100: Entering update_seq_lines', 2);

581: x_lsqv_tbl OUT NOCOPY lsqv_tbl_type) IS
582: BEGIN
583: IF (l_debug = 'Y') THEN
584: okc_debug.set_indentation('update_seq_lines');
585: okc_debug.log('3100: Entering update_seq_lines', 2);
586: END IF;
587: okc_lsq_pvt.update_row(
588: p_api_version,
589: p_init_msg_list,

Line 596: okc_debug.log('3200: Exiting update_seq_lines', 2);

592: x_msg_data,
593: p_lsqv_tbl,
594: x_lsqv_tbl);
595: IF (l_debug = 'Y') THEN
596: okc_debug.log('3200: Exiting update_seq_lines', 2);
597: okc_debug.reset_indentation;
598: END IF;
599: END update_seq_lines;
600:

Line 597: okc_debug.reset_indentation;

593: p_lsqv_tbl,
594: x_lsqv_tbl);
595: IF (l_debug = 'Y') THEN
596: okc_debug.log('3200: Exiting update_seq_lines', 2);
597: okc_debug.reset_indentation;
598: END IF;
599: END update_seq_lines;
600:
601: PROCEDURE delete_seq_lines(

Line 610: okc_debug.set_indentation('delete_seq_lines');

606: x_msg_data OUT NOCOPY VARCHAR2,
607: p_lsqv_rec IN lsqv_rec_type) IS
608: BEGIN
609: IF (l_debug = 'Y') THEN
610: okc_debug.set_indentation('delete_seq_lines');
611: okc_debug.log('3300: Entering delete_seq_lines', 2);
612: END IF;
613: okc_lsq_pvt.delete_row(
614: p_api_version,

Line 611: okc_debug.log('3300: Entering delete_seq_lines', 2);

607: p_lsqv_rec IN lsqv_rec_type) IS
608: BEGIN
609: IF (l_debug = 'Y') THEN
610: okc_debug.set_indentation('delete_seq_lines');
611: okc_debug.log('3300: Entering delete_seq_lines', 2);
612: END IF;
613: okc_lsq_pvt.delete_row(
614: p_api_version,
615: p_init_msg_list,

Line 621: okc_debug.log('3400: Exiting delete_seq_lines', 2);

617: x_msg_count,
618: x_msg_data,
619: p_lsqv_rec);
620: IF (l_debug = 'Y') THEN
621: okc_debug.log('3400: Exiting delete_seq_lines', 2);
622: okc_debug.reset_indentation;
623: END IF;
624: END delete_seq_lines;
625:

Line 622: okc_debug.reset_indentation;

618: x_msg_data,
619: p_lsqv_rec);
620: IF (l_debug = 'Y') THEN
621: okc_debug.log('3400: Exiting delete_seq_lines', 2);
622: okc_debug.reset_indentation;
623: END IF;
624: END delete_seq_lines;
625:
626: PROCEDURE delete_seq_lines(

Line 635: okc_debug.set_indentation('delete_seq_lines');

631: x_msg_data OUT NOCOPY VARCHAR2,
632: p_lsqv_tbl IN lsqv_tbl_type) IS
633: BEGIN
634: IF (l_debug = 'Y') THEN
635: okc_debug.set_indentation('delete_seq_lines');
636: okc_debug.log('3500: Entering delete_seq_lines', 2);
637: END IF;
638: okc_lsq_pvt.delete_row(
639: p_api_version,

Line 636: okc_debug.log('3500: Entering delete_seq_lines', 2);

632: p_lsqv_tbl IN lsqv_tbl_type) IS
633: BEGIN
634: IF (l_debug = 'Y') THEN
635: okc_debug.set_indentation('delete_seq_lines');
636: okc_debug.log('3500: Entering delete_seq_lines', 2);
637: END IF;
638: okc_lsq_pvt.delete_row(
639: p_api_version,
640: p_init_msg_list,

Line 646: okc_debug.log('3600: Exiting delete_seq_lines', 2);

642: x_msg_count,
643: x_msg_data,
644: p_lsqv_tbl);
645: IF (l_debug = 'Y') THEN
646: okc_debug.log('3600: Exiting delete_seq_lines', 2);
647: okc_debug.reset_indentation;
648: END IF;
649: END delete_seq_lines;
650:

Line 647: okc_debug.reset_indentation;

643: x_msg_data,
644: p_lsqv_tbl);
645: IF (l_debug = 'Y') THEN
646: okc_debug.log('3600: Exiting delete_seq_lines', 2);
647: okc_debug.reset_indentation;
648: END IF;
649: END delete_seq_lines;
650:
651: PROCEDURE lock_seq_lines(

Line 660: okc_debug.set_indentation('lock_seq_lines');

656: x_msg_data OUT NOCOPY VARCHAR2,
657: p_lsqv_rec IN lsqv_rec_type) IS
658: BEGIN
659: IF (l_debug = 'Y') THEN
660: okc_debug.set_indentation('lock_seq_lines');
661: okc_debug.log('3700: Entering lock_seq_lines', 2);
662: END IF;
663: okc_lsq_pvt.lock_row(
664: p_api_version,

Line 661: okc_debug.log('3700: Entering lock_seq_lines', 2);

657: p_lsqv_rec IN lsqv_rec_type) IS
658: BEGIN
659: IF (l_debug = 'Y') THEN
660: okc_debug.set_indentation('lock_seq_lines');
661: okc_debug.log('3700: Entering lock_seq_lines', 2);
662: END IF;
663: okc_lsq_pvt.lock_row(
664: p_api_version,
665: p_init_msg_list,

Line 671: okc_debug.log('3800: Exiting lock_seq_lines', 2);

667: x_msg_count,
668: x_msg_data,
669: p_lsqv_rec);
670: IF (l_debug = 'Y') THEN
671: okc_debug.log('3800: Exiting lock_seq_lines', 2);
672: okc_debug.reset_indentation;
673: END IF;
674: END lock_seq_lines;
675:

Line 672: okc_debug.reset_indentation;

668: x_msg_data,
669: p_lsqv_rec);
670: IF (l_debug = 'Y') THEN
671: okc_debug.log('3800: Exiting lock_seq_lines', 2);
672: okc_debug.reset_indentation;
673: END IF;
674: END lock_seq_lines;
675:
676: PROCEDURE lock_seq_lines(

Line 685: okc_debug.set_indentation('lock_seq_lines');

681: x_msg_data OUT NOCOPY VARCHAR2,
682: p_lsqv_tbl IN lsqv_tbl_type) IS
683: BEGIN
684: IF (l_debug = 'Y') THEN
685: okc_debug.set_indentation('lock_seq_lines');
686: okc_debug.log('3900: Entering lock_seq_lines', 2);
687: END IF;
688: okc_lsq_pvt.lock_row(
689: p_api_version,

Line 686: okc_debug.log('3900: Entering lock_seq_lines', 2);

682: p_lsqv_tbl IN lsqv_tbl_type) IS
683: BEGIN
684: IF (l_debug = 'Y') THEN
685: okc_debug.set_indentation('lock_seq_lines');
686: okc_debug.log('3900: Entering lock_seq_lines', 2);
687: END IF;
688: okc_lsq_pvt.lock_row(
689: p_api_version,
690: p_init_msg_list,

Line 696: okc_debug.log('4000: Exiting lock_seq_lines', 2);

692: x_msg_count,
693: x_msg_data,
694: p_lsqv_tbl);
695: IF (l_debug = 'Y') THEN
696: okc_debug.log('4000: Exiting lock_seq_lines', 2);
697: okc_debug.reset_indentation;
698: END IF;
699: END lock_seq_lines;
700:

Line 697: okc_debug.reset_indentation;

693: x_msg_data,
694: p_lsqv_tbl);
695: IF (l_debug = 'Y') THEN
696: okc_debug.log('4000: Exiting lock_seq_lines', 2);
697: okc_debug.reset_indentation;
698: END IF;
699: END lock_seq_lines;
700:
701: PROCEDURE validate_seq_lines(

Line 710: okc_debug.set_indentation('validate_seq_lines');

706: x_msg_data OUT NOCOPY VARCHAR2,
707: p_lsqv_rec IN lsqv_rec_type) IS
708: BEGIN
709: IF (l_debug = 'Y') THEN
710: okc_debug.set_indentation('validate_seq_lines');
711: okc_debug.log('4100: Entering validate_seq_lines', 2);
712: END IF;
713: okc_lsq_pvt.validate_row(
714: p_api_version,

Line 711: okc_debug.log('4100: Entering validate_seq_lines', 2);

707: p_lsqv_rec IN lsqv_rec_type) IS
708: BEGIN
709: IF (l_debug = 'Y') THEN
710: okc_debug.set_indentation('validate_seq_lines');
711: okc_debug.log('4100: Entering validate_seq_lines', 2);
712: END IF;
713: okc_lsq_pvt.validate_row(
714: p_api_version,
715: p_init_msg_list,

Line 721: okc_debug.log('4200: Exiting validate_seq_lines', 2);

717: x_msg_count,
718: x_msg_data,
719: p_lsqv_rec);
720: IF (l_debug = 'Y') THEN
721: okc_debug.log('4200: Exiting validate_seq_lines', 2);
722: okc_debug.reset_indentation;
723: END IF;
724: END validate_seq_lines;
725:

Line 722: okc_debug.reset_indentation;

718: x_msg_data,
719: p_lsqv_rec);
720: IF (l_debug = 'Y') THEN
721: okc_debug.log('4200: Exiting validate_seq_lines', 2);
722: okc_debug.reset_indentation;
723: END IF;
724: END validate_seq_lines;
725:
726: PROCEDURE validate_seq_lines(

Line 735: okc_debug.set_indentation('validate_seq_lines');

731: x_msg_data OUT NOCOPY VARCHAR2,
732: p_lsqv_tbl IN lsqv_tbl_type) IS
733: BEGIN
734: IF (l_debug = 'Y') THEN
735: okc_debug.set_indentation('validate_seq_lines');
736: okc_debug.log('4300: Entering validate_seq_lines', 2);
737: END IF;
738: okc_lsq_pvt.validate_row(
739: p_api_version,

Line 736: okc_debug.log('4300: Entering validate_seq_lines', 2);

732: p_lsqv_tbl IN lsqv_tbl_type) IS
733: BEGIN
734: IF (l_debug = 'Y') THEN
735: okc_debug.set_indentation('validate_seq_lines');
736: okc_debug.log('4300: Entering validate_seq_lines', 2);
737: END IF;
738: okc_lsq_pvt.validate_row(
739: p_api_version,
740: p_init_msg_list,

Line 746: okc_debug.log('4400: Exiting validate_seq_lines', 2);

742: x_msg_count,
743: x_msg_data,
744: p_lsqv_tbl);
745: IF (l_debug = 'Y') THEN
746: okc_debug.log('4400: Exiting validate_seq_lines', 2);
747: okc_debug.reset_indentation;
748: END IF;
749: END validate_seq_lines;
750:

Line 747: okc_debug.reset_indentation;

743: x_msg_data,
744: p_lsqv_tbl);
745: IF (l_debug = 'Y') THEN
746: okc_debug.log('4400: Exiting validate_seq_lines', 2);
747: okc_debug.reset_indentation;
748: END IF;
749: END validate_seq_lines;
750:
751: --

Line 760: okc_debug.set_indentation('Is_K_Autogenerated');

756: p_scs_code Varchar2,
757: x_return_status OUT NOCOPY Varchar2) IS
758: BEGIN
759: IF (l_debug = 'Y') THEN
760: okc_debug.set_indentation('Is_K_Autogenerated');
761: okc_debug.log('4500: Entering Is_K_Autogenerated', 2);
762: END IF;
763: --
764: -- Call Simple API

Line 761: okc_debug.log('4500: Entering Is_K_Autogenerated', 2);

757: x_return_status OUT NOCOPY Varchar2) IS
758: BEGIN
759: IF (l_debug = 'Y') THEN
760: okc_debug.set_indentation('Is_K_Autogenerated');
761: okc_debug.log('4500: Entering Is_K_Autogenerated', 2);
762: END IF;
763: --
764: -- Call Simple API
765: --

Line 770: okc_debug.log('4600: Exiting Is_K_Autogenerated', 2);

766: okc_ksq_pvt.Is_K_Autogenerated(
767: p_scs_code,
768: x_return_status);
769: IF (l_debug = 'Y') THEN
770: okc_debug.log('4600: Exiting Is_K_Autogenerated', 2);
771: okc_debug.reset_indentation;
772: END IF;
773: END Is_K_Autogenerated;
774:

Line 771: okc_debug.reset_indentation;

767: p_scs_code,
768: x_return_status);
769: IF (l_debug = 'Y') THEN
770: okc_debug.log('4600: Exiting Is_K_Autogenerated', 2);
771: okc_debug.reset_indentation;
772: END IF;
773: END Is_K_Autogenerated;
774:
775: --

Line 785: okc_debug.set_indentation('Get_K_Number');

781: x_contract_number OUT NOCOPY VARCHAR2,
782: x_return_status OUT NOCOPY VARCHAR2) IS
783: BEGIN
784: IF (l_debug = 'Y') THEN
785: okc_debug.set_indentation('Get_K_Number');
786: okc_debug.log('4700: Entering Get_K_Number', 2);
787: END IF;
788: --
789: -- Call Simple API

Line 786: okc_debug.log('4700: Entering Get_K_Number', 2);

782: x_return_status OUT NOCOPY VARCHAR2) IS
783: BEGIN
784: IF (l_debug = 'Y') THEN
785: okc_debug.set_indentation('Get_K_Number');
786: okc_debug.log('4700: Entering Get_K_Number', 2);
787: END IF;
788: --
789: -- Call Simple API
790: --

Line 797: okc_debug.log('4800: Exiting Get_K_Number', 2);

793: p_contract_number_modifier,
794: x_contract_number,
795: x_return_status);
796: IF (l_debug = 'Y') THEN
797: okc_debug.log('4800: Exiting Get_K_Number', 2);
798: okc_debug.reset_indentation;
799: END IF;
800: END Get_K_Number;
801:

Line 798: okc_debug.reset_indentation;

794: x_contract_number,
795: x_return_status);
796: IF (l_debug = 'Y') THEN
797: okc_debug.log('4800: Exiting Get_K_Number', 2);
798: okc_debug.reset_indentation;
799: END IF;
800: END Get_K_Number;
801:
802: END OKC_CONTRACT_SEQ_PVT;