65: ', p_department_code = ' || p_department_code ||
66: ', p_x_tasks_tbl.COUNT = ' || p_x_tasks_tbl.COUNT);
67: END IF;
68:
69: -- Standard start of API savepoint
70: SAVEPOINT Create_Planned_Tasks_Pub;
71:
72: -- Initialize Procedure return status to success
73: x_return_status := FND_API.G_RET_STS_SUCCESS;
71:
72: -- Initialize Procedure return status to success
73: x_return_status := FND_API.G_RET_STS_SUCCESS;
74:
75: -- Standard call to check for call compatibility
76: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
77: l_api_name, G_PKG_NAME) THEN
78: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
79: END IF;
120: ' with unit effectivity id ' || p_x_tasks_tbl(p_x_tasks_tbl.FIRST).UNIT_EFFECTIVITY_ID ||
121: ', Visit Task Id = ' || p_x_tasks_tbl(p_x_tasks_tbl.FIRST).VISIT_TASK_ID);
122: END IF;
123:
124: -- Standard check of p_commit
125: IF FND_API.TO_BOOLEAN(p_commit) THEN
126: COMMIT WORK;
127: END IF;
128:
125: IF FND_API.TO_BOOLEAN(p_commit) THEN
126: COMMIT WORK;
127: END IF;
128:
129: -- Standard call to get message count and if count is 1, get message info
130: FND_MSG_PUB.Count_And_Get
131: ( p_count => x_msg_count,
132: p_data => x_msg_data,
133: p_encoded => FND_API.G_FALSE