DBA Data[Home] [Help]

APPS.OKS_DEFAULTS_PUB dependencies on FND_LOG

Line 33: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

29: l_infinite_date DATE := TO_DATE(5373484,'j');
30:
31: BEGIN
32:
33: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
34: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
35: 'Entered '||G_PKG_NAME ||'.'||l_api_name );
36: END IF;
37:

Line 34: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

30:
31: BEGIN
32:
33: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
34: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
35: 'Entered '||G_PKG_NAME ||'.'||l_api_name );
36: END IF;
37:
38: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 38: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

34: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
35: 'Entered '||G_PKG_NAME ||'.'||l_api_name );
36: END IF;
37:
38: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
39: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
40: 'ID '||p_id ||' JTOT Obj Code '||p_jtot_object_code);
41: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
42: 'Party/Org id ' || p_org_or_party_id ||

Line 39: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

35: 'Entered '||G_PKG_NAME ||'.'||l_api_name );
36: END IF;
37:
38: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
39: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
40: 'ID '||p_id ||' JTOT Obj Code '||p_jtot_object_code);
41: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
42: 'Party/Org id ' || p_org_or_party_id ||
43: ' Start Date ' || to_char(p_start_date,'DD-MON-RRRR') ||

Line 41: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

37:
38: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
39: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
40: 'ID '||p_id ||' JTOT Obj Code '||p_jtot_object_code);
41: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
42: 'Party/Org id ' || p_org_or_party_id ||
43: ' Start Date ' || to_char(p_start_date,'DD-MON-RRRR') ||
44: ' End Date ' || to_char(p_end_date,'DD-MON-RRRR'));
45: END IF;

Line 49: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

45: END IF;
46:
47: FOR dup_check_rec IN csr_duplicate_check
48: LOOP
49: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
50: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
51: 'ID '||dup_check_rec.id || ' Start Date ' || to_char(dup_check_rec.start_date,'DD-MON-RRRR') ||
52: ' End Date ' || to_char(dup_check_rec.end_date,'DD-MON-RRRR'));
53: END IF;

Line 50: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

46:
47: FOR dup_check_rec IN csr_duplicate_check
48: LOOP
49: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
50: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
51: 'ID '||dup_check_rec.id || ' Start Date ' || to_char(dup_check_rec.start_date,'DD-MON-RRRR') ||
52: ' End Date ' || to_char(dup_check_rec.end_date,'DD-MON-RRRR'));
53: END IF;
54: IF p_id IS NULL OR p_id <> dup_check_rec.id THEN

Line 74: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

70: EXIT;
71: END IF; -- duplicate record found with dates overlap
72: END IF;
73: END LOOP;
74: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
75: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
76: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' x_overlap_yn='||x_overlap_yn);
77: END IF;
78: RETURN x_overlap_yn;

Line 75: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

71: END IF; -- duplicate record found with dates overlap
72: END IF;
73: END LOOP;
74: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
75: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
76: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' x_overlap_yn='||x_overlap_yn);
77: END IF;
78: RETURN x_overlap_yn;
79: EXCEPTION

Line 81: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

77: END IF;
78: RETURN x_overlap_yn;
79: EXCEPTION
80: WHEN OTHERS THEN
81: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
82: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
83: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.Others sqlcode = '
84: ||SQLCODE||', sqlerrm = '||SQLERRM);
85: END IF;

Line 82: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,

78: RETURN x_overlap_yn;
79: EXCEPTION
80: WHEN OTHERS THEN
81: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
82: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
83: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.Others sqlcode = '
84: ||SQLCODE||', sqlerrm = '||SQLERRM);
85: END IF;
86: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );