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.FUN_SECURITY dependencies on FND_LOG

Line 5: g_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1: PACKAGE BODY FUN_SECURITY AS
2: /* $Header: FUNSECAB.pls 120.13 2006/09/15 10:04:10 bsilveir noship $*/
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'FUN_SECURITY';
5: g_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6:
7:
8:
9: /*-----------------------------------------------------

Line 27: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)

23: FROM fnd_object_instance_sets
24: WHERE instance_set_name IN ('FUN_TRX_BATCHES_SET','FUN_TRX_HEADERS_SET','FUN_DIST_LINES_SET');
25: BEGIN
26:
27: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
28: THEN
29: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
30: 'fun.plsql.fun_security.get_instance_set_ids','begin');
31: END IF;

Line 29: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

25: BEGIN
26:
27: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
28: THEN
29: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
30: 'fun.plsql.fun_security.get_instance_set_ids','begin');
31: END IF;
32:
33: FOR c_record IN c_get_instance_set_id

Line 44: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)

40: p_dist_lines_id := c_record.instance_set_id;
41: END IF;
42: END LOOP;
43:
44: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
45: THEN
46: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
47: 'fun.plsql.fun_security.get_instance_set_ids','end');
48: END IF;

Line 46: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

42: END LOOP;
43:
44: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
45: THEN
46: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
47: 'fun.plsql.fun_security.get_instance_set_ids','end');
48: END IF;
49:
50: END get_instance_set_ids;

Line 109: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)

105: BEGIN
106:
107: l_module := 'fun.plsql.fun_security.create_assign';
108:
109: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
110: THEN
111: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
112: l_module,'begin');
113: END IF;

Line 111: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

107: l_module := 'fun.plsql.fun_security.create_assign';
108:
109: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
110: THEN
111: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
112: l_module,'begin');
113: END IF;
114:
115: --Standard call to check for call compatibility.

Line 230: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)

226: l_tca_contact_record.party_rel_rec.relationship_id := l_relationship_id;
227: l_tca_contact_record.party_rel_rec.relationship_type := 'CONTACT';
228: l_tca_contact_record.party_rel_rec.status := 'A';
229:
230: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
231: THEN
232: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
233: l_module,'calling HZ_PARTY_CONTACT_V2PUB.update_org_contact');
234: END IF;

Line 232: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

228: l_tca_contact_record.party_rel_rec.status := 'A';
229:
230: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
231: THEN
232: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
233: l_module,'calling HZ_PARTY_CONTACT_V2PUB.update_org_contact');
234: END IF;
235:
236: HZ_PARTY_CONTACT_V2PUB.update_org_contact(

Line 248: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)

244: x_msg_data => x_msg_data
245: );
246: --dbms_output.put_line('1 : '||x_return_status||x_msg_count||x_msg_data);
247:
248: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
249: THEN
250: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
251: l_module, 'completed call to HZ_PARTY_CONTACT_V2PUB.update_org_contact'
252: || ' Status ' || x_return_status);

Line 250: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

246: --dbms_output.put_line('1 : '||x_return_status||x_msg_count||x_msg_data);
247:
248: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
249: THEN
250: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
251: l_module, 'completed call to HZ_PARTY_CONTACT_V2PUB.update_org_contact'
252: || ' Status ' || x_return_status);
253: END IF;
254:

Line 279: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)

275: l_tca_contact_role_record.org_contact_id := l_org_contact_id;
276: l_tca_contact_role_record.status := l_status;
277: l_tca_contact_role_record.created_by_module := 'FUN_AGIS';
278:
279: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
280: THEN
281: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
282: l_module,'calling HZ_PARTY_CONTACT_V2PUB.update_org_contact_role');
283: END IF;

Line 281: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

277: l_tca_contact_role_record.created_by_module := 'FUN_AGIS';
278:
279: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
280: THEN
281: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
282: l_module,'calling HZ_PARTY_CONTACT_V2PUB.update_org_contact_role');
283: END IF;
284:
285: HZ_PARTY_CONTACT_V2PUB.update_org_contact_role(

Line 295: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)

291: x_msg_data => x_msg_data
292: );
293: --dbms_output.put_line('2 : '||x_return_status||x_msg_count||x_msg_data);
294:
295: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
296: THEN
297: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
298: l_module, 'completed call to HZ_PARTY_CONTACT_V2PUB.update_org_contact_role'
299: || ' Status ' || x_return_status);

Line 297: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

293: --dbms_output.put_line('2 : '||x_return_status||x_msg_count||x_msg_data);
294:
295: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
296: THEN
297: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
298: l_module, 'completed call to HZ_PARTY_CONTACT_V2PUB.update_org_contact_role'
299: || ' Status ' || x_return_status);
300: END IF;
301:

Line 311: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)

307: END;
308: END IF; -- is_access_valid = 'N'
309: ELSE
310:
311: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
312: THEN
313: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
314: l_module,'calling fnd_grants_pkg.grant_function for FUN_TRX_BATCHES');
315: END IF;

Line 313: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

309: ELSE
310:
311: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
312: THEN
313: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
314: l_module,'calling fnd_grants_pkg.grant_function for FUN_TRX_BATCHES');
315: END IF;
316:
317: fnd_grants_pkg.grant_function (

Line 333: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)

329: x_errorcode => l_fnd_errorcode,
330: p_parameter1 => v_org_record.partyid
331: );
332:
333: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
334: THEN
335: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
336: l_module, 'completed call to fnd_grants_pkg.grant_function for FUN_TRX_BATCHES'
337: || ' Status ' || x_return_status);

Line 335: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

331: );
332:
333: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
334: THEN
335: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
336: l_module, 'completed call to fnd_grants_pkg.grant_function for FUN_TRX_BATCHES'
337: || ' Status ' || x_return_status);
338: END IF;
339:

Line 345: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)

341: THEN
342: RAISE FND_API.G_EXC_ERROR;
343: END IF;
344:
345: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
346: THEN
347: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
348: l_module,'calling fnd_grants_pkg.grant_function for FUN_TRX_HEADERS');
349: END IF;

Line 347: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

343: END IF;
344:
345: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
346: THEN
347: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
348: l_module,'calling fnd_grants_pkg.grant_function for FUN_TRX_HEADERS');
349: END IF;
350: fnd_grants_pkg.grant_function (
351: p_api_version => 1,

Line 366: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)

362: x_errorcode => l_fnd_errorcode,
363: p_parameter1 => v_org_record.partyid
364: );
365:
366: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
367: THEN
368: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
369: l_module, 'completed call to fnd_grants_pkg.grant_function for FUN_TRX_HEADERS'
370: || ' Status ' || x_return_status);

Line 368: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

364: );
365:
366: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
367: THEN
368: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
369: l_module, 'completed call to fnd_grants_pkg.grant_function for FUN_TRX_HEADERS'
370: || ' Status ' || x_return_status);
371: END IF;
372:

Line 378: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)

374: THEN
375: RAISE FND_API.G_EXC_ERROR;
376: END IF;
377:
378: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
379: THEN
380: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
381: l_module,'calling fnd_grants_pkg.grant_function for FUN_DIST_LINES');
382: END IF;

Line 380: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

376: END IF;
377:
378: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
379: THEN
380: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
381: l_module,'calling fnd_grants_pkg.grant_function for FUN_DIST_LINES');
382: END IF;
383: fnd_grants_pkg.grant_function (
384: p_api_version => 1,

Line 400: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)

396: p_parameter1 => v_org_record.partyid
397: );
398:
399:
400: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
401: THEN
402: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
403: l_module, 'completed call to fnd_grants_pkg.grant_function for FUN_DIST_LINES'
404: || ' Status ' || x_return_status);

Line 402: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

398:
399:
400: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
401: THEN
402: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
403: l_module, 'completed call to fnd_grants_pkg.grant_function for FUN_DIST_LINES'
404: || ' Status ' || x_return_status);
405: END IF;
406:

Line 454: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)

450: l_tca_contact_record.party_rel_rec.start_date := SYSDATE;
451: l_tca_contact_record.party_rel_rec.created_by_module := 'FUN_AGIS';
452: l_tca_contact_record.party_rel_rec.status := 'A';
453:
454: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
455: THEN
456: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
457: l_module,'calling HZ_PARTY_CONTACT_V2PUB.create_org_contact');
458: END IF;

Line 456: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

452: l_tca_contact_record.party_rel_rec.status := 'A';
453:
454: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
455: THEN
456: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
457: l_module,'calling HZ_PARTY_CONTACT_V2PUB.create_org_contact');
458: END IF;
459:
460: HZ_PARTY_CONTACT_V2PUB.create_org_contact(

Line 473: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)

469: x_msg_data => x_msg_data
470: );
471:
472: --dbms_output.put_line('3 : '||x_return_status||x_msg_count||x_msg_data);
473: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
474: THEN
475: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
476: l_module, 'completed call to HZ_PARTY_CONTACT_V2PUB.create_org_contact'
477: || ' Status ' || x_return_status);

Line 475: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

471:
472: --dbms_output.put_line('3 : '||x_return_status||x_msg_count||x_msg_data);
473: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
474: THEN
475: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
476: l_module, 'completed call to HZ_PARTY_CONTACT_V2PUB.create_org_contact'
477: || ' Status ' || x_return_status);
478: END IF;
479:

Line 490: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)

486: l_tca_contact_role_record.status := 'A';
487: l_tca_contact_role_record.org_contact_id := l_org_contact_id;
488: l_tca_contact_role_record.created_by_module := 'FUN_AGIS';
489:
490: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
491: THEN
492: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
493: l_module,'calling HZ_PARTY_CONTACT_V2PUB.create_org_contact_role');
494: END IF;

Line 492: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

488: l_tca_contact_role_record.created_by_module := 'FUN_AGIS';
489:
490: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
491: THEN
492: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
493: l_module,'calling HZ_PARTY_CONTACT_V2PUB.create_org_contact_role');
494: END IF;
495:
496: HZ_PARTY_CONTACT_V2PUB.create_org_contact_role(

Line 506: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)

502: x_msg_data => x_msg_data
503: );
504:
505: --dbms_output.put_line('4 : '||x_return_status||x_msg_count||x_msg_data);
506: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
507: THEN
508: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
509: l_module, 'completed call to HZ_PARTY_CONTACT_V2PUB.create_org_contact_role'
510: || ' Status ' || x_return_status);

Line 508: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

504:
505: --dbms_output.put_line('4 : '||x_return_status||x_msg_count||x_msg_data);
506: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
507: THEN
508: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
509: l_module, 'completed call to HZ_PARTY_CONTACT_V2PUB.create_org_contact_role'
510: || ' Status ' || x_return_status);
511: END IF;
512:

Line 548: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)

544: p_person_id,
545: 'Y');
546: END IF;
547: ELSE
548: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
549: THEN
550: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
551: l_module,'calling fnd_grants_pkg.grant_function for FUN_TRX_BATCHES');
552: END IF;

Line 550: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

546: END IF;
547: ELSE
548: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
549: THEN
550: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
551: l_module,'calling fnd_grants_pkg.grant_function for FUN_TRX_BATCHES');
552: END IF;
553: --Grant does not exist
554: fnd_grants_pkg.grant_function (

Line 570: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)

566: x_errorcode => l_fnd_errorcode,
567: p_parameter1 => p_org_id
568: );
569:
570: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
571: THEN
572: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
573: l_module, 'completed call to fnd_grants_pkg.grant_function for FUN_TRX_BATCHES'
574: || ' Status ' || x_return_status);

Line 572: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

568: );
569:
570: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
571: THEN
572: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
573: l_module, 'completed call to fnd_grants_pkg.grant_function for FUN_TRX_BATCHES'
574: || ' Status ' || x_return_status);
575: END IF;
576:

Line 582: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)

578: THEN
579: RAISE FND_API.G_EXC_ERROR;
580: END IF;
581:
582: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
583: THEN
584: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
585: l_module,'calling fnd_grants_pkg.grant_function for FUN_TRX_HEADERS');
586: END IF;

Line 584: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

580: END IF;
581:
582: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
583: THEN
584: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
585: l_module,'calling fnd_grants_pkg.grant_function for FUN_TRX_HEADERS');
586: END IF;
587:
588: fnd_grants_pkg.grant_function (

Line 605: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)

601: p_parameter1 => p_org_id
602: );
603:
604:
605: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
606: THEN
607: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
608: l_module, 'completed call to fnd_grants_pkg.grant_function for FUN_TRX_HEADERS'
609: || ' Status ' || x_return_status);

Line 607: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

603:
604:
605: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
606: THEN
607: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
608: l_module, 'completed call to fnd_grants_pkg.grant_function for FUN_TRX_HEADERS'
609: || ' Status ' || x_return_status);
610: END IF;
611:

Line 617: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)

613: THEN
614: RAISE FND_API.G_EXC_ERROR;
615: END IF;
616:
617: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
618: THEN
619: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
620: l_module,'calling fnd_grants_pkg.grant_function for FUN_DIST_LINES');
621: END IF;

Line 619: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

615: END IF;
616:
617: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
618: THEN
619: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
620: l_module,'calling fnd_grants_pkg.grant_function for FUN_DIST_LINES');
621: END IF;
622:
623: fnd_grants_pkg.grant_function (

Line 640: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)

636: p_parameter1 => p_org_id
637: );
638:
639:
640: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
641: THEN
642: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
643: l_module, 'completed call to fnd_grants_pkg.grant_function for FUN_DIST_LINES'
644: || ' Status ' || x_return_status);

Line 642: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

638:
639:
640: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
641: THEN
642: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
643: l_module, 'completed call to fnd_grants_pkg.grant_function for FUN_DIST_LINES'
644: || ' Status ' || x_return_status);
645: END IF;
646:

Line 697: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)

693: l_tca_contact_record.party_rel_rec.start_date := SYSDATE;
694: l_tca_contact_record.party_rel_rec.created_by_module := 'FUN_AGIS';
695: l_tca_contact_record.party_rel_rec.status := 'A';
696:
697: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
698: THEN
699: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
700: l_module,'calling HZ_PARTY_CONTACT_V2PUB.create_org_contact');
701: END IF;

Line 699: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

695: l_tca_contact_record.party_rel_rec.status := 'A';
696:
697: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
698: THEN
699: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
700: l_module,'calling HZ_PARTY_CONTACT_V2PUB.create_org_contact');
701: END IF;
702:
703: HZ_PARTY_CONTACT_V2PUB.create_org_contact(

Line 716: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)

712: x_msg_data => x_msg_data
713: );
714: --dbms_output.put_line('5 : '||x_return_status||x_msg_count||x_msg_data);
715:
716: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
717: THEN
718: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
719: l_module, 'completed call to HZ_PARTY_CONTACT_V2PUB.create_org_contact'
720: || ' Status ' || x_return_status);

Line 718: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

714: --dbms_output.put_line('5 : '||x_return_status||x_msg_count||x_msg_data);
715:
716: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
717: THEN
718: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
719: l_module, 'completed call to HZ_PARTY_CONTACT_V2PUB.create_org_contact'
720: || ' Status ' || x_return_status);
721: END IF;
722:

Line 733: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)

729: l_tca_contact_role_record.status := 'A';
730: l_tca_contact_role_record.org_contact_id := l_org_contact_id;
731: l_tca_contact_role_record.created_by_module := 'FUN_AGIS';
732:
733: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
734: THEN
735: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
736: l_module,'calling HZ_PARTY_CONTACT_V2PUB.create_org_contact_role');
737: END IF;

Line 735: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

731: l_tca_contact_role_record.created_by_module := 'FUN_AGIS';
732:
733: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
734: THEN
735: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
736: l_module,'calling HZ_PARTY_CONTACT_V2PUB.create_org_contact_role');
737: END IF;
738:
739:

Line 749: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)

745: x_msg_count => x_msg_count,
746: x_msg_data => x_msg_data
747: );
748: --dbms_output.put_line('6 : '||x_return_status||x_msg_count||x_msg_data);
749: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
750: THEN
751: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
752: l_module, 'completed call to HZ_PARTY_CONTACT_V2PUB.create_org_contact_role'
753: || ' Status ' || x_return_status);

Line 751: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

747: );
748: --dbms_output.put_line('6 : '||x_return_status||x_msg_count||x_msg_data);
749: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
750: THEN
751: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
752: l_module, 'completed call to HZ_PARTY_CONTACT_V2PUB.create_org_contact_role'
753: || ' Status ' || x_return_status);
754: END IF;
755:

Line 774: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)

770: THEN
771: COMMIT WORK;
772: END IF;
773:
774: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
775: THEN
776: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
777: l_module,'end');
778: END IF;

Line 776: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

772: END IF;
773:
774: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
775: THEN
776: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
777: l_module,'end');
778: END IF;
779:
780: -- standard call to get message count and if count is 1, get message info.

Line 795: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)

791: p_encoded => FND_API.G_FALSE,
792: p_count => x_msg_count,
793: p_data => x_msg_data);
794:
795: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
796: THEN
797: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
798: l_module,'Execution exception raised');
799: END IF;

Line 797: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

793: p_data => x_msg_data);
794:
795: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
796: THEN
797: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
798: l_module,'Execution exception raised');
799: END IF;
800:
801: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 809: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level)

805: p_encoded => FND_API.G_FALSE,
806: p_count => x_msg_count,
807: p_data => x_msg_data);
808:
809: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level)
810: THEN
811: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
812: l_module,'Unexpected exception raised - ' || SQLERRM);
813: END IF;

Line 811: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

807: p_data => x_msg_data);
808:
809: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level)
810: THEN
811: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
812: l_module,'Unexpected exception raised - ' || SQLERRM);
813: END IF;
814:
815: WHEN OTHERS THEN

Line 823: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level)

819: p_encoded => FND_API.G_FALSE,
820: p_count => x_msg_count,
821: p_data => x_msg_data);
822:
823: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level)
824: THEN
825: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
826: l_module,'Unexpected exception raised - ' || SQLERRM);
827: END IF;

Line 825: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

821: p_data => x_msg_data);
822:
823: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level)
824: THEN
825: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
826: l_module,'Unexpected exception raised - ' || SQLERRM);
827: END IF;
828: END create_assign;
829:

Line 879: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)

875: AND grantee_key = 'HZ_PARTY:'||p_person_id ;
876:
877: BEGIN
878:
879: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
880: THEN
881: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
882: l_module,'begin');
883: END IF;

Line 881: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

877: BEGIN
878:
879: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
880: THEN
881: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
882: l_module,'begin');
883: END IF;
884:
885: --Standard call to check for call compatibility.

Line 926: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)

922:
923: FETCH c_grant_info INTO l_grant_guid,l_start_date ;
924: CLOSE c_grant_info ;
925:
926: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
927: THEN
928: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
929: l_module, 'callinge fnd_grants_pkg.update_grant');
930: END IF;

Line 928: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

924: CLOSE c_grant_info ;
925:
926: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
927: THEN
928: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
929: l_module, 'callinge fnd_grants_pkg.update_grant');
930: END IF;
931:
932: IF p_status = 'Y' THEN

Line 950: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)

946: x_success => x_return_status
947: );
948: END IF;
949:
950: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
951: THEN
952: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
953: l_module, 'completed call to fnd_grants_pkg.update_grant '
954: || ' Status ' || x_return_status);

Line 952: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

948: END IF;
949:
950: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
951: THEN
952: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
953: l_module, 'completed call to fnd_grants_pkg.update_grant '
954: || ' Status ' || x_return_status);
955: END IF;
956:

Line 969: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)

965: l_instance_set_headers);
966: FETCH c_grant_info INTO l_grant_guid,l_start_date ;
967: CLOSE c_grant_info ;
968:
969: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
970: THEN
971: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
972: l_module, 'callinge fnd_grants_pkg.update_grant for headers');
973: END IF;

Line 971: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

967: CLOSE c_grant_info ;
968:
969: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
970: THEN
971: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
972: l_module, 'callinge fnd_grants_pkg.update_grant for headers');
973: END IF;
974:
975: IF p_status = 'Y' THEN

Line 993: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)

989: x_success => x_return_status
990: );
991: END IF;
992:
993: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
994: THEN
995: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
996: l_module, 'completed call to fnd_grants_pkg.update_grant for headers'
997: || ' Status ' || x_return_status);

Line 995: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

991: END IF;
992:
993: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
994: THEN
995: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
996: l_module, 'completed call to fnd_grants_pkg.update_grant for headers'
997: || ' Status ' || x_return_status);
998: END IF;
999:

Line 1012: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)

1008: l_instance_set_dist);
1009: FETCH c_grant_info INTO l_grant_guid,l_start_date ;
1010: CLOSE c_grant_info ;
1011:
1012: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
1013: THEN
1014: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1015: l_module, 'calling fnd_grants_pkg.update_grant for dists');
1016: END IF;

Line 1014: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1010: CLOSE c_grant_info ;
1011:
1012: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
1013: THEN
1014: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1015: l_module, 'calling fnd_grants_pkg.update_grant for dists');
1016: END IF;
1017:
1018: IF p_status = 'Y' THEN

Line 1036: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)

1032: x_success => x_return_status
1033: );
1034: END IF;
1035:
1036: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
1037: THEN
1038: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1039: l_module, 'completed call to fnd_grants_pkg.update_grant for dists'
1040: || ' Status ' || x_return_status);

Line 1038: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1034: END IF;
1035:
1036: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
1037: THEN
1038: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1039: l_module, 'completed call to fnd_grants_pkg.update_grant for dists'
1040: || ' Status ' || x_return_status);
1041: END IF;
1042:

Line 1059: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)

1055: p_encoded => FND_API.G_FALSE,
1056: p_count => x_msg_count,
1057: p_data => x_msg_data);
1058:
1059: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
1060: THEN
1061: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1062: l_module,'end');
1063: END IF;

Line 1061: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1057: p_data => x_msg_data);
1058:
1059: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
1060: THEN
1061: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1062: l_module,'end');
1063: END IF;
1064:
1065: EXCEPTION

Line 1074: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)

1070: p_encoded => FND_API.G_FALSE,
1071: p_count => x_msg_count,
1072: p_data => x_msg_data);
1073:
1074: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
1075: THEN
1076: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1077: l_module,'Execution exception raised');
1078: END IF;

Line 1076: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1072: p_data => x_msg_data);
1073:
1074: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
1075: THEN
1076: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1077: l_module,'Execution exception raised');
1078: END IF;
1079:
1080: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1088: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level)

1084: p_encoded => FND_API.G_FALSE,
1085: p_count => x_msg_count,
1086: p_data => x_msg_data);
1087:
1088: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level)
1089: THEN
1090: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
1091: l_module,'Unexpected exception raised - ' || SQLERRM);
1092: END IF;

Line 1090: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

1086: p_data => x_msg_data);
1087:
1088: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level)
1089: THEN
1090: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
1091: l_module,'Unexpected exception raised - ' || SQLERRM);
1092: END IF;
1093:
1094: WHEN OTHERS THEN

Line 1102: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level)

1098: p_encoded => FND_API.G_FALSE,
1099: p_count => x_msg_count,
1100: p_data => x_msg_data);
1101:
1102: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level)
1103: THEN
1104: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
1105: l_module,'Unexpected exception raised - ' || SQLERRM);
1106: END IF;

Line 1104: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

1100: p_data => x_msg_data);
1101:
1102: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level)
1103: THEN
1104: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
1105: l_module,'Unexpected exception raised - ' || SQLERRM);
1106: END IF;
1107:
1108: END update_assign;

Line 1125: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)

1121: RETURN VARCHAR2
1122: IS
1123: l_exists NUMBER;
1124: BEGIN
1125: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
1126: THEN
1127: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1128: 'fun.plsql.fun_security.is_access_allow','begin');
1129: END IF;

Line 1127: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1123: l_exists NUMBER;
1124: BEGIN
1125: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
1126: THEN
1127: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1128: 'fun.plsql.fun_security.is_access_allow','begin');
1129: END IF;
1130:
1131: SELECT 1

Line 1149: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)

1145: AND fg.grantee_type='USER'
1146: AND fg.grantee_key='HZ_PARTY:'||p_person_id
1147: AND fg.parameter1=p_org_id) ;
1148:
1149: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
1150: THEN
1151: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1152: 'fun.plsql.fun_security.is_access_allow','end');
1153: END IF;

Line 1151: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1147: AND fg.parameter1=p_org_id) ;
1148:
1149: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
1150: THEN
1151: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1152: 'fun.plsql.fun_security.is_access_allow','end');
1153: END IF;
1154:
1155: IF l_exists > 0 THEN

Line 1164: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)

1160:
1161:
1162: EXCEPTION
1163: WHEN NO_DATA_FOUND THEN
1164: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
1165: THEN
1166: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1167: 'fun.plsql.fun_security.is_access_allow','end');
1168: END IF;

Line 1166: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1162: EXCEPTION
1163: WHEN NO_DATA_FOUND THEN
1164: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
1165: THEN
1166: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1167: 'fun.plsql.fun_security.is_access_allow','end');
1168: END IF;
1169: RETURN 'N';
1170: END is_access_allow;

Line 1191: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)

1187: l_end_date DATE;
1188: BEGIN
1189:
1190:
1191: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
1192: THEN
1193: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1194: 'fun.plsql.fun_security.is_access_valid','begin');
1195: END IF;

Line 1193: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1189:
1190:
1191: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
1192: THEN
1193: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1194: 'fun.plsql.fun_security.is_access_valid','begin');
1195: END IF;
1196:
1197: SELECT start_date,end_date

Line 1214: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)

1210: AND fg.grantee_key = 'HZ_PARTY:'||p_person_id
1211: AND fg.parameter1 = p_org_id
1212: AND ROWNUM = 1;
1213:
1214: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
1215: THEN
1216: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1217: 'fun.plsql.fun_security.is_access_valid','end');
1218: END IF;

Line 1216: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1212: AND ROWNUM = 1;
1213:
1214: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
1215: THEN
1216: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1217: 'fun.plsql.fun_security.is_access_valid','end');
1218: END IF;
1219:
1220: IF ( (l_start_date IS NULL OR l_start_date <= SYSDATE)