DBA Data[Home] [Help]

APPS.JTF_TASK_MASS_PUB dependencies on FND_API

Line 36: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

32:
33: -----------------------------------------------------------------------------------------------------
34:
35: PROCEDURE create_mass_tasks( p_api_version IN NUMBER,
36: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
37: p_commit IN VARCHAR2 DEFAULT fnd_api.g_true,
38: x_msg_count OUT NOCOPY NUMBER,
39: x_msg_data OUT NOCOPY VARCHAR2,
40: x_return_status OUT NOCOPY VARCHAR2,

Line 37: p_commit IN VARCHAR2 DEFAULT fnd_api.g_true,

33: -----------------------------------------------------------------------------------------------------
34:
35: PROCEDURE create_mass_tasks( p_api_version IN NUMBER,
36: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
37: p_commit IN VARCHAR2 DEFAULT fnd_api.g_true,
38: x_msg_count OUT NOCOPY NUMBER,
39: x_msg_data OUT NOCOPY VARCHAR2,
40: x_return_status OUT NOCOPY VARCHAR2,
41: p_resource_type IN VARCHAR2,

Line 47: p_copy_notes IN VARCHAR2 DEFAULT fnd_api.g_false,

43: p_task_id IN NUMBER,
44: p_task_number IN VARCHAR2,
45: p_keep_record IN VARCHAR2 DEFAULT NULL,
46: p_keep_resource_id IN NUMBER DEFAULT NULL,
47: p_copy_notes IN VARCHAR2 DEFAULT fnd_api.g_false,
48: p_copy_task_assignments IN VARCHAR2 DEFAULT fnd_api.g_false,
49: p_copy_task_rsc_reqs IN VARCHAR2 DEFAULT fnd_api.g_false,
50: p_copy_task_depends IN VARCHAR2 DEFAULT fnd_api.g_false,
51: p_create_recurrences IN VARCHAR2 DEFAULT fnd_api.g_false,

Line 48: p_copy_task_assignments IN VARCHAR2 DEFAULT fnd_api.g_false,

44: p_task_number IN VARCHAR2,
45: p_keep_record IN VARCHAR2 DEFAULT NULL,
46: p_keep_resource_id IN NUMBER DEFAULT NULL,
47: p_copy_notes IN VARCHAR2 DEFAULT fnd_api.g_false,
48: p_copy_task_assignments IN VARCHAR2 DEFAULT fnd_api.g_false,
49: p_copy_task_rsc_reqs IN VARCHAR2 DEFAULT fnd_api.g_false,
50: p_copy_task_depends IN VARCHAR2 DEFAULT fnd_api.g_false,
51: p_create_recurrences IN VARCHAR2 DEFAULT fnd_api.g_false,
52: p_copy_task_references IN VARCHAR2 DEFAULT fnd_api.g_false,

Line 49: p_copy_task_rsc_reqs IN VARCHAR2 DEFAULT fnd_api.g_false,

45: p_keep_record IN VARCHAR2 DEFAULT NULL,
46: p_keep_resource_id IN NUMBER DEFAULT NULL,
47: p_copy_notes IN VARCHAR2 DEFAULT fnd_api.g_false,
48: p_copy_task_assignments IN VARCHAR2 DEFAULT fnd_api.g_false,
49: p_copy_task_rsc_reqs IN VARCHAR2 DEFAULT fnd_api.g_false,
50: p_copy_task_depends IN VARCHAR2 DEFAULT fnd_api.g_false,
51: p_create_recurrences IN VARCHAR2 DEFAULT fnd_api.g_false,
52: p_copy_task_references IN VARCHAR2 DEFAULT fnd_api.g_false,
53: p_copy_task_dates IN VARCHAR2 DEFAULT fnd_api.g_false) IS

Line 50: p_copy_task_depends IN VARCHAR2 DEFAULT fnd_api.g_false,

46: p_keep_resource_id IN NUMBER DEFAULT NULL,
47: p_copy_notes IN VARCHAR2 DEFAULT fnd_api.g_false,
48: p_copy_task_assignments IN VARCHAR2 DEFAULT fnd_api.g_false,
49: p_copy_task_rsc_reqs IN VARCHAR2 DEFAULT fnd_api.g_false,
50: p_copy_task_depends IN VARCHAR2 DEFAULT fnd_api.g_false,
51: p_create_recurrences IN VARCHAR2 DEFAULT fnd_api.g_false,
52: p_copy_task_references IN VARCHAR2 DEFAULT fnd_api.g_false,
53: p_copy_task_dates IN VARCHAR2 DEFAULT fnd_api.g_false) IS
54:

Line 51: p_create_recurrences IN VARCHAR2 DEFAULT fnd_api.g_false,

47: p_copy_notes IN VARCHAR2 DEFAULT fnd_api.g_false,
48: p_copy_task_assignments IN VARCHAR2 DEFAULT fnd_api.g_false,
49: p_copy_task_rsc_reqs IN VARCHAR2 DEFAULT fnd_api.g_false,
50: p_copy_task_depends IN VARCHAR2 DEFAULT fnd_api.g_false,
51: p_create_recurrences IN VARCHAR2 DEFAULT fnd_api.g_false,
52: p_copy_task_references IN VARCHAR2 DEFAULT fnd_api.g_false,
53: p_copy_task_dates IN VARCHAR2 DEFAULT fnd_api.g_false) IS
54:
55: l_api_version CONSTANT NUMBER := 1.0;

Line 52: p_copy_task_references IN VARCHAR2 DEFAULT fnd_api.g_false,

48: p_copy_task_assignments IN VARCHAR2 DEFAULT fnd_api.g_false,
49: p_copy_task_rsc_reqs IN VARCHAR2 DEFAULT fnd_api.g_false,
50: p_copy_task_depends IN VARCHAR2 DEFAULT fnd_api.g_false,
51: p_create_recurrences IN VARCHAR2 DEFAULT fnd_api.g_false,
52: p_copy_task_references IN VARCHAR2 DEFAULT fnd_api.g_false,
53: p_copy_task_dates IN VARCHAR2 DEFAULT fnd_api.g_false) IS
54:
55: l_api_version CONSTANT NUMBER := 1.0;
56: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_TASK';

Line 53: p_copy_task_dates IN VARCHAR2 DEFAULT fnd_api.g_false) IS

49: p_copy_task_rsc_reqs IN VARCHAR2 DEFAULT fnd_api.g_false,
50: p_copy_task_depends IN VARCHAR2 DEFAULT fnd_api.g_false,
51: p_create_recurrences IN VARCHAR2 DEFAULT fnd_api.g_false,
52: p_copy_task_references IN VARCHAR2 DEFAULT fnd_api.g_false,
53: p_copy_task_dates IN VARCHAR2 DEFAULT fnd_api.g_false) IS
54:
55: l_api_version CONSTANT NUMBER := 1.0;
56: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_TASK';
57: BEGIN

Line 66: x_return_status := fnd_api.g_ret_sts_success;

62:
63: --
64: -- initialize API return status to success
65: --
66: x_return_status := fnd_api.g_ret_sts_success;
67:
68: --
69: -- Standard call to check for call compatibility
70: --

Line 71: IF NOT fnd_api.compatible_api_call (

67:
68: --
69: -- Standard call to check for call compatibility
70: --
71: IF NOT fnd_api.compatible_api_call (
72: l_api_version,
73: p_api_version,
74: l_api_name,
75: g_pkg_name

Line 78: RAISE fnd_api.g_exc_unexpected_error;

74: l_api_name,
75: g_pkg_name
76: )
77: THEN
78: RAISE fnd_api.g_exc_unexpected_error;
79: END IF;
80:
81: --
82: -- Initialize message list if p_init_msg_list is set to TRUE

Line 84: IF fnd_api.to_boolean (p_init_msg_list)

80:
81: --
82: -- Initialize message list if p_init_msg_list is set to TRUE
83: --
84: IF fnd_api.to_boolean (p_init_msg_list)
85: THEN
86: fnd_msg_pub.initialize;
87: END IF;
88:

Line 93: p_init_msg_list => fnd_api.g_false,

89: --
90: --Call the private package JTF_TASK_MASS_CREATE_PVT to create tasks
91: --
92: jtf_task_mass_pvt.create_mass_tasks( p_api_version => 1.0,
93: p_init_msg_list => fnd_api.g_false,
94: x_msg_count => x_msg_count,
95: x_msg_data => x_msg_data,
96: x_return_status => x_return_status,
97: p_resource_type => p_resource_type,

Line 106: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

102: p_keep_resource_id => p_keep_resource_id,
103: p_copy_notes => p_copy_notes,
104: p_copy_task_references => 'T');
105:
106: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
107: x_return_status := fnd_api.g_ret_sts_unexp_error;
108: RAISE fnd_api.g_exc_unexpected_error;
109: ELSIF (x_return_status = fnd_api.g_ret_sts_success) THEN
110: If p_commit = 'T' then

Line 107: x_return_status := fnd_api.g_ret_sts_unexp_error;

103: p_copy_notes => p_copy_notes,
104: p_copy_task_references => 'T');
105:
106: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
107: x_return_status := fnd_api.g_ret_sts_unexp_error;
108: RAISE fnd_api.g_exc_unexpected_error;
109: ELSIF (x_return_status = fnd_api.g_ret_sts_success) THEN
110: If p_commit = 'T' then
111: commit;

Line 108: RAISE fnd_api.g_exc_unexpected_error;

104: p_copy_task_references => 'T');
105:
106: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
107: x_return_status := fnd_api.g_ret_sts_unexp_error;
108: RAISE fnd_api.g_exc_unexpected_error;
109: ELSIF (x_return_status = fnd_api.g_ret_sts_success) THEN
110: If p_commit = 'T' then
111: commit;
112: end if;

Line 109: ELSIF (x_return_status = fnd_api.g_ret_sts_success) THEN

105:
106: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
107: x_return_status := fnd_api.g_ret_sts_unexp_error;
108: RAISE fnd_api.g_exc_unexpected_error;
109: ELSIF (x_return_status = fnd_api.g_ret_sts_success) THEN
110: If p_commit = 'T' then
111: commit;
112: end if;
113: END IF;

Line 117: WHEN fnd_api.g_exc_unexpected_error

113: END IF;
114:
115:
116: EXCEPTION
117: WHEN fnd_api.g_exc_unexpected_error
118: THEN
119: ROLLBACK TO create_mass_task_pub;
120: x_return_status := fnd_api.g_ret_sts_unexp_error;
121: fnd_msg_pub.count_and_get (

Line 120: x_return_status := fnd_api.g_ret_sts_unexp_error;

116: EXCEPTION
117: WHEN fnd_api.g_exc_unexpected_error
118: THEN
119: ROLLBACK TO create_mass_task_pub;
120: x_return_status := fnd_api.g_ret_sts_unexp_error;
121: fnd_msg_pub.count_and_get (
122: p_count => x_msg_count,
123: p_data => x_msg_data
124: );

Line 130: x_return_status := fnd_api.g_ret_sts_unexp_error;

126: THEN
127: ROLLBACK TO create_mass_task_pub;
128: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
129: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
130: x_return_status := fnd_api.g_ret_sts_unexp_error;
131: fnd_msg_pub.count_and_get (
132: p_count => x_msg_count,
133: p_data => x_msg_data
134: );