38:
39: BEGIN
40: hr_utility.set_location('pay_ip_startup_util.write_log',10);
41: IF p_message IS NOT NULL THEN
42: fnd_message.set_name('PAY', p_message);
43:
44: IF p_token1 IS NOT NULL THEN
45: fnd_message.set_token('1', p_token1);
46: END IF;
41: IF p_message IS NOT NULL THEN
42: fnd_message.set_name('PAY', p_message);
43:
44: IF p_token1 IS NOT NULL THEN
45: fnd_message.set_token('1', p_token1);
46: END IF;
47:
48: IF p_token2 IS NOT NULL THEN
49: fnd_message.set_token('2', p_token2);
45: fnd_message.set_token('1', p_token1);
46: END IF;
47:
48: IF p_token2 IS NOT NULL THEN
49: fnd_message.set_token('2', p_token2);
50: END IF;
51: IF p_file_type ='LOG' and g_logging = 'Y' THEN
52: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
53: ELSIF p_file_type ='OUTPUT' THEN
48: IF p_token2 IS NOT NULL THEN
49: fnd_message.set_token('2', p_token2);
50: END IF;
51: IF p_file_type ='LOG' and g_logging = 'Y' THEN
52: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
53: ELSIF p_file_type ='OUTPUT' THEN
54: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.GET);
55: ELSE
56: NULL;
50: END IF;
51: IF p_file_type ='LOG' and g_logging = 'Y' THEN
52: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
53: ELSIF p_file_type ='OUTPUT' THEN
54: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.GET);
55: ELSE
56: NULL;
57: END IF;
58: ELSE
1244: FETCH duplicate_structure_check INTO l_exists;
1245:
1246: IF duplicate_structure_check%FOUND then
1247: close duplicate_structure_check;
1248: fnd_message.set_name('PAY', 'PAY_34291_IP_BANK_STRUCT_EXIST');
1249: fnd_message.set_token('TITLE', p_structure_title);
1250: fnd_message.raise_error;
1251: END IF;
1252:
1245:
1246: IF duplicate_structure_check%FOUND then
1247: close duplicate_structure_check;
1248: fnd_message.set_name('PAY', 'PAY_34291_IP_BANK_STRUCT_EXIST');
1249: fnd_message.set_token('TITLE', p_structure_title);
1250: fnd_message.raise_error;
1251: END IF;
1252:
1253: CLOSE duplicate_structure_check;
1246: IF duplicate_structure_check%FOUND then
1247: close duplicate_structure_check;
1248: fnd_message.set_name('PAY', 'PAY_34291_IP_BANK_STRUCT_EXIST');
1249: fnd_message.set_token('TITLE', p_structure_title);
1250: fnd_message.raise_error;
1251: END IF;
1252:
1253: CLOSE duplicate_structure_check;
1254: